Apache OpenOffice (AOO) Bugzilla – Issue 90607
Lotus .wk1 import filter can't handle formulas containing relative column references >128
Last modified: 2013-01-29 21:42:17 UTC
When a .WK1 file containing formulas with relative column references >128 is loaded the cells have #REF errors. With Microsoft Excel these files load correctly. A File demonstrating the issue can be found: http://www.bnhof.de/~ho1158/rel128.wk1 The corresponding data type in the Lotus wk1-format is a "signed short" - negative value mean "relative". There must be a wrong cast in the filter to a signed char probably.
Created attachment 54396 [details] Testfile reproducing the defect
freakout42, please describe how we can reproduce this issue step by step. If possible, please tell me which operating systems do you use to reproduce this issue, is this issue reproducible in all kinds of operateing systems?
This can easyly be reproduced on all platforms by opening the file rel128.wk1 with any openoffice release. This file rel128.wk1 is already attached to this case. From the row 7 on the results are defect. The cell A6 references cell DX1 and A7 references DY1. Excel loads the file corrctly. The defect is already clearly described in the cases description.
In BEB300_m2, on WinXP. I think I really understand your explaination. But I can't reproduce this by the following steps. 1. Open the file rel128.wk1 2. In sheet1, found #REF errors from A7 to A9, but A6 showed very well. 3. Insert a new sheet named sheet2 into rel128.wk1 4. In sheet2,from A1 to A5, input 1 2 3 4 5 in each cell From DX1 to EA1, input 1 2 3 4 in each cell then, cell A6 refers to DX1,cell A7 refers to DY1, cell A8 refers to DZ1,cell A9 refers to EA1. Result: #REF errors doesn't happen. So, I wonder if you can reproduce it in BEB300_m2 on WinXP with a new lotus *.wk1 file or not.
>1. Open the file rel128.wk1 >2. In sheet1, found #REF errors from A7 to A9, but A6 showed very well. >3. Insert a new sheet named sheet2 into rel128.wk1 >4. In sheet2,from A1 to A5, input 1 2 3 4 5 in each cell > From DX1 to EA1, input 1 2 3 4 in each cell > then, cell A6 refers to DX1,cell A7 refers to DY1, > cell A8 refers to DZ1,cell A9 refers to EA1. You cannot reproduce the bug in this way because in Step-4 you are working with openoffice already - but the bug is in the converter which reads the ref128.wk1- file into openoffice. To reproduce the bug in this way you must save the sheet in Lotus-WK1 format and re-read the file into openoffice. openoffice can only read wk1-format but not write it. You would need a Lotus-spreadsheet or maybe Excel can do that. We have our own utility to produce wk1-files.
Hi freakout42, I have reproduced the problem by create a WK1 file with Excel and open it with OpenOffice. My version is OOo-Dev_DEV300_m28_Win32Intel_install_en-US.
Set to new.