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

5.8 Range Reference without SheetLocator

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Applied
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 CD 05
    • Fix Version/s: ODF 1.2 CD 06
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      In 5.8 References before "If in a RangeAddress the first part ..." add a paragraph:
      "
      If a RangeAddress contains no SheetLocator, the current sheet local to the position where the expression is evaluated is referred.
      "

      In 6.4.11 Infix Operator Reference Range (":") add to Semantics:
      "
      If the operands contain no SheetLocator, the current sheet local to the position where the expression is evaluated is referred. If only one operand contains a SheetLocator or both operands contain different SheetLocators, the behavior is implementation-dependent.
      "

      Show
      In 5.8 References before "If in a RangeAddress the first part ..." add a paragraph: " If a RangeAddress contains no SheetLocator, the current sheet local to the position where the expression is evaluated is referred. " In 6.4.11 Infix Operator Reference Range (":") add to Semantics: " If the operands contain no SheetLocator, the current sheet local to the position where the expression is evaluated is referred. If only one operand contains a SheetLocator or both operands contain different SheetLocators, the behavior is implementation-dependent. "

      Description

      In section 5.8, there is the following text:

      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.

      What if the first part does not contain a sheet locator and the second part does?

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              ericpa Eric Patterson
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: