To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115812 Issue #|115812 Summary|Wrong formulas when saving spreadsheet in Excel 2003 | XML format Component|Spreadsheet Version|current Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|ydubinsky
------- Additional comments from [email protected] Sun Nov 28 04:35:31 +0000 2010 ------- Probably this issue is similar to 66258 (Formulas not saved well in Excel 2003 XML file) and few others. when I save a simple sheet with the simple formula =SUM(A2:A5) the formula is saved as "of:]=SUM([.A2:.A5])" that is weird. (Linux and Windows) And another simple formula "=A3+B6" is written as "of:]=[.A3]+[.B6]" i think that Excel 2003 xml is an useful option to generate a file with pretty complicated spreadsheet data inside and if OO supports it the support should be a real one. In many cases Calc is crashing or stops to respond when saving as 2003 xml file. --------------------------------------------------------------------- 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]
