We have a quite complex spreadsheet which uses data from other xls and ods files.
It contains some INDEX functions, which operates on those data (as a side-note, the MATCH functions, which also works from the same files are working as expected).
The spreadsheet was created originally with an ancient version of Openoffice (the Hungarian version, based on go-ooo sources) and later used without problems with each version of Openoffice up until 3.2.1. The problem appeared at upgrading to LibreOffice 3.3.0, and later 3.3.1. At the same time, if I try to reproduce the problem creating a new spreadsheet with only one INDEX function in it, with the cell range from an other spreadsheet, after closing the function wizard, the reference to the other file ('file://....) disappears and Calc errors about a wrong formula.
I just fixed this on master. The fix will be in 3.4.
*** This bug has been marked as a duplicate of bug 34356 ***
Actually, does INDEX work outside the function wizard?
I'll take this.
(In reply to comment #2)
> Actually, does INDEX work outside the function wizard?
No it doesn't!
Actually testing it further it seems that there are two distinct bugs:
1. INDEX trowing error with cell range from other file
2. Function wizard deleting cell ranges from formulas if cell ranges from other file (checked with INDEX and MATCH functions)
(In reply to comment #1)
> I just fixed this on master. The fix will be in 3.4.
> *** This bug has been marked as a duplicate of bug 34356 ***
Checking 34356 it seems, that my last posts second problem is already reported (#34356), but the original bug is still new:
INDEX function, with an already existing reference to external data gives error.
Yes, the bug regarding the function wizard is fixed now, but I still need to adopt the INDEX function to handle external references.
Fixed this on master.