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

XMLWordPrintable

    • 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.
    • 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.

      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.

            Assignee:
            Dennis Hamilton (Inactive)
            Reporter:
            Dennis Hamilton (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: