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] Commented: (OFFICE-3340) SHEET function withno parameter undefined when experession is used outside table cell

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

Dennis Hamilton commented on OFFICE-3340:

I'm a little confused.

I assume a macro is not expressed in OpenFormula.  

Maybe a macro is invoked from an OpenFormula formula?  Then I can imagine SHEET functions in macros binding as if they were in the context of formula itself and working accordingly.  I think OpenFormula is silent on this though..  

Even if that binding is part of the hosting and evaluation context of the macro, sort of like there being an object model and environment available to the macro based on where it is invoked from, it is difficult to know how the SHEET function of the macro would be defined.  Maybe maybe the result is whatever it would have been in the formula itself (and the REFERENCE-RESOLVER would likely come into play in that case).   

But, in some sense, how a SHEET function reference supported by a macro is related to the SHEET function in an OpenFormula expression doesn't seem to be anything OpenFormula is obligated to address.  It looks like that is all up to the macro system.  At least in this incarnation?

Coming back to the original question, I assume that it is the hosting of the evaluation that has no SHEET context that determines that fact and provides an Error-type result.

> 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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]