Details

    • 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:
      Hide

      2010-03-23 conference call:

      Change "Applications should use the following identifier names when they
      intend to represent that particular error and there is no more specific error that they are able to represent:"
      to
      "The following is a list of constant error names that are used by several existing implementations,
      but note that evaluators may implement other constant error values:"
      "Evaluators may support other error values, including the following:"

      Change the table title "Recommended Constant Errors (when no more specific information is available)"
      to "Possible Other Constant Error Values".

      Show
      2010-03-23 conference call: Change "Applications should use the following identifier names when they intend to represent that particular error and there is no more specific error that they are able to represent:" to "The following is a list of constant error names that are used by several existing implementations, but note that evaluators may implement other constant error values:" "Evaluators may support other error values, including the following:" Change the table title "Recommended Constant Errors (when no more specific information is available)" to "Possible Other Constant Error Values".

      Description

      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?

        Attachments

          Activity

            People

            • Assignee:
              orcmid Dennis Hamilton (Inactive)
              Reporter:
              patrick Patrick Durusau
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: