TabularSlicerCacheItem Class
Defines the TabularSlicerCacheItem Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:i.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Office2010.Excel.TabularSlicerCacheItem
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class TabularSlicerCacheItem _
Inherits OpenXmlLeafElement
'Usage
Dim instance As TabularSlicerCacheItem
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class TabularSlicerCacheItem : OpenXmlLeafElement
Remarks
2.6.79 CT_TabularSlicerCacheItem
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
Referenced by: CT_TabularSlicerCacheItems
A complex type that specifies a non-OLAP slicer item that is cached within this slicer cache.
Attributes:
x : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies an index of the associated PivotTable ([ISO/IEC-29500-1] section 18.10) cache item in the associated PivotTable ([ISO/IEC-29500-1] section 18.10) cache field. MUST be within the range of items as specified by the count attribute of CT_PivotCacheRecords ([ISO/IEC-29500-4] section A.2) element of the associated non-OLAP PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache specified by the pivotCacheId attribute of the CT_TabularSlicerCache element that is an ancestor of this element.
s : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether a non-OLAP slicer item is selected.
nd : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether a non-OLAP slicer item does not have data associated with it. MUST NOT exist if the crossFilter attribute of the CT_TabularSlicerCache element is equal to “none”. For more information, see Slicer Cross Filtering*.*
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_TabularSlicerCacheItem">
<xsd:attribute name="x" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="s" type="xsd:boolean" use="optional" default="false"/>
<xsd:attribute name="nd" type="xsd:boolean" use="optional" default="false"/>
</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.