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-3493) Part 1 19.598 Addis-true-formula( ) to table:condition

    [ 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


and also

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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]