Part 2 6.13 Add CURRENTVALUE function

[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: 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 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 a value for a 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.] """ or - [Eike] Do not add this function. See my comment why we don't need it.