[OASIS Issue Tracker] Issue Comment Edited: (OFFICE-3494) Part 26.13 Add CURRENTVALUE function

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

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

Dennis Hamilton edited comment on OFFICE-3494 at 11/2/10 6:28 PM:
------------------------------------------------------------------

[2010-11-02T22:27Z Fixed the angle brackets and empty-cell closures]

Help me out here.  I don't understand this example:

""""
For example, if we have table:base-cell-address='A1' then the condition is-true-formula(A1+C23=42) is equivalent to a proposed is-true-formula(CURRENTVALUE()+C23=42). 
"""

Suppose I have, as a child of <office:spreadsheet> <table:content-validations> the following:

<table:content-validation 
      table:name="+C23=42"
      table:base-cell-address="A1"
      table:condition="is-true-formula([.A1]+.[.$C$23]=42"
      />

And there are these three cells:

 <!-- This is cell [$'Sheet 1'.$A$1] -->

   <table:table-cell 
         table:content-validation-name="+C23=42"
         office:value-type="float"
         office:value="17"
         />

<!-- This is cell [$'Sheet 1'.$X$12] -->

   <table:table-cell 
         table:content-validation-name="+C23=42"
         office:value-type="float"
         office:value="-1.5"
         />

<!-- This is cell [$'Sheet X'.$BB$11]   
         
   <table:table-cell 
         table:content-validation-name="+C23=42"
         office:value-type="float"
         office:value="0.05E-6"
         />

How are all of these the same as if I had used 

      table:condition="is-true-formula(CURRENTVALUE()+.[.$C$23]=42)"

instead?

      was (Author: orcmid):
    Help me out here.  I don't understand this example:

""""
For example, if we have table:base-cell-address='A1' then the condition is-true-formula(A1+C23=42) is equivalent to a proposed is-true-formula(CURRENTVALUE()+C23=42). 
"""

Suppose I have, as a child of <office:spreadsheet> <table:content-validations> the following:

<table:content-validation 
      table:name="+C23=42"
      table:base-cell-address="A1"
      table:condition="is-true-formula([.A1]+.[.$C$23]=42"
      />

And there are these three cells:

 <!-- This is cell [$'Sheet 1'.$A$1] -->

   <table:table-cell 
         table:content-validation-name="+C23=42"
         office:value-type="float"
         office:value="17"
         >

<!-- This is cell [$'Sheet 1'.$X$12] -->

   <table:table-cell 
         table:content-validation-name="+C23=42"
         office:value-type="float"
         office:value="-1.5"
         >

<!-- This is cell [$'Sheet X'.$BB$11]   
         
   <table:table-cell 
         table:content-validation-name="+C23=42"
         office:value-type="float"
         office:value="0.05E-6"
         >

How are all of these the same as if I had used 

      table:condition="is-true-formula(CURRENTVALUE()+.[.$C$23]=42"

instead?
  
> 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