ssml:filterColumn
AutoFilter Column
Element information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-autoFilter.xsd
Type: ssml:CT_FilterColumn
Properties: Local, Qualified
Content
- Choice [0..1]
- ssml:filters [0..1] Filter Criteria
- ssml:top10 [0..1] Top 10
- ssml:customFilters [0..1] Custom Filters
- ssml:dynamicFilter [0..1] Dynamic Filter
- ssml:colorFilter [0..1] Color Filter Criteria
- ssml:iconFilter [0..1] Icon Filter
- ssml:extLst [0..1] Future Feature Storage Area
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| colId | [1..1] | xsd:unsignedInt | Filter Column Data | |
| hiddenButton | [0..1] | xsd:boolean | Hidden AutoFilter Button | Default value is "false". |
| showButton | [0..1] | xsd:boolean | Show Filter Button | Default value is "true". |
Used in
- Type ssml:CT_AutoFilter (Elements ssml:autoFilter, ssml:autoFilter, ssml:autoFilter, ssml:autoFilter)
Sample instance
<ssml:filterColumn colId="1"> <ssml:filters> <ssml:filter/> <ssml:dateGroupItem year="1" dateTimeGrouping="year"/> </ssml:filters> </ssml:filterColumn>