To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102958 Issue #|102958 Summary|errors incorrectly saved Component|Spreadsheet Version|OOo 3.1 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|aguelzow
------- Additional comments from [email protected] Fri Jun 19 17:44:26 +0000 2009 ------- Openoffice.org files claim to be ODF 1.22 with OpenFormula. According to the current OpenFormula draft: In an OpenDocument document, if an error value is the result of a cell computation it shall be stored as if it was a string. That is, the office:value-type of an error value is string; if the computed value is stored, it is stored in the attribute office:string-value. Note that this does not change an error into a string type (since the error will be restored on recalculation); this simply enables applications which cannot recalculate values to display the error information. Currently in OOo, calculating FLOOR(-2.5) shows as an error but is saved with value-type float and value 0, causing other applications to display the calculated value incorrectly. --------------------------------------------------------------------- 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]
