TabularSlicerCache class
Defines the TabularSlicerCache Class.This class is available in Office2010 or above. When the object is serialized out as xml, its qualified name is x14:tabular.
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Office2010.Excel.TabularSlicerCache
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
2.6.83 CT_TabularSlicerCache
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main
Referenced by: CT_SlicerCacheData
A complex type that specifies non-OLAP slicer items that are cached within this slicer cache and properties of the slicer cache specific to non-OLAP slicer items.
Child Elements:
items: A CT_TabularSlicerCacheItems element that specifies non-OLAP slicer items that are cached within this slicer cache.
extLst: A CT_ExtensionList ([ISO/IEC-29500-4] section A.2) element that specifies future extensibility for this element.
Attributes:
pivotCacheId: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the associated non-OLAP PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache. MUST match the pivotCacheId attribute of an existing CT_PivotCacheDefinition element.
sortOrder: An ST_TabularSlicerCacheSortOrder attribute that specifies how the non-OLAP slicer items are sorted in the slicer view.
customListSort: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether custom lists are used when sorting the non-OLAP slicer items.
Value | Meaning |
"false" | Custom lists are not used when sorting the non-OLAP slicer items. |
"true" | Custom lists are used when sorting the non-OLAP slicer items. |
showMissing: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether non-OLAP slicer items that correspond to unused PivotTable ([ISO/IEC-29500-1] section 18.10) cache items that existed previously, but are no longer present in the PivotTable ([ISO/IEC-29500-1] section 18.10) source data, are displayed.
Value | Meaning |
"false" | The unused non-OLAP slicer items are not displayed. |
"true" | The unused non-OLAP slicer items are displayed. |
crossFilter: An ST_SlicerCacheCrossFilter attribute that specifies how the non-OLAP slicer items that are used in slicer cross filtering are displayed.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_TabularSlicerCache">
<xsd:sequence>
<xsd:element name="items" type="CT_TabularSlicerCacheItems" minOccurs="1" maxOccurs="1"/>
<xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
</xsd:sequence>
<xsd:attribute name="pivotCacheId" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="sortOrder" type="ST_TabularSlicerCacheSortOrder" use="optional" default="ascending"/>
<xsd:attribute name="customListSort" type="xsd:boolean" use="optional" default="true"/>
<xsd:attribute name="showMissing" type="xsd:boolean" use="optional" default="true"/>
<xsd:attribute name="crossFilter" type="ST_SlicerCacheCrossFilter" use="optional" default="showItemsWithDataAtTop"/>
</xsd:complexType>
See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).