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
