cell-content-is-between is underspecified Office-3880

[Patrick Durusau <patrick@durusau.net>]

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