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: cell-content-is-between is underspecified Office-3880


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.


Hope everyone is having a great weekend!


Patrick Durusau
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

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