ssml:sortState
Sort State
Element information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-queryTable.xsd
Other elements with the same name: ssml:sortState
Type: ssml:CT_SortState
Properties: Local, Qualified
Content
- Sequence [1..1]
- ssml:sortCondition [0..64] Sort Condition
- ssml:extLst [0..1] Future Feature Storage Area
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| columnSort | [0..1] | xsd:boolean | Sort by Columns | Default value is "false". |
| caseSensitive | [0..1] | xsd:boolean | Case Sensitive | Default value is "false". |
| sortMethod | [0..1] | ssml:ST_SortMethod | Sort Method | Default value is "none". |
| ref | [1..1] | ssml:ST_Ref | Sort Range |
Used in
- Type ssml:CT_Macrosheet
- Type ssml:CT_QueryTableRefresh (Element ssml:queryTableRefresh)
- Type ssml:CT_Table (Element ssml:table)
- Type ssml:CT_Worksheet (Element ssml:worksheet)
Sample instance
<ssml:sortState ref="string"> <ssml:sortCondition ref="string" iconSet="3Arrows"/> <ssml:extLst> <ssml:ext> <!--any element--> </ssml:ext> </ssml:extLst> </ssml:sortState>