https://bugs.documentfoundation.org/show_bug.cgi?id=145560
Michael Warner <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #3 from Michael Warner <[email protected]> --- >From email: Attached is a Lotus 1-2-3 file that shows the problem. This is not the file that I first found the problem, but a much simpler file that shows the problem. The file that first showed the problem is too large with too much personal info. In the attached file, Input a income amount in cell E4 and cell F4 should show the amount of taxes. When you first import the spreadsheet into Libre calc cell C4 shows 20000 and cell F4 shows 2002 which is correct but when the spreadsheet is recalculated cell F4 shows Err:502. Simply re enter 20000 or any number into cell E4 to recalculate the spreadsheet and see the error. I figured out what is causing the problem, but not a easy fix. The problem is caused by the index number in the VLOOKUP function. VLOOKUP is looking for a number in column A,B or C of the spreadsheet depending on the index number. Lotus 1-2-3 wants the index numbers to start at 0. In this case, Columns A,B or C would be 0,1 or 2. Libre Calc wants the index numbers to start at 1. In this case, Columns A,B or C should be 1,2 or 3. I could change the index numbers after the file is imported, but this requires a lot of work as my spreadsheets are very large. This would work if it was a one time import but I must maintain the file on an older computer because of the Lotus Macro language programing in the file. I wish to import the file to another computer that will not run Lotus 1-2-3 but as you can see from the attached file the VLOOKUP function does not work. Thank you for your assistance Stuart Sabatini -- You are receiving this mail because: You are the assignee for the bug.
