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

ODF 1.2 Part 2, 5.8 References Error as Sheet Name Unclear

    XMLWordPrintable

    Details

    • Proposal:
      Hide

      TWO CASES:

      1. If this is an allowed case of Reference syntax in the persisted form of formulas, specify what its semantics is in the text .

      2. If not, please remove the Error rule from the rule for QuotedSheetName.

      Show
      TWO CASES: 1. If this is an allowed case of Reference syntax in the persisted form of formulas, specify what its semantics is in the text . 2. If not, please remove the Error rule from the rule for QuotedSheetName.
    • Resolution:
      Hide

      Use the resolution of OFFICE-2750 where the [Error] case is at the full-reference level and is supported by an explanatory note to understand how it is valuable to allow such refferences to be produced rather than retaining a reference that has been invalidated and for which no automatic substitute or intervention was available.

      Show
      Use the resolution of OFFICE-2750 where the [Error] case is at the full-reference level and is supported by an explanatory note to understand how it is valuable to allow such refferences to be produced rather than retaining a reference that has been invalidated and for which no automatic substitute or intervention was available.

      Description

      In 5.8:References, the syntax allows Error wherever a QuotedSheetName may appear. There is no other place in Reference syntax where an Error may explicitly appear.

      In the text, the only mention of error behavior in the resolution of a reference is for being out of bounds for an implementations row or column limits.

      There is no explanation for why a producer would ever put such a value in the recorded form of a Reference, and what a consumer or evaluator should make of it.

      I can understand that a specified sheet might not exist and the reference would result in an error in the evaluator, but I don't understand why there would be any change to the reference in its persistent form.

      If this is related to the notion that an user entered a formula with an unrecognized sheet name in it, I can understand presenting the formula to an user in a way where the unresolvable sheet name is emphasized in some way. I just don't understand why a producer would make such a substitution if the formula is accepted without correction.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: