2.2.4.24.18 Autofilters

  • Article

A list of auto filters. This element MUST contain the collection of all auto filters that are contained within the range defined in the Table element (section 2.2.4.24.35). An AutoFilter is considered to be contained within a range if one or more worksheet cells defined in a nested Item element (section 2.2.4.24.20) lie within the range. If an AutoFilter is defined on a hidden row within the range defined in the Table element, that AutoFilter MUST NOT be included in this collection. If all the worksheet cells defined in the nested Item elements that lie within the range defined in the Table element are present on hidden columns, that AutoFilter MUST NOT be included in this collection. This element MUST have one or zero AutoFilter elements having the Type attribute set to "Sheet".

 <s:complexType name="AutoFilters">
   <s:sequence>
     <s:element name="autofilter" type="AutoFilter" minOccurs="0" maxOccurs="unbounded" />
   </s:sequence>
 </s:complexType>

AutoFilter: An AutoFilter that lies within the range defined in the Table element.