Bug 79282 - Calc FILEOPEN: On opening excel XLSX function INDEX() is removed from formula
Summary: Calc FILEOPEN: On opening excel XLSX function INDEX() is removed from formula
Status: CLOSED DUPLICATE of bug 73210
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.6.2 release
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-26 23:12 UTC by sverson
Modified: 2014-05-27 00:42 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***