Greetings! Just a quick reminder that Regina has posted for
https://issues.oasis-open.org/browse/OFFICE-3880 , a message with an attached test document,
https://lists.oasis-open.org/archives/office/201801/msg00012.html , that: ***** Tests with LibreOffice, Calligra, Gnumeric and Excel show, that only for the question Are the range values included for between , there is a consensus of Yes . For the other problems I see differences. Conclusion: The exact calculation needs to be specified for ODF 1.3 ***** Text at issue (under style:condition) cell-content-is-between( value1 , value2 ) : true if the style is applied to a table cell whose value is between value1 and value2 . cell-content-is-not-between( value , value ) : true if the style is applied to a table cell whose value is not between value1 and value2 . To save you a step, value can be: ***** Within table cell style conditions: value , value1 and value2 are a numberValue , a string or an _expression_ . numberValue is a whole or decimal number in the lexical form of the [xmlschema-2] decimal datatype. string expresses a value of the [xmlschema-2] string datatype by surrounding the sequence of string characters in quotation marks (U+0022, QUOTATION MARK). A quotation mark within the string itself is expressed with two consecutive quotation marks. _expression_ is a lexical form that is neither numberValue nor string and that is a well-formed _expression_ determined by the namespace applicable to the style:condition attribute value. ***** It would not be correct for all data types but I'm willing to write ...value1 and value2, inclusive. as it at least captures the most common behavior for digits. Suggestions/Comments? Hope everyone is having a great weekend! Patrick -- Patrick Durusau
patrick@durusau.net Technical Advisory Board, OASIS (TAB) Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300 Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps) Another Word For It (blog):
http://tm.durusau.net Homepage:
http://www.durusau.net Twitter: patrickDurusau Attachment: signature.asc Description: OpenPGP digital signature