Share via

2.6.213 CT_SortRule

  • Article

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

Referenced by: CT_SortRules

This complex type specifies the sort criteria to be applied to a single column as part of a named sheet view.

Child Elements:

dxf: A CT_Dxf ([ISO/IEC29500-1:2016] section A.2).  If the sortCondition element within this type specifies a dxfId attribute then this element MUST be present and MUST be used in place of the one referenced by that dxfId attribute.  If the sortCondition element within this type does NOT specify a dxfId attribute then this element MUST be omitted.

sortCondition: A CT_SortCondition element that specifies the sort condition to apply to the column.

richSortCondition: A CT_RichSortCondition element that specifies the sort condition associated with rich values. To apply to the column.

Attributes:

colId: An unsignedInt ([XMLSCHEMA2/2] section 3.3.22) attribute that specifies the zero-based index of the column that this filter is applied to.  When loading this element colId and id SHOULD be considered as described in section 2.3.8.2.

id: An ST_Guid ([ISO/IEC29500-1:2016] section 22.9.2.4) attribute that specifies the unique id of the column this filter is applied to.  When loading this element colId and id SHOULD be considered as described in section 2.3.8.2.

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

 <xsd:complexType name="CT_SortRule">
   <xsd:sequence>
     <xsd:element name="dxf" type="x:CT_Dxf" minOccurs="0" maxOccurs="1"/>
     <xsd:choice minOccurs="0" maxOccurs="1">
       <xsd:element name="sortCondition" minOccurs="0" maxOccurs="1" type="x14:CT_SortCondition"/>
       <xsd:element name="richSortCondition" minOccurs="0" maxOccurs="1" type="xlrd2:CT_RichSortCondition"/>
     </xsd:choice>
   </xsd:sequence>
   <xsd:attributeGroup ref="AG_ColumnId"/>
 </xsd:complexType>

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