[OASIS Issue Tracker] Commented: (OFFICE-3493) Part 1 19.598 Addis-true-formula( ) to table:condition

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

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

Dennis Hamilton commented on OFFICE-3493:
-----------------------------------------

There is a difference.

It is desirable to have

table:base-cell-address=".A1"
table:condition="is-true-formula(SUM([.A3:.B9])>.[$A$2])"

and also

table:base-cell-address=".A1"
table:condition="cell-content-is-date() and is-true-formula(DAYS360([.A1];$$'Expiration')<60)"

Since is-true-formula( ) determines a truth value, it should be permissible wherever truth-value connectives (i.e., "and") are used.  It is also the only way to introduce more-complicated connectives easily (OR, NOT, XOR, etc.)

I believe the edits should stand as applied.  Without introduction of is-true-formula in both places, the two examples above are not provided.


[NOTE: It is not clear how table:allow-empty-cell interacts with table:condiition, but I assume if table:allow-empty-cell is true, and the cell is empty, then any table:condition is treated as producing true (so no exception is triggered).  I also assume that if table:allow-empty-cell is false, and the cell is empty, then it is as if any table:condition is false and whatever exception there is will be triggered.]

> Part 1 19.598 Add is-true-formula( ) to table:condition
> -------------------------------------------------------
>
>                 Key: OFFICE-3493
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3493
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Sub-task
>          Components: Part 1 (Schema), Table
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Dennis Hamilton
>            Assignee: Dennis Hamilton
>             Fix For: ODF 1.2 CD 06
>
>
> The is-true-formula function needs to be defined for table:condition for exactly the same flexibility that it provides in style:condition.
> The proposal allows use of an expression as any condition, either the only condition or the condition that is a defined value condition.
> How any expression defined by a separate formula specification provides a way to refer to the equivalent of cell-content() depends on the formula syntax and semantics.

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