[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: ------------------------------------ Proposal: [last edited 2010-10-26T14:50Z] In section 2.2.2(E), Add CURRENTVALUE to the list of Small Group Evaluator functions. This function should be available at all levels. 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: a 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 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. 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 create a dependency on that cell for automatic recalculation purposes. """ was: 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: a 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( ). If the evaluation is in a context where there is a current cell which will be updated as a result of the current evaluation, CURRENTVALUE( ) returns the value *currently* established for that cell. If the current value is an error-type value, that value is returned. 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; replacement of a current value as the result of the current evaluation shall not by itself induce any recalculation of the current evaluation. Description: 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. was: 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( ).. Whenever the evaluation is in a context where there is a current cell on behalf of which the formula is being evaluated, the current value of that cell is the value of CURRENTVALUE( ). 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. Added to small group and fixed the recursion-avoidance dependency rule. > 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]