Notes
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de vous connecter ou de modifier des répertoires.
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de modifier des répertoires.
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.