Share via

2.7.20 ST_TabularSlicerCacheSortOrder

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_TableSlicerCache, CT_TabularSlicerCache

A simple type that specifies how the non-OLAP slicer items are sorted in the slicer view.

Value

Meaning

ascending

The non-OLAP slicer items are sorted in ascending alphabetical order.

descending

The non-OLAP slicer items are sorted in descending alphabetical order.

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

 <xsd:simpleType name="ST_TabularSlicerCacheSortOrder">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="ascending"/>
     <xsd:enumeration value="descending"/>
   </xsd:restriction>
 </xsd:simpleType>

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