To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103677 Issue #|103677 Summary|Modified formula in remote cells after an import from |Excel 2003 (.XLS) Component|Spreadsheet Version|OOo 3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|lanciaux
------- Additional comments from [email protected] Mon Jul 20 21:32:15 +0000 2009 ------- Hello, I've noticed this bug a long time ago (for sure in 3.0.x). Today, I take a strong example to help describing it. It happens when you open a binary 2003 XLS file - some remote cells have their references in formula changed (shifted a lot to the right in fact). Here you will find 2 files - first is a OOO 3.1 Calc (Excel_formula_import.xls) file exported to a Excel file (for convenience because same trouble arises also with a "fresh" Excel file). I've written back after one modification with Excel 2003 to a second file (Excel_formula_import_in_OOO.xls). So, those two files should be similar - they are almost ... here is the catch with Excel (true formula in cell) compared to OOO (false formula in cell) : Example 1 : EW6 (=N6 OK) compared to imported EW6 (=JJ6 NOK) Example 2 : FA6 (=M6+N6 OK) compared to imported FA6 (=JI6+JJ6 NOK) Hope this will help finding an issue because when you have a large file with a lot of columns, it is quite tricky to find what is wrong. Ludovic (Belgium) --------------------------------------------------------------------- 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]
