OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: [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



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

Eike Rathke updated OFFICE-2022:
--------------------------------

    Affects Version/s:     (was: ODF 1.2)

> 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: OpenFormula
>            Reporter: Eric Patterson
>            Assignee: Eike Rathke
>             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

        


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]