Share via

2.6.161 CT_CustomRichFilters

  • Article

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

Referenced by: CT_RichFilterColumn

This complex type 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.

Child Elements:

customFilter: A CT_CustomRichFilter element that specifies custom filter criterion that is associated with a rich value.

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

Attributes:

and: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies the relationship between custom filter criterion. This attribute only applies when there are two criteria:

Value

Meaning

"false"

The two criteria are related by an OR relationship. That is, for a cell value to meet the custom filter criteria, at least one criterion specified by the customFilter child elements MUST be met.

"true"

The two criteria are related by an AND relationship. That is, for a cell value to meet the custom filter criteria, both criteria specified by the customFilter child elements MUST be met.

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

 <xsd:complexType name="CT_CustomRichFilters">
   <xsd:sequence>
     <xsd:choice minOccurs="1" maxOccurs="2">
       <xsd:element name="customFilter" minOccurs="0" maxOccurs="1" type="CT_CustomRichFilter"/>
       <xsd:element name="extLst" minOccurs="0" maxOccurs="1" type="x:CT_ExtensionList"/>
     </xsd:choice>
   </xsd:sequence>
   <xsd:attribute name="and" type="xsd:boolean" use="optional" default="false"/>
 </xsd:complexType>

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