Download it now!
Bug 51810 - openformula requires error values written as office:value-type="string"
Summary: openformula requires error values written as office:value-type="string"
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: Other All
: medium normal
Assignee: Markus Mohrhard
Whiteboard: odf odf_validation target:4.1.0
: 37993 (view as bug list)
Depends on:
Reported: 2012-07-06 18:52 UTC by Markus Mohrhard
Modified: 2013-06-24 15:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Markus Mohrhard 2012-07-06 18:52:59 UTC
Currently we seem to store error values not according to OpenFormula.

OpenFormula requires us to store error values as string and not as value. See

Currently we write entries like: 

<table:table-cell table:formula="of:=SQRT(-1)" office:value-type="float" office:value="0">
Comment 1 Commit Notification 2013-04-25 15:11:33 UTC
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

add error to office:value-type for calc cells and fdo#51810

The patch should be included in the daily builds available at in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Comment 2 Markus Mohrhard 2013-06-24 13:49:23 UTC
*** Bug 37993 has been marked as a duplicate of this bug. ***