Share via


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.

See also

Reference

SlicerCacheHideItemsWithNoData members

DocumentFormat.OpenXml.Office15.Excel namespace