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-3494) Part 2 6.13 AddCURRENTVALUE function

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

Dennis Hamilton commented on OFFICE-3494:

Thanks Andreas, that is a good place to put this one.

In the 2010-10-26 SC call, there was great consternation over this function.  Because it is like CELL and other deep-reaching functions, it is removed from the Small Group as too burdensome (and too new).

The additional consternation has to do with CURRENTVALUE( ) in an on-load or other situation where (1) the current value is that of a cell and (2) the evaluation containing CURRENTVALUE( ) will be used to replace the value of that cell.  The defining of CURRENTVALUE( ) as not representing a dependency on the cell is either (1) not reassuring enough or (2) is considered to break current implementations of how evaluations are done.

There will be language to emphasize the value of CURRENTVALUE( ) in situations where (1) there is no cell that is the source of CURRENTVALUE( ) or (2) the evaluation is not being used to determine a value for a cell but is used in determining some condition, such as in conditional styling, filtering of table rows, etc.

The proposal will be adjusted and we can digest this some more.

> 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: Needs Discussion, 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]