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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 Part 2 CD 1, ODF 1.2 Part 2 CD 2
    • Fix Version/s: ODF 1.2 Part 2 CD 3
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      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.
    • Resolution:
      Hide

      Applied proposal.

      Show
      Applied proposal.

      Description

      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.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: