Issue 102958 - ODFF: errors incorrectly saved
Summary: ODFF: errors incorrectly saved
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:
Keywords: oooqa
: 106237 (view as issue list)
Depends on:
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: ---


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 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

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

*** 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. ***