OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [Formula SC] Treating errors as strings?

I am confused by what section 4.5 of the OpenFormula specification is trying 
to say.

If the result of a calculation results in an error, then the result of 
calculations on that result either could propagate the error, or treat the 
error as a string. 
For example LEN(1/0) could be Error (or #VALUE!, however the error is 
presented), or it could be a integer (5 or 7, depending on the length of the 

Perhaps Section 4.5 should say that "calculations taking inputs that are Error 
values shall result in Error, except where a specific exception to this rule 
is defined in the formula or operator part of this specification".

This would avoid nasty cases where calculations hide underlying errors, as 
implied by Section 10.1.

Also, Section 4.5 of version 20061208 has a spello (propogate should be 
propagate) and an incomplete sentence: In OpenDocument, if an error value is 
the result of a cell computation any must be stored that way, it is treated 
as a string. 


PGP signature

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]