SlicerCacheHideItemsWithNoData class
Defines the SlicerCacheHideItemsWithNoData Class.This class is only available in O15. When the object is serialized out as xml, its qualified name is x15:slicerCacheHideItemsWithNoData.
Inheritance hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Office15.Excel.SlicerCacheHideItemsWithNoData
Namespace: DocumentFormat.OpenXml.Office15.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office15)> _
<ChildElementInfoAttribute(GetType(SlicerCacheOlapLevelName), FileFormatVersions.Office15)> _
Public Class SlicerCacheHideItemsWithNoData _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As SlicerCacheHideItemsWithNoData
[OfficeAvailabilityAttribute(FileFormatVersions.Office15)]
[ChildElementInfoAttribute(typeof(SlicerCacheOlapLevelName), FileFormatVersions.Office15)]
public class SlicerCacheHideItemsWithNoData : OpenXmlCompositeElement
Remarks
2.4.58 slicerCacheHideItemsWithNoData
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/11/main
A CT_SlicerCacheHideNoData element that specifies the extended properties of a slicer cache, as specified in section 2.3.2.1. If this element exists, the non-OLAP slicer items that have no data in its ancestor slicer cache are not displayed and the OLAP slicer items that have no data are not displayed for the OLAP levels specified by the uniqueName attribute of the CT_SlicerCacheOlapLevelName element.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
<xsd:element name="slicerCacheHideItemsWithNoData" type="CT_SlicerCacheHideNoData"/>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.115 CT_SlicerCacheHideNoData
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/11/main
Referenced by: slicerCacheHideItemsWithNoData
A complex type that specifies the extended properties of a slicer cache, as specified in section 2.3.2.1.
Child Elements:
slicerCacheOlapLevelName: A CT_SlicerCacheOlapLevelName element that specifies the properties of an OLAP level in the OLAP hierarchy specified by the ancestor slicer cache. slicer items with no data in this OLAP level are not displayed.
Attributes:
count: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of slicerCacheOlapLevelName child elements of this element.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_SlicerCacheHideNoData">
<xsd:sequence>
<xsd:element name="slicerCacheOlapLevelName" type="CT_SlicerCacheOlapLevelName" minOccurs="0" maxOccurs="unbounded"/>
</xsd:sequence>
<xsd:attribute name="count" type="xsd:unsignedInt" use="optional" default="0"/>
</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.