SlicerCacheHideItemsWithNoData class

2.4.53 slicerCacheHideItemsWithNoData

Target namespace: http://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.<30> 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.103 CT_SlicerCacheHideNoData

Target namespace: http://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.<79>

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).

Reference