Created attachment 47604 [details]
In the attached file we have:
<table:table-cell table:formula="of:=1/0" office:value-type="float" office:value="0"><text:p>#DIV/0!</text:p></table:table-cell>
This conflicts with the ODF1.2 specification that specifies in Part 2 4.6 Error:
"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."
So the office:value-type in this case must be "string", not "float". This file currently incorrectly claims that the result of "of:=1/0" is 0!
Thorsten, can you please look into this?
Eike: OpenFormula looks like your playground...
With LO 220.127.116.11 (Win7 32bit), that file shows result #DIV/0!
Perhaps it's been fixed?
It's not about what is displayed but how it is stored in the .ods file.
You wanted to tackle that after the cached values / inherited number formats, if I'm not mistaken?
This should be fixed in 4.1 and master with my error value export. At least I thought so.
I'll check it but I closed my bug report for it.
*** This bug has been marked as a duplicate of bug 51810 ***
Ah yes, my bad, I only checked 4.0.4; it's already in 4.1