2.2.20 CT_autofilters

Referenced by: CT_Worksheet

A list of AutoFilters. This element MUST contain the collection of all autofilters that are contained within the range defined in the CT_Table element. An autofilter is considered to be contained within a range if one or more worksheet cells defined in a nested CT_item element lie within the range. If an autofilter is defined on a hidden row (2) within the range defined in the CT_Table element, that autofilter MUST NOT be included in this collection. If all the worksheet cells defined in the nested CT_item elements that lie within the range defined in the CT_Table element are present on hidden columns, that autofilter MUST NOT be included in this collection. This element MUST have zero or one autofilter elements having the Type attribute (2) set to "Sheet".

Child Elements:

autofilter: An autofilter that lies within the range defined in the CT_Table element.

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

 <xs:complexType name="CT_autofilters">
   <xs:sequence>
     <xs:element name="autofilter" minOccurs="1" maxOccurs="unbounded" type="CT_autofilter"/>
   </xs:sequence>
 </xs:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).