| Summary: | bug in LOOKUP Function | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Scott Benninghoff <scott.benninghoff> |
| Component: | Calc | Assignee: | Kohei Yoshida <kohei> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | major | CC: | gerard.fargeot |
| Priority: | medium | ||
| Version: | unspecified | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Spreadsheet showing error in Lookup Function (Save into /tmp | ||
for kohei I guess |
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