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

Section 5.8 (References) doesn't explicitly state how 3D range references handle sheets positioned between the worksheets named in the reference

    XMLWordPrintable

    Details

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

      Sections 5.8 and 6.3.10 should be updated to state something like: "Takes two references and computes the range, that is, a reference to the smallest 3-dimensional cube of cells that include both Left and Right including the same range on worksheets positioned between the Left and Right in the workbook."

      Show
      Sections 5.8 and 6.3.10 should be updated to state something like: "Takes two references and computes the range, that is, a reference to the smallest 3-dimensional cube of cells that include both Left and Right including the same range on worksheets positioned between the Left and Right in the workbook."
    • Resolution:
      Hide

      Change section 6.3.10 Infix Operator Reference Range (":") from
      "Takes two references and computes the range, that is, a reference to the smallest 3-dimensional cube of cells that include both Left and Right."
      to
      "Takes two references and computes the range, that is, a reference to the smallest 3-dimensional cube of cells that include both Left and Right including the cells on sheets positioned between Left and Right."

      Show
      Change section 6.3.10 Infix Operator Reference Range (":") from "Takes two references and computes the range, that is, a reference to the smallest 3-dimensional cube of cells that include both Left and Right." to "Takes two references and computes the range, that is, a reference to the smallest 3-dimensional cube of cells that include both Left and Right including the cells on sheets positioned between Left and Right."

      Description

      Given a reference of the form: =SUM(['Sheet1'.B4:'Sheet2'.C5]), the current draft doesn't state that sheets positioned in the workbook between Sheet1 and Sheet2 should also be included in the range.

      6.3.10 Infix Operator Reference Range (":") says: "Takes two references and computes the range, that is, a reference to the smallest 3-dimensional cube of cells that include both Left and Right."

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: