https://bugs.freedesktop.org/show_bug.cgi?id=79282
Priority: medium Bug ID: 79282 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: Calc FILEOPEN: On opening excel XLSX function INDEX() is removed from formula Severity: normal Classification: Unclassified OS: Windows (All) Reporter: sver...@web.de Hardware: Other Status: UNCONFIRMED Version: 4.2.4.2 release Component: Spreadsheet Product: LibreOffice On opening a Excel XLSX file the formula: SUMPRODUCT((MOD(COLUMN($D73:INDEX($D73:$AA73,0,1+MATCH($R$2,$D$70:$Z$70,0))),2)=0)*$D73:INDEX($D73:$AA73,0,1+MATCH($R$2,$D$70:$Z$70,0))) will be changed to SUMPRODUCT((MOD(COLUMN($D73:D73($D73:$AA73,0,1+MATCH($R$2,$D$70:$Z$70,0))),2)=0)*$D73:D73($D73:$AA73,0,1+MATCH($R$2,$D$70:$Z$70,0))) »INDEX(« is replaced by »D73(« So the spreadsheet does not work anymore. I can manually replace »D73(« by »INDEX(« and the function works again - BUT - after saving the file as XLSX and reopening it the »INDEX(« disappeares again! I hope it will be fixed soon. Nevertheless great software! -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs