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: Office-1812


Rob,

You had a suggestion for:

http://tools.oasis-open.org/issues/browse/OFFICE-1812

The current text reads:

> The |table:condition| attribute specifies the condition that 
> determines whether a cell content is valid in regard to a validation 
> rule or not. A cell content is valid if the condition evaluates to 
> “true”. The value of this attribute should be a namespace prefix, 
> followed by a Boolean expression. If the namespace prefix is missing 
> it defaults to the "urn:oasis:names:tc:opendocument:xmlns:of:1.2" 
> namespace.
>
> The defined conditions are:
>
>    *
>
>       |Condition ::= ExtendedTrueCondition | TrueFunction 'and'
>       TrueCondition|
>
>    *
>
>       |ExtendedGetFunction ::=
>       cell-content-text-length-is-between(Value, Value) |
>       cell-content-text-length-is-not-between(Value, Value) |
>       cell-content-is-in-list( StringList )|
>
>    *
>
>       |ExtendedTrueCondition ::= ExtendedGetFunction |
>       cell-content-text-length() Operator Value|
>
>    *
>
>       |A Formula|| is a formula without an equals (=) sign at the
>       beginning.|
>
>    *
>
>       |GetFunction ::= cell-content-is-between(Value, Value) |
>       cell-content-is-not-between(Value, Value)|
>
>    *
>
>       |A NumberValue is a whole or decimal number. It shall not
>       contain comma separators for numbers of 1000 or greater.|
>
>    *
>
>       |Operator ::= '<' | '>' | '<=' | '>=' | '=' | '!='|
>
>    *
>
>       |A String|| comprises one or more characters surrounded by
>       quotation marks.|
>
>    *
>
>       |StringList ::= StringList ';' String | String|
>
>    *
>
>       |TrueCondition ::= GetFunction | cell-content() Operator Value|
>
>    *
>
>       |TrueFunction ::= cell-content-is-whole-number() |
>       cell-content-is-decimal-number() | cell-content-is-date() |
>       cell-content-is-time() | cell-content-is-text()|
>
>    *
>
>       |Value ::= NumberValue | String | Formula|
>
If you have time can you look at your comment and see if this satisfies 
you comment and that of Makoto?

Thanks!

Hope you are at the start of a great week!

Patrick

-- 
Patrick Durusau
patrick@durusau.net
Chair, V1 - US TAG to JTC 1/SC 34
Convener, JTC 1/SC 34/WG 3 (Topic Maps)
Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)



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