Share via

2.6.201 CT_RichFilterColumn

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2017/richdata2

Referenced by: filterColumn

This complex type specifies filter information associated with rich values.

Child Elements:

filters: A CT_RichFilters element that specifies a filter with multiple criteria associated with rich values.

top10: A CT_RichTop10 element that specifies a top N filter or bottom N filter.

customFilters: A CT_CustomRichFilters element that specifies custom filter criteria associated with rich values. Rows that contain a cell within the filter range such that the value does not meet the custom filter criteria will be hidden.

dynamicFilter: A CT_DynamicRichFilter element that specifies the dynamic filter criteria associated with rich values. These criteria are considered dynamic because they can change, either with the data itself (e.g., "above average") or with the current system date (e.g., show values for "today"). For any cells within the filter range whose values do not meet the specified criteria, the corresponding rows will be hidden from view when the filter is applied.

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2016] section A.2) element that specifies future extensibility for this element.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_RichFilterColumn">
   <xsd:choice minOccurs="0" maxOccurs="1">
     <xsd:element name="filters" type="CT_RichFilters"/>
     <xsd:element name="top10" type="CT_RichTop10"/>
     <xsd:element name="customFilters" type="CT_CustomRichFilters"/>
     <xsd:element name="dynamicFilter" type="CT_DynamicRichFilter"/>
     <xsd:element name="extLst" type="x:CT_ExtensionList"/>
   </xsd:choice>
 </xsd:complexType>

See section 5.20 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).