Issue 103883

Summary: ODF 1.2 type of stored errors is wrong
Product: Calc Reporter: Regina Henschel <rb.henschel>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues, mseidel
Version: OOO310m14   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
File with calculated errors none

Description Regina Henschel 2009-07-29 19:17:00 UTC
Accoring to draft12 spec (8.May 2009) section 4.5 an error should be stored as
string, using office:value-type="string" and the error itself stored in
office:string-value.

OOo3.1 stores it for example as
<table:table-cell table:formula="of:=EXP(800)" office:value-type="float"
office:value="0">
<text:p>#NUM!</text:p>
</table:table-cell>

instead of
<table:table-cell table:formula="of:=EXP(800)" office:value-type="string"
office:string-value="#NUM!">
<text:p>#NUM!</text:p>
</table:table-cell>
Comment 1 Edwin Sharp 2014-01-16 10:38:59 UTC
Please specify steps to reproduce bug.
Comment 2 Regina Henschel 2014-01-16 16:19:40 UTC
Created attachment 82305 [details]
File with calculated errors

Open the attached document, to see how the errors are created. Store the document. Unpack the file and examine 'content.xml'. Compare the source written by AOO with specification, linked above. In the final specification it is now paragraph 3 in section 4.6.
Comment 3 Edwin Sharp 2014-01-16 17:20:24 UTC
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1558424
Rev.1558424
Win 7
Thank you Regina.