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-2586) SHEET / SHEETSfunction (5.13.32) cannot be fully implemented as written

SHEET / SHEETS function (5.13.32) cannot be fully implemented as written

                 Key: OFFICE-2586
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2586
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: Bug
          Components: OpenFormula
    Affects Versions: ODF 1.2 Part 2 CD 1
            Reporter: Eric Patterson
             Fix For: ODF 1.2

There are a number of details that are not specified in the function definition for SHEETS.  They are:

1.	Handling of hidden and very hidden sheets.
   a.	Are they included in the total returned by SHEETS()?  Can they be found by SHEET("SheetName")?  What about references to them (these still evaluate correctly)
   b.	If we start with Sheet1, Sheet2, and Sheet3 and hide Sheet2 what should SHEET("Sheet3") return?  Visibly it's the second sheet, but internally it's the third.
   c.	Is there a distinction between handling of hidden vs. very hidden sheets
2.	We need to make sure we are talking about the tab order and not some other order.  Also should the index be 0 or 1 based (I suspect 1 based, but we should make sure)
3.	What about something like SHEET(Sheet1!A1:Sheet2!B2).  Is this an error?  Do we return the position of the first sheet?  The last sheet?
4.	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.  
5.	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?
6.	When specifying a sheet by name can a user enter something like "[Book1.xlsx]Sheet1",  
   a.	What do we do with a ref that refers to an external book?
7.	If sheet "foo" exists in Book1 and Book2, but not in Book3 and Book3 calls SHEET("foo") what should we return?  Do we error? Should it be the tab position from Book1 or Book2?  Is there a defined mechanism for picking which external book we pull from?  Is it required that this be deterministic (i.e. can we just use some arbitrary internal order and grab the first match we find?).  

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]