2.6.59 CT_CustomFilters
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main
Referenced by: customFilters
This complex type specifies custom filter criteria. 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_CustomFilter element that specifies a custom filter criterion.
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_CustomFilters"> <xsd:sequence> <xsd:element name="customFilter" type="CT_CustomFilter" minOccurs="1" maxOccurs="2"/> </xsd:sequence> <xsd:attribute name="and" type="xsd:boolean" use="optional" default="false"/> </xsd:complexType>
See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).