[sc-issues] [Issue 90607] Lotus .wk1 import filter c an't handle formulas containing relative colum n references 128
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90607 User redflagzhulihua changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Fri Aug 22 09:39:47 + 2008 --- Set to new. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 90607] Lotus .wk1 import filter c an't handle formulas containing relative colum n references 128
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90607 --- Additional comments from [EMAIL PROTECTED] Mon Aug 11 02:41:41 + 2008 --- 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. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 90607] Lotus .wk1 import filter c an't handle formulas containing relative colum n references 128
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90607 --- Additional comments from [EMAIL PROTECTED] Fri Jul 11 06:32:41 + 2008 --- 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. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 90607] Lotus .wk1 import filter c an't handle formulas containing relative colum n references 128
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90607 --- Additional comments from [EMAIL PROTECTED] Thu Jul 10 08:01:21 + 2008 --- 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? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 90607] Lotus .wk1 import filter c an't handle formulas containing relative colum n references 128
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90607 --- Additional comments from [EMAIL PROTECTED] Thu Jul 10 10:23:51 + 2008 --- 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. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 90607] Lotus .wk1 import filter c an't handle formulas containing relative colum n references 128
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90607 --- Additional comments from [EMAIL PROTECTED] Fri Jul 11 05:50:14 + 2008 --- 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. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 90607] Lotus .wk1 import filter c an't handle formulas containing relative colum n references 128
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90607 --- Additional comments from [EMAIL PROTECTED] Wed Jun 11 09:59:18 + 2008 --- Created an attachment (id=54396) Testfile reproducing the defect - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 90607] Lotus .wk1 import filter c an't handle formulas containing relative colum n references 128
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90607 Issue #|90607 Summary|Lotus .wk1 import filter can't handle formulas contain |ing relative column references 128 Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL|http://www.bnhof.de/~ho1158/rel128.wk1 OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|freakout42 --- Additional comments from [EMAIL PROTECTED] Wed Jun 11 09:55:43 + 2008 --- 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. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
