[ http://tools.oasis-open.org/issues/browse/OFFICE-3029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=19745#action_19745 ]
Andreas Guelzow commented on OFFICE-3029:
------------------------------------------
table:condition="cell-content-is-decimal-number() and cell-content-is-between(1,msoxl:B1)"
table:condition="of:cell-content-is-decimal-number() and cell-content-is-between(1,[.B1])"
I don't see how either of these is valid according to ODF1.2CD5: There does not seem to be any provision for "and".
I see more problems with the Excel version:
table:condition="cell-content-is-decimal-number() and cell-content-is-between(1,msoxl:B1)"
the intent appears to be to associate a namespace with the expression "B1". What is missing is a namespace associated with the value or expression "1". (Note: The XML namespace name associated with the namespace prefix specifies the syntax and
semantics of the expressions and _values_ occurring within the condition. )
Preceding just the expression with a namespace (as in Excel's version) would permit things like:
table:condition="cell-content-is-between(of:[.C1],msoxl:B1)"
I am not sure that permitting this would be wise.
> 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
> Affects Versions: ODF 1.2 CD 05
> Reporter: Eric Patterson
>
> 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
