ssml:autoFilter

AutoFilter

Element information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

Schema document: sml-sheet.xsd

Other elements with the same name: ssml:autoFilter, ssml:autoFilter, ssml:autoFilter

Type: ssml:CT_AutoFilter

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:filterColumn [0..*] AutoFilter Column
2. ssml:sortState [0..1] Sort State for Auto Filter
3. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
ref	[0..1]	ssml:ST_Ref	Cell or Range Reference

Used in

Type ssml:CT_Macrosheet
Type ssml:CT_Worksheet (Element ssml:worksheet)

Sample instance

<ssml:autoFilter>
   <ssml:filterColumn colId="1">
      <ssml:filters>
         <ssml:filter/>
         <ssml:dateGroupItem year="1" dateTimeGrouping="year"/>
      </ssml:filters>
   </ssml:filterColumn>
   <ssml:sortState ref="string">
      <ssml:sortCondition ref="string" iconSet="3Arrows"/>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:sortState>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:autoFilter>