Bug 79282

Summary:	Calc FILEOPEN: On opening excel XLSX function INDEX() is removed from formula
Product:	LibreOffice	Reporter:	sverson <sverson>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	CLOSED DUPLICATE
Severity:	major	CC:	suokunlong
Priority:	medium
Version:	4.1.6.2 release
Hardware:	All
OS:	All
See Also:	https://bugs.freedesktop.org/show_bug.cgi?id=73210 https://bugs.freedesktop.org/show_bug.cgi?id=70455
Whiteboard:
Crash report or crash signature:		Regression By:

Description sverson 2014-05-26 23:12:11 UTC

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!

Comment 1 Eike Rathke 2014-05-27 00:22:40 UTC

Simple test case to reproduce:
1. In A1 enter =SUM(B1:INDEX(C1:C3,2,1,1))
2. result is sum of B1:C2
3. save as .xlsx
4. reload
5. formula in A1 is =SUM(B1:B1(C1:C3,2,1,1))
6. result is error

Works fine if saved and reloaded as .ods

Already doesn't work in 4.1.6

Comment 2 Eike Rathke 2014-05-27 00:30:39 UTC


*** This bug has been marked as a duplicate of bug 73210 ***