[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (OFFICE-3029) NEEDS-DISCUSSION:19.598: Table:Condition - location of namespace prefix seems scopedincorrectly
[ http://tools.oasis-open.org/issues/browse/OFFICE-3029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20879#action_20879 ]
Andreas Guelzow commented on OFFICE-3029:
------------------------------------------
As we discussed in teh subcommittee, we need to define when validation happen very specifically. Assuming it happens on input only it needs to specify exactly at what stage it occurs.
Example
A1 contains 1
B1 contains 4
validation condition for B1 is cell-content-is-between(A1,B1)
Now the user attempts to enter 5 in B1:
in OOo validation fails since 5 is not between 1 and 4
in Gnumeric (and I believe in Excel) validation succeeds since 5 is between 1 and 5 and the new value was first entered in the cell before attempting validation.
> 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
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]