[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:all-tabpanel ]

Francis Cave updated OFFICE-4107:
---------------------------------
    Resolution: 
Resolve as proposed:
h3. 19.617.2 <table:filter-condition>

The {{table:data-type}} attribute specifies whether a comparison shall take place as text, numeric values, or as color.
 The defined values for the {{table:data-type}} attribute are:
 â {{number}}: comparison as numeric values.
 â {{text}}: comparison as text values.
 â {{text-color}}: comparison based on the text color. The value "window-font-color" specifies the default text color, as specified in {{style:use-window-font-color}} 20.399. Text color assigned by data styles 16.29 is not considered.
 â {{data-style-color}}: comparison based on the text color applied by a data style 16.29.
 â {{background-color}}: comparison based on the cell background color, as determined by the applicable {{<style:table-cell-properties>}} 17.18 element.
 A {{<table:filter-condition>}} 9.5.5 element that is a descendant of {{<table:data-pilot-table>}} 9.6.3 and has a {{table:data-type}} attribute with value {{text-color}}, {{data-style-color}} or {{background-color}} is ignored.
 For a {{<table:filter-condition>}} 9.5.5 element the default value for this attribute is {{text}}.
h3. 19.690 table:operator

...
 Depending on the value of the {{table:data-type}} 19.389 attribute, all operations take place on string or numeric, or color values. Only = and != operations are allowed on color values.
h3. 19.713 table:search-criteria-must-apply-to-whole-cell

The {{table:search-criteria-must-apply-to-whole-cell}} attribute specifies whether a search pattern matches the entire content of a cell.
{quote}*Note:* The {{table:search-criteria-must-apply-to-whole-cell}} is used with the {{<table:filter-condition>}} 19.602 element when the {{table:data-type}} 19.617 attribute has the value {{text}} or {{text-color}} or {{data-style-color}} and the {{table:operator}} 9.5.5 attribute has a value of: {{match}}, {{!match}}, \{{=}}, or {{!=}}.
{quote}
The defined values ...

  was:resolve as proposed


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