To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95256 Issue #|95256 Summary|Wrong cell references when loading MS EXCEL 2003 SP2 s |preadsheet Component|Spreadsheet Version|OOO300m9 Platform|HP URL| OS/Version|Windows 2003 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|suijdam
------- Additional comments from [EMAIL PROTECTED] Tue Oct 21 11:12:59 +0000 2008 ------- The failing spreadsheet contains references to cells in the same sheet. The original spreadsheet was created in MS EXCEL 2003 SP2 and works fine for a couple of moths already. Loading this spreadsheet into SCALC results in having some cell references to be pointing to a completely differrent cell. Worksheets Q1 2008 tot Q4 2008 all show the same behaviour. See Cell FM5 which contains a formula that references a number of cells including E5. Opening this sheet iin SCALC FM5 holds the same formula but the reference to E5 is changed to JA5. Also if the sheet in transformed to an ODF file, and this is used to crete a new xls file, opening this XLS will show the same errors. --------------------------------------------------------------------- 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]