[OASIS Issue Tracker] (OFFICE-4107) 19.615.2 <table:filter-condition>: Extend table:data-type attributes to filter by color

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

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