[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] (OFFICE-4107) 19.615.2 <table:filter-condition>: Extend table:data-type attributes to filter by color
[ 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)
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]