2.2.19 CT_autofilter

  • Article

Referenced by: CT_autofilters

An AutoFilter in a worksheet.

Child Elements:

item: A column in the AutoFilter.

Attributes:

ID: If the AutoFilter is part of a table, this attribute denotes the identifier of the table. This attribute MUST be present when the Type is "Table". It MUST NOT be present otherwise.

Row: The row number on which the AutoFilter exists.

ColFirst: The column number of the first visible column in the AutoFilter.

Type: Specifies whether the AutoFilter is part of a table. If the autofilter is part of a table, this attribute (2) MUST have a value of "Table"; otherwise, it MUST have a value of "Sheet".

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

 <xs:complexType name="CT_autofilter">
   <xs:sequence>
     <xs:element name="item" minOccurs="0" maxOccurs="16384" type="CT_item"/>
   </xs:sequence>
   <xs:attribute name="ID" type="xs:int" default="0" use="optional"/>
   <xs:attribute name="Row" type="ST_excelRowNumber" default="0" use="optional"/>
   <xs:attribute name="ColFirst" type="ST_excelColNumber" default="0" use="optional"/>
   <xs:attribute name="Type" use="required" type="ST_Type"/>
 </xs:complexType>

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