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:

Err:504
Error in Parameter List

My formula is: 

This Fails:
=LOOKUP(MONTH(B6),'file:///tmp/exampleerrorlookup.ods'#$'expense Report'.I39:T39,'file:///tmp/exampleerrorlookup.ods'#$'expense Report'.I51:T51)

This Works:
=LOOKUP(MONTH(B6), I39:T39,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.

Please advise.  

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.

Best Regards, 
Scott Benninghoff