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