Issue 102958 - ODFF: errors incorrectly saved
Summary: ODFF: errors incorrectly saved
Status: REOPENED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 3.1
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
: 106237 (view as issue list)
Depends on:
Blocks:
 
Reported: 2009-06-19 18:44 UTC by aguelzow
Modified: 2013-08-07 15:13 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description aguelzow 2009-06-19 18:44:26 UTC 
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.
Comment 1 Regina Henschel 2009-10-24 19:03:31 UTC 
I can see the described content. It might be the same problem as in issue 106237.
Comment 2 ooo 2009-10-26 14:09:52 UTC 
Indeed.

*** This issue has been marked as a duplicate of 106237 ***
Comment 3 ooo 2009-10-26 14:10:57 UTC 
Closing dup.
Comment 4 ooo 2009-10-26 14:15:58 UTC 
Bah, reopening this in favour over 106237. Sorry for spamming.
Comment 5 ooo 2009-10-26 14:17:59 UTC 
*** Issue 106237 has been marked as a duplicate of this issue. ***