[ https://issues.oasis-open.org/browse/OFFICE-4107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=79253#comment-79253 ]
Michael Stahl commented on OFFICE-4107:
---------------------------------------
* currently LO can only compare colors for equality with table:operator="=" - may other values of table:operator don't make sense for colors, and don't make sense for numbers either.
* it could be possible to define an ordering for colors, such that operators like "<", "<=", "bottom values" etc become usable, but we should first check if Excel supports that and define it to be Excel's ordering if it does.
* an additional feature has been requested: to filter for *no* color being set - this can be added by adding a choice with an alternative string value such as "none".
* the color that is used is the effective text or background color of the cell, no matter where it comes from.
> 19.615.2 <table:filter-condition>: Extend table:data-type attributes to filter by color
> ---------------------------------------------------------------------------------------
>
> Key: OFFICE-4107
> URL: https://issues.oasis-open.org/browse/OFFICE-4107
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: New Feature
> Components: Part (Schema), Table
> Affects Versions: ODF 1.3
> Reporter: Michael Stahl
> Priority: Major
> Fix For: ODF 1.4
>
> Attachments: Example in Excel.xlsx
>
>
> 19.615.2 <table:filter-condition>: Extend table:data-type attributes to filter by color
--
This message was sent by Atlassian Jira
(v8.3.3#803004)
