<autoFilter>
(AutoFilter Settings)
AutoFilter temporarily hides rows based on a filter criteria, which is applied column by column to a table of data in the worksheet. This collection expresses AutoFilter settings.
example:
<autoFilter ref="B3:E8"> <filterColumn colId="1"> <customFilters> <customFilter operator="greaterThan" val="0.5"/> </customFilters> </filterColumn> </autoFilter>
Parent Elements |
---|
|
Child Elements |
Subclause |
---|---|
|
|
|
|
|
Attributes |
Description |
---|---|
|
Reference to the cell range to which the AutoFilter is applied. The possible values for this attribute are defined by the ST_Ref simple type (§3.18.64). |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_AutoFilter">
<sequence>
<element name="filterColumn" minOccurs="0" maxOccurs="unbounded" type="CT_FilterColumn"/>
<element name="sortState" minOccurs="0" maxOccurs="1" type="CT_SortState"/>
<element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
</sequence>
<attribute name="ref" type="ST_Ref"/>
</complexType>