<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

<customSheetView> (§3.3.1.23); <filter> (§3.10.1.33); <table> (§3.5.1.2); <worksheet> (§3.3.1.96)

Child Elements

Subclause

<extLst> (Future Feature Data Storage Area)

§3.2.10

<filterColumn> (AutoFilter Column)

§3.3.2.7

<sortState> (Sort State)

§3.3.1.89

Attributes

Description

<ref> (Cell or Range Reference)

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>