TabularSlicerCache Class
Defines the TabularSlicerCache Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:tabular.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Office2010.Excel.TabularSlicerCache
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(TabularSlicerCacheItems), FileFormatVersions.Office2010)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(ExtensionList), FileFormatVersions.Office2010)> _
Public Class TabularSlicerCache _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As TabularSlicerCache
[ChildElementInfoAttribute(typeof(TabularSlicerCacheItems), FileFormatVersions.Office2010)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(ExtensionList), FileFormatVersions.Office2010)]
public class TabularSlicerCache : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
TabularSlicerCacheItems <x14:items>
ExtensionList <x14:extLst>
2.6.77 CT_TabularSlicerCache
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/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<55>.
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<56>.
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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.