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] Updated: (OFFICE-3494) Part 2 6.13 AddCURRENTVALUE function



     [ http://tools.oasis-open.org/issues/browse/OFFICE-3494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dennis Hamilton updated OFFICE-3494:
------------------------------------

    Component/s:     (was: Needs Discussion)
     Resolution: 
[Dennis]
[last edited 2010-10-26T16:41Z]

In the note at the end of section 2.2.4, add CURRENTVALUE to the list along with CELL and DOLLAR.

In Section 6.13 add a new CURRENTVALUE section immediately after 6.13.10 COUNTIFS.  This new 6.13.11 CURRENTVALUE will have the following text:

"""
Summary: Return the current value, if any, available in the context of the current evaluation.

Syntax:  CURRENTVALUE( )

Returns: Any type, depending on the current value

Constraints: None

Semantics: Whenever the evaluation is in a context where there is a current value, that value is made available to the evaluation as the result of CURRENTVALUE( ). [Note: a current value need not be associated with a specific cell or even a table, depending on the context in which the evaluation is occuring.]


Whenever the current value is that for a table cell, that value is delivered in the same manner as if CURRENTVALUE( ) were a reference to that cell.  [Note: CURRENTVALUE( ) does not deliver a reference unless the current (cell) value is a reference.]

When there is no applicable current value in the context of the current evaluation, CURRENTVALUE( ) returns an error-type value.  

Evaluation of CURRENTVALUE( ) does not constitute a recursive reference.  When CURRENTVALUE() is the value of a cell, CURRENTVALUE( ) does not constitute a dependency on that cell for automatic recalculation purposes.   An evaluator may produce an error-type result value if the current value is that of a cell whose formula is being evaluated.

[Note: CURRENTVALUE( ) supports OpenFormula usage in situations where (1) there is no cell that is the source of CURRENTVALUE( ) or (2) the evaluation is not being used to determine the value for the table cell but is used in a expression for determining some condition, such as in conditional styling, filtering of table rows, or triggering a message or script.] 

Created resolution that is a refinement of the last-updated affirmative proposal.

> Part 2 6.13 Add CURRENTVALUE function
> -------------------------------------
>
>                 Key: OFFICE-3494
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3494
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Sub-task
>          Components: OpenFormula, Part 2 (Formulas)
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Dennis Hamilton
>            Assignee: Dennis Hamilton
>             Fix For: ODF 1.2 CD 06
>
>
> The CURRENTVALUE( ) function is an additional Information Function that provides access to the existing value in the context for which the OpenFormula formula is being evaluated.
> This function corresponds to the current-content( ) function defined in ODF 1.2 style:condition and table:condition attributes and it has the same purpose:
> Whenever the evaluation is in a context where there is a current value, that value is made available to the evaluation as the result of CURRENTVALUE( ).  [Note: a current value need not be associated with a specific cell or even a table, depending on the context in which the evaluation is employed.]
> Whenever the current value is that of a table cell, that value is delivered in the same manner as if CURRENTVALUE( ) were a reference to that cell.
> CURRENTVALUE( ) is a special form of reference that delivers a value based on the context of evaluation.
> When there is no current value available, CURRENTVALUE( ) returns an error-type value.   If the current value is an error-type value, that error is returned.
> Evaluation of CURRENTVALUE( ) shall not induce recalculation.  It does not constitute a recursive reference of any kind.

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