2.7.13 ST_SlicerStyleType

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

Referenced by: CT_SlicerStyleElement

A simple type that specifies the types of table style ([ISO/IEC29500-1:2016] section 18.8) elements that are specific to slicers. The possible values are listed in the following table.

Value

Meaning

unselectedItemWithData

A slicer item with data that is not selected. Used for slicers only.

selectedItemWithData

A selected slicer item with data. Used for slicers only.

unselectedItemWithNoData

A slicer item with no data that is not selected. Used for slicers only.

selectedItemWithNoData

A selected slicer item with no data. Used for slicers only.

hoveredUnselectedItemWithData

A slicer item with data that is not selected and over which the mouse is paused on. Used for slicers only.

hoveredSelectedItemWithData

A selected slicer item with data and over which the mouse is paused on. Used for slicers only.

hoveredUnselectedItemWithNoData

A slicer item with no data that is not selected and over which the mouse is paused on. Used for slicers only.

hoveredSelectedItemWithNoData

A selected slicer item with no data and over which the mouse is paused on. Used for slicers only.

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

 <xsd:simpleType name="ST_SlicerStyleType">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="unselectedItemWithData"/>
     <xsd:enumeration value="selectedItemWithData"/>
     <xsd:enumeration value="unselectedItemWithNoData"/>
     <xsd:enumeration value="selectedItemWithNoData"/>
     <xsd:enumeration value="hoveredUnselectedItemWithData"/>
     <xsd:enumeration value="hoveredSelectedItemWithData"/>
     <xsd:enumeration value="hoveredUnselectedItemWithNoData"/>
     <xsd:enumeration value="hoveredSelectedItemWithNoData"/>
   </xsd:restriction>
 </xsd:simpleType>

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