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] Created: (OFFICE-2323) More detail needed forSheet and Sheets functions

More detail needed for Sheet and Sheets functions

                 Key: OFFICE-2323
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2323
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: Bug
          Components: OpenFormula
            Reporter: Eric Patterson

How should these functions behave around hidden and very hidden sheets?  What about 3D-refs to SHEET?
What order we are talking about? Order in sheet bar? Any internal order which guarantees unique ids?

What happens with cases where formula evaluation is handed off across sheets? 
For example, 
In sheet1:  =Sheet2!foo, where Sheet2!foo is defined as =SHEET(!B2).  The top-level formula is on Sheet1, but foo is on Sheet2, but !B2 evaluates to a cell on Sheet1.
Or what if you're calling a macro function on a cell in a normal worksheet and the macro function calls SHEET -- which sheet do we return?

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]