[OASIS Issue Tracker] Updated: (OFFICE-3434) ODF 1.2 Part 2, 5.8References Error as Sheet Name Unclear

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

     [ http://tools.oasis-open.org/issues/browse/OFFICE-3434?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dennis Hamilton updated OFFICE-3434:
------------------------------------

    Proposal: 
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.

  was:
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 Empty rule from the rule for QuotedSheetName.


Typo in the Proposal corrected

> ODF 1.2 Part 2, 5.8 References Error as Sheet Name Unclear
> ----------------------------------------------------------
>
>                 Key: OFFICE-3434
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3434
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula, Part 2 (Formulas)
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Dennis Hamilton
>            Priority: Minor
>             Fix For: ODF 1.2 CD 06
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira