Created attachment 42588 [details]
Spreadsheet showing error in Lookup Function (Save into /tmp
I think I've discovered a bug in LibreOffice Calc.
I've been using OpenOffice for past 5 years and it's a great product.
I have a spreadsheet in Calc for doing expense reporting. This spreadsheet does a LOOKUP against an external file / spreadsheet. While I was using OpenOffice this function worked flawlessly. This month I decided to upgrade to LibreOffice and have now discovered that the LOOKUP function against an external spreadsheet fails with error:
Error in Parameter List
My formula is:
=LOOKUP(MONTH(B6),'file:///tmp/exampleerrorlookup.ods'#$'expense Report'.I39:T39,'file:///tmp/exampleerrorlookup.ods'#$'expense Report'.I51:T51)
Same Data, same Formula.
B6 is a valid Date field.
Lookup Table Data is:
The Lookup is Month(B6)
Where the Search Row is (1, 2, 3, 4...)
and the results are: (77, 74.06, 74.22, 73.25...)
I tested by making a lookup in the same spreadsheet and LOOKUP works fine.
I attached a copy of my expense report Template showing the error. I put in the lookup data into the spreadsheet to show that when the function is called locally (same file) the function works, but when it's called externally (external file) it fails. Hope this helps.
To get the spreadsheet working, save the file in /tmp on your local system.
for kohei I guess
*** This bug has been marked as a duplicate of bug 33426 ***