Share via

2.6.166 CT_RichFilters

  • Article

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

Referenced by: CT_RichFilterColumn

This complex type specifies a filter with multiple criteria associated with rich values.

Child Elements:

filter: A CT_RichFilter element that specifies a filter criterion associated with rich values. Rows that contain a rich value within the filter range that have a key value pair (KVP) with value val and key key will not be hidden by this filter criterion. Rows that do not contain such a rich value will be hidden.

dateGroupItem: A CT_RichDateGroupItem element that specifies a group of dates or times which are used in a filter criteria associated with rich values.

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_RichFilters">
   <xsd:sequence>
     <xsd:element name="filter" type="CT_RichFilter" minOccurs="0" maxOccurs="unbounded"/>
     <xsd:element name="dateGroupItem" type="CT_RichDateGroupItem" minOccurs="0" maxOccurs="unbounded"/>
     <xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
 </xsd:complexType>

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