[OASIS Issue Tracker] Created: (OFFICE-2323) More detail needed forSheet and Sheets functions

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

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