[OASIS Issue Tracker] Updated: (OFFICE-3340) SHEET function with noparameter undefined when experession is used outside table cell

From
OASIS Issues Tracker <>
Date
2010-10-04T23:24:23+00:00
ID
2010816737.75721286234654987.JavaMail.tomcat55@mw00
Thread
[OASIS Issue Tracker] Updated: (OFFICE-3340) SHEET function with noparameter undefined when experession is used outside table cell
[ http://tools.oasis-open.org/issues/browse/OFFICE-3340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eric Patterson updated OFFICE-3340:
-----------------------------------

    Component/s: Needs Discussion
                 OpenFormula Test Cases
                 Overview Document
                 Packaging
                 Paragraph
                 Part 1 (Schema)
                 Part 2 (Formulas)
                 Part 3 (Packages)
                 Presentation

part of the current function definition is:

"If no parameter is given, the result is the sheet number of the sheet containing the formula."

What happens if the sheet function is evaluated outside the context of a sheet, such as in a macro?  Are we going to make this implementation defined by not resolving this issue?

> SHEET function with no parameter undefined when experession is used outside table cell
> --------------------------------------------------------------------------------------
>
>                 Key: OFFICE-3340
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3340
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: Needs Discussion, OpenFormula, OpenFormula Test Cases, Overview Document, Packaging, Paragraph, Part 1 (Schema), Part 2 (Formulas), Part 3 (Packages), Presentation, Public Review
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Eric Patterson
>            Assignee: Eric Patterson
>             Fix For: ODF 1.2 CD 06
>
>
> If a named-expression is defined to use the expression "=SHEET()", the result is currently undefined in the specification given that the formula does not exist in a sheet.

-- 
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