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] Commented: (OFFICE-2747) 5.8 Range Referencewithout SheetLocator

    [ http://tools.oasis-open.org/issues/browse/OFFICE-2747?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21578#action_21578 ] 

Eike Rathke commented on OFFICE-2747:

This turns out to be complicated for the range operator. All following formula expressions in cell Sheet3.A2:

Excel does not allow =SUM(INDIRECT("sheet1!a1"):INDIRECT("sheet3!b1")) and produces a #VALUE! error.
Gnumeric for =SUM(INDIRECT("sheet1!a1"):INDIRECT("sheet3!b1")) sums only the range Sheet1.A1:B1 and apparently ignores any following sheet specifier.
OOo for =SUM(INDIRECT("sheet1.a1"):INDIRECT("sheet3.b1")) sums the 3D range Sheet1.A1:Sheet3.B2

Excel =SUM(INDIRECT("sheet2!a1"):INDIRECT("sheet2!b1")) sums range Sheet2.A1:Sheet2.B1
Excel =SUM(INDIRECT("a1"):INDIRECT("sheet3!b1")) sums range Sheet3.A1:Sheet3.B1
Excel =SUM(INDIRECT("a1"):INDIRECT("sheet2!b1")) #VALUE! error.
Excel =SUM(INDIRECT("sheet2!a1"):INDIRECT("b1")) #VALUE! error.
Gnumeric =SUM(INDIRECT("sheet2!a1"):INDIRECT("sheet2!b1")) sums range Sheet2.A1:Sheet2.B1
Gnumeric =SUM(INDIRECT("a1"):INDIRECT("sheet3!b1")) sums range Sheet3.A1:Sheet3.B1
Gnumeric =SUM(INDIRECT("a1"):INDIRECT("sheet2!b1")) sums range Sheet3.A1:Sheet3.B1
Gnumeric =SUM(INDIRECT("sheet2!a1"):INDIRECT("b1")) sums range Sheet2.A1:Sheet2.B1
OOo =SUM(INDIRECT("sheet2.a1"):INDIRECT("sheet2.b1")) sums range Sheet2.A1:Sheet2.B1
OOo =SUM(INDIRECT("a1"):INDIRECT("sheet3.b1")) sums range Sheet3.A1:Sheet3.B1
OOo =SUM(INDIRECT("a1"):INDIRECT("sheet2.b1")) sums range Sheet2.A1:Sheet3.B1
OOo =SUM(INDIRECT("sheet2.a1"):INDIRECT("b1")) sums range Sheet2.A1:Sheet3.B1

> 5.8 Range Reference without SheetLocator
> ----------------------------------------
>                 Key: OFFICE-2747
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2747
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Eric Patterson
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2 CD 06
> In section 5.8, there is the following text:
> If in a RangeAddress the first part (left of ':' colon) contains a SheetLocator and the second part (right of ':' colon) does not contain a SheetLocator, the second part inherits the SheetLocator from the first part.
> What if the first part does not contain a sheet locator and the second part does? 

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]