ODF 1.2 Part 2 section 4.8 Fails to Say How the Cuboids Are Resolved

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • ODF 1.2 Part 2 CD 3
    • Affects Version/s: ODF 1.2 Part 2 CD 1, ODF 1.2 Part 2 CD 2
    • Component/s: OpenFormula
    • None
    • Hide

      Replace EBNF syntax with:

      Reference ::= '[' Source? RangeAddress ']'
      RangeAddress ::=
      SheetLocatorOrEmpty '.' Column Row (':' '.' Column Row )? |
      SheetLocatorOrEmpty '.' Column ':' '.' Column |
      SheetLocatorOrEmpty '.' Row ':' '.' Row
      SheetLocator '.' Column Row ':' SheetLocator '.' Column Row |
      SheetLocator '.' Column ':' SheetLocator '.' Column |
      SheetLocator '.' Row ':' SheetLocator '.' Row
      SheetLocatorOrEmpty ::= SheetLocator | /* empty */
      SheetLocator ::= SheetName ('.' SubtableCell)*
      SheetName ::= QuotedSheetName | '$'? [^\]\. #$']+
      QuotedSheetName ::= '$'? SingleQuoted | Error
      SubtableCell ::= ( Column Row ) | QuotedSheetName
      Column ::= '$'? [A-Z]+
      Row ::= '$'? [1-9] [0-9]*
      Source ::= "'" IRI "'" "#"
      CellAddress ::= SheetLocatorOrEmpty '.' Column Row /* Not used directly */

      In definition text add:

      If a RangeAddress does not contain a Column element or does not contain a Row element, it specifies a cell rectangle (3.8 Reference). If it contains Row elements, the cell rectangle starts on the first column and ends on the last column the evaluator supports. If it contains Column elements, the cell rectangle starts on the first row and ends on the last row the evaluator supports.

      If in a RangeAddress the first part (left of ':' colon) contains a SheetLocator and the second part (right of ':' colon) does not contain a SheetLocator, the second part inherits the SheetLocator from the first part.

      If a RangeAddress contains two different SheetLocator s, it specifies a cell cuboid, see 3.8 Reference.

      Show
      Replace EBNF syntax with: Reference ::= ' [' Source? RangeAddress '] ' RangeAddress ::= SheetLocatorOrEmpty '.' Column Row (':' '.' Column Row )? | SheetLocatorOrEmpty '.' Column ':' '.' Column | SheetLocatorOrEmpty '.' Row ':' '.' Row SheetLocator '.' Column Row ':' SheetLocator '.' Column Row | SheetLocator '.' Column ':' SheetLocator '.' Column | SheetLocator '.' Row ':' SheetLocator '.' Row SheetLocatorOrEmpty ::= SheetLocator | /* empty */ SheetLocator ::= SheetName ('.' SubtableCell)* SheetName ::= QuotedSheetName | '$'? [^\]\. #$'] + QuotedSheetName ::= '$'? SingleQuoted | Error SubtableCell ::= ( Column Row ) | QuotedSheetName Column ::= '$'? [A-Z] + Row ::= '$'? [1-9] [0-9] * Source ::= "'" IRI "'" "#" CellAddress ::= SheetLocatorOrEmpty '.' Column Row /* Not used directly */ In definition text add: If a RangeAddress does not contain a Column element or does not contain a Row element, it specifies a cell rectangle (3.8 Reference). If it contains Row elements, the cell rectangle starts on the first column and ends on the last column the evaluator supports. If it contains Column elements, the cell rectangle starts on the first row and ends on the last row the evaluator supports. If in a RangeAddress the first part (left of ':' colon) contains a SheetLocator and the second part (right of ':' colon) does not contain a SheetLocator, the second part inherits the SheetLocator from the first part. If a RangeAddress contains two different SheetLocator s, it specifies a cell cuboid, see 3.8 Reference.
    • Hide

      Applied proposal.

      Show
      Applied proposal.

      Section 4.8 References does not describe the way in which Reference type values are determined from the different syntactic forms and when they fail to determine valid Reference values.

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

              Created:
              Updated:
              Resolved: