[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation

1798.1.1CT_SlicerCachePivotTables

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: slicerCachePivotTables, CT_SlicerCacheDefinition

A complex type that specifies a group of CT_SlicerCachePivotTable elements that specify the PivotTable ([ISO/IEC29500-1:2012] section 18.10) views that are filtered by the slicer cache.

Child Elements:

pivotTable: A CT_SlicerCachePivotTable element that specifies the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view that is filtered. The list of pivotTable child elements MUST NOT contain duplicates. The showCalcMbrs attribute of all CT_PivotTableDefinition ([ISO/IEC29500-4:2012] section A.2) elements associated with PivotTables ([ISO/IEC29500-1:2012] section 18.10) that are specified by pivotTable child elements MUST have the same value.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

1799

1800

1801

1802

1803

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

1803.1.1CT_SlicerCachePivotTable

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_SlicerCachePivotTables

A complex type that specifies a PivotTable ([ISO/IEC29500-1:2012] section 18.10) view filtered by a slicer cache.

Attributes:

tabId: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the unique identifier (UID) of the worksheet that contains the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view specified by the name attribute. MUST match the sheetId of an existing sheet ([ISO/IEC29500-4:2012] section A.2) element within the workbook. MUST be ignored if the PivotTable specified by the name attribute is a Non-Worksheet PivotTable.

name: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the name of the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view on the worksheet specified by tabId or a Non-Worksheet PivotTable. MUST match the name attribute of an existing pivotTableDefinition element in the worksheet. The createdVersion attribute of the CT_PivotTableDefinition ([ISO/IEC29500-4:2012] section A.2) element that defines the specified PivotTable ([ISO/IEC29500-1:2012] section 18.10) MUST be greater than or equal to 3. Field showCalcMbrs of all PivotTable ([ISO/IEC29500-1:2012] section 18.10) MUST have the same value. Field calculatedMembersInFilters of CT_PivotTableDefinition of all PivotTable ([ISO/IEC29500-1:2012] section 18.10) MUST have the same value.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

1804

1805

1806

1807

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

1807.1.1CT_OlapSlicerCacheItem

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_OlapSlicerCacheRange

This element specifies an OLAP slicer item of the OLAP level in the OLAP hierarchy specified by the ancestor CT_OlapSlicerCacheLevelData element. This element contains a list of all ancestor OLAP members of this OLAP slicer item in the OLAP hierarchy.

Child Elements:

p: A CT_OlapSlicerCacheItemParent element that specifies the OLAP members that are ascendants of the OLAP slicer item specified by this element. The first element in this list specifies the OLAP member that is the parent of the OLAP slicer item specified by this element. Each subsequent element in this list specifies an ascendant OLAP member in the next level up the OLAP hierarchy.

Attributes:

n: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the MDX unique name of the OLAP member associated with the OLAP slicer item specified by this element.

c: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the caption of the OLAP slicer item specified by this element.

nd: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the OLAP slicer item specified by this element has no data associated with it. This attribute MUST NOT exist if the crossFilter attribute of the ancestor element CT_OlapSlicerCacheLevelData is "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.

1808

1809

1810

1811

1812

1813

1814

1815

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

1815.1.1CT_OlapSlicerCacheItemParent

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_OlapSlicerCacheItem, CT_OlapSlicerCacheSelection

This element specifies an ancestor OLAP member of the OLAP member specified by CT_OlapSlicerCacheItem or CT_OlapSlicerCacheSelection element that contains this element.

Attributes:

n: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the MDX unique name of the OLAP member specified by this element.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

1816

1817

1818

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).