Share via

2.6.214 CT_SortRules

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2019/namedsheetviews

Referenced by: CT_NsvFilter

This complex type specifies an ordered collection of sort criteria to apply as part of a named sheet view.

Child Elements:

sortRule: A CT_SortRule element that specifies the sort criteria to apply on a single column.

extLst: A CT_ExtensionList ([ISO/IEC29500-1:2016] section A.2) that specifies future extensibility for this element.

Attributes:

sortMethod: An ST_SortMethod ([ISO/IEC29500-1:2016] section A.2) attribute that specifies the sort ordering to use.  Behavior of this attribute is equivalent to the sortMethod attribute contained on the sortState element as specified by [ISO/IEC29500-1:2016] section 18.3.1.92.

caseSensitive: A boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether sort is case sensitive or not.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_SortRules">
   <xsd:sequence>
     <xsd:element name="sortRule" minOccurs="0" maxOccurs="64" type="CT_SortRule"/>
     <xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attribute name="sortMethod" type="x:ST_SortMethod" use="optional" default="none"/>
   <xsd:attribute name="caseSensitive" type="xsd:boolean" use="optional" default="false"/>
 </xsd:complexType>

See section 5.26 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).