To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=106237
User aguelzow changed the following:
What |Old value |New value
================================================================================
Keywords|needmoreinfo, oooqa |oooqa
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Sat Oct 24 16:26:06
+0000 2009 -------
The saved file contains:
<table:table-cell table:style-name="ce2"
table:formula="of:=org.gnumeric.pentecostsunday([.A2])" office:value-type="date"
office:date-value="1899-12-30"><text:p>#NAME?</text:p></table:table-cell>
I guess I was to hasty to say that "It should either preserve the old values, or
not include values at all!" but what Openoffice is currently doing is not
correct:
OpenOffice clearly obtains #NAME? ie. an error value as the result of trying to
attmpt this calculation. According to 4.5 of the ODF 1.2 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."
So it is incorrect to use: office:value-type="date"
office:date-value="1899-12-30".
(It would be my perhaps incorrect interpretation that OOo could claim it was
unable to perform any calculation, in that case I think it should store the old
value.)
So this might in fact be the same bug as issue #102958 which hasn't drawn any
attention since I filed it last June.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
