[OASIS Issue Tracker] Updated: (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>]

     [ http://tools.oasis-open.org/issues/browse/OFFICE-2022?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Robert Weir  updated OFFICE-2022:
---------------------------------

           Issue Type: Bug  (was: Task)
          Component/s: Table
        Fix Version/s: ODF 1.2
    Affects Version/s:     (was: ODF 1.0 Errata 01)
                           (was: ODF 1.0 Errata 02)

> 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: Bug
>          Components: Table
>    Affects Versions: ODF 1.0, ODF 1.0 (second edition), ODF 1.1, ODF 1.2
>            Reporter: Eric Patterson
>             Fix For: ODF 1.2
>
>
> 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