Share via


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.

See Also

Reference

TabularSlicerCacheItem Members

DocumentFormat.OpenXml.Office2010.Excel Namespace