[OASIS Issue Tracker] Commented: (OFFICE-3029) NEEDS-DISCUSSION:19.598: Table:Condition - location of namespace prefix seems scopedincorrectly

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

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

Dennis Hamilton commented on OFFICE-3029:
-----------------------------------------

Notes on the 2010-08-24 discussion at the OpenFormula SC Conference Call:

1. The objection to use of is-true-formula(<expression>) is that the <expression> has no way to resolve to the the value being validated.

2. This turns on whether or not these conditions apply to the values in cells and establish validity for values in those cell.  (Not sure how table:allow-empty-value works as an user-entry validator, by the way).

3. Here's what we do know when a table:condition is being applied via the <table:content-validtion> element that has that attribute:

3.1 The table:name attribute of the <table:content-validation> element is used as the value of the table:content-validation-name attribute of a <table:table-cell> or <table:covered-table-cell> which is to be subject to validation in accordance with the table:condition.

3.2 table:allow-empty-cell attribue of the <table:content-validation> element indicates that an empty cell is allowed, regardless of the table:condition attribute.

3.3 table:base-cell-address provides an absolute cellAddress value, with explicit table name, that is used to resolve all relative references in <expression>s of the table:condition.

3.4 There is mumbling about offering a list of values that an user could select from, where the list is found in the table:condition.  The table:display-list attribute of <table:content-validation> indicates whether the list is not to be offered, or whether the list is sorted or not.  This is apparently the list referenced in the cell-content-is-in-list(list) condition, where list is a ";"-separated list of (quoted?) strings or may be an <expression> instead.

4. What we have now way of communicating to an <expression> is the location of the cell being validated or the name of the value that is to be validated before a value is accepted for the cell.  We also don't know whether an implementation accepts the data and then validates or not.  (What happens, for example, if the cell value is determined by a table:formula?).

5. It would seem that the way to handle this is to have a pseudo-variable (or a pseudo-function) THIS() that refers to the value being validated without indicating whether it is already in the cell or not but is the right thing for whenever the validation condition is being checked.

> NEEDS-DISCUSSION: 19.598: Table:Condition - location of namespace prefix seems scoped incorrectly
> -------------------------------------------------------------------------------------------------
>
>                 Key: OFFICE-3029
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3029
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula, Part 1 (Schema), Table
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Eric Patterson
>            Assignee: Eric Patterson
>             Fix For: ODF 1.2 CD 06
>
>
> In section 19.598, it has the following text: "The value of this attribute should be a namespace prefix, followed by a ":" (COLON, U+003A), followed by Boolean expression. ".  This implies placing the namespace prefix at the beginning of the condition string, immediately preceding the condition.  For example:
> table:condition="of:cell-content-is-decimal-number() and cell-content-is-between(1,[.B1])"
> Given that the OF namespace specifies the syntax for an expression used as a value in a condition, is this the best place for it?  Should it be as follows instead?
> table:condition="cell-content-is-decimal-number() and cell-content-is-between(1,of:[.B1])"

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