-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: ODF 1.2 Part 2 CD 2
-
Component/s: OpenFormula
-
Labels:None
-
Resolution:
The first paragraph of 3.6 Error reads:
"An error is one of a set of possible error values. Implementations may have many different error values, but one error value in particular is distinct: #N/A, the result of the NA() function. Users may choose to enter some data values as #N/A, so that this error value propagates to any other formula that uses it, and may test for this using the function ISNA()."
Err, do we mean to define the error #N/A and that it propagates?
The reason I ask is that here we start off saying that an error is a set of possible error values but don't say what that set is. Moreover it comes up in the next paragraph one or more error results that show up in a result.
I saw the note about "maximum flexibility" but how would an evaluator know when it saw an error if we don't define it? Or do we want to say that errors, other than #N/A are implementation defined?
Are there any cases where functions or operators don't return an error value as a result when the error is an input value?