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-2607

3.8 Reference, duplication

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 Part 2 CD 1
    • Fix Version/s: ODF 1.2 Part 2 CD 3
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      In 3.8: "A reference may refer to a cell that does not contain a value; such a reference refers to an empty cell. " (remove the other sentences)

      In 3.7: change "... can be distinguished from cells containing values (including zero and the empty string)"
      into
      "... can be distinguished from cells containing values (including zero and the empty string) by some functions (such as ISBLANK and COUNTBLANK)"

      Show
      In 3.8: "A reference may refer to a cell that does not contain a value; such a reference refers to an empty cell. " (remove the other sentences) In 3.7: change "... can be distinguished from cells containing values (including zero and the empty string)" into "... can be distinguished from cells containing values (including zero and the empty string) by some functions (such as ISBLANK and COUNTBLANK)"

      Description

      3.8 Reference contains this text

      "A reference may refer to a cell that does not contain a value; such a reference refers to an empty 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)."

      Most of it is already explained in 3.7

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              bart.hanssens Bart Hanssens (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: