Issue 103883 - ODF 1.2 type of stored errors is wrong
Summary: ODF 1.2 type of stored errors is wrong
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO310m14
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-07-29 19:17 UTC by Regina Henschel
Modified: 2020-11-15 12:35 UTC (History)
3 users (show)

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

Attachments
File with calculated errors (8.74 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-16 16:19 UTC, Regina Henschel 		no flags Details
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 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.