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

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • ODF 1.2
    • Affects Version/s: None
    • Component/s: OpenFormula
    • None
    • 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."
    • 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."

      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."

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

              Created:
              Updated:
              Resolved: