Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-2370

3.7 Reference - reference to cell with no value = number 0?

    XMLWordPrintable

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

      Replace the current paragraph with:

      "A reference to an empty cell returns the number 0."

      If empty cell is not adequately defined elsewhere, supply that definition.

      Show
      Replace the current paragraph with: "A reference to an empty cell returns the number 0." If empty cell is not adequately defined elsewhere, supply that definition.
    • Resolution:
      Show
      Resolved as part of http://tools.oasis-open.org/issues/browse/OFFICE-2329

      Description

      The reference paragraph that I moved to 3.7 Reference reads:

      "A reference may refer to a cell that does not contain a value; such a reference refers to an empty (aka blank) cell. An empty cell is neither zero nor the empty string, and an empty cell can be distinguished from cells containing values (including zero and the empty string) by some functions (such as ISBLANK and COUNTBLANK). An empty cell is not the same as an Error, in particular, it is distinguishable from the Error #N/A (not available). As discussed below, in many scalar contexts a reference to an empty cell is converted into 0 or the empty string, and in most sequences empty cells are automatically omitted. If the outermost expression is a reference to an empty cell, it shall be converted to the number 0."

      Is the purpose of this paragraph to say:

      "A reference to an empty cell returns the number 0."

      Reasoning that the concept of an empty cell should be defined elsewhere.

      See also OFFICE-2329

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              Patrick Patrick Durusau
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: