Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Lotus .wk1 import filter can't handle formulas containing relative column references >128 | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | freakout42 <ooo> | ||||
Component: | open-import | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues | ||||
Version: | OOo 2.4.0 | ||||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
URL: | http://www.bnhof.de/~ho1158/rel128.wk1 | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
freakout42
2008-06-11 10:55:43 UTC
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. |