[OASIS Issue Tracker] Created: (OFFICE-2022) Section 5.8(References) doesn't explicitly state how 3D range references handle sheetspositioned between the worksheets named in the reference

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

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

                 Key: OFFICE-2022
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2022
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: Task
    Affects Versions: ODF 1.0, ODF 1.0 (second edition), ODF 1.1, ODF 1.0 Errata 01, ODF 1.0 Errata 02, ODF 1.2
            Reporter: Eric Patterson


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


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira