[OASIS Issue Tracker] Commented: (OFFICE-3340) SHEET function withno parameter undefined when experession is used outside table cell

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

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

Dennis Hamilton commented on OFFICE-3340:
-----------------------------------------

I am puzzled about this:

"""
anchor:SHEET 
If the function is not evaluated within a table cell, an error is returned.
"""

Also, ODF allows tables that are not associated with sheets.

I think it is better to say

"""
If no sheet can be determined in the context of the evaluation, an error-type value is returned.
"""

> 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: OpenFormula
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Eric Patterson
>            Assignee: Patrick Durusau
>             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