2.7.21 ST_SlicerCacheCrossFilter
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main
Referenced by: CT_TableSlicerCache, CT_OlapSlicerCacheLevelData, CT_TabularSlicerCache
A simple type that specifies how the slicer items that are used in slicer cross filtering are displayed.
|
Value |
Meaning |
|---|---|
|
none |
The table style ([ISO/IEC29500-1:2016] section 18.8) element of the slicer style for slicer items with no data is not applied to slicer items with no data, and slicer items with no data are not sorted separately in the list of slicer items in the slicer view. |
|
showItemsWithDataAtTop |
The table style ([ISO/IEC29500-1:2016] section 18.8) element of the slicer style for slicer items with no data is applied to slicer items with no data, and slicer items with no data are sorted at the bottom in the list of slicer items in the slicer view. |
|
showItemsWithNoData |
The table style ([ISO/IEC29500-1:2016] section 18.8) element of the slicer style for slicer items with no data is applied to slicer items with no data, and slicer items with no data are not sorted separately in the list of slicer items in the slicer view. |
The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this simple type.
-
<xsd:simpleType name="ST_SlicerCacheCrossFilter"> <xsd:restriction base="xsd:string"> <xsd:enumeration value="none"/> <xsd:enumeration value="showItemsWithDataAtTop"/> <xsd:enumeration value="showItemsWithNoData"/> </xsd:restriction> </xsd:simpleType>
See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).