[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

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:2011] section 18.10) view specified by the name attribute. MUST match the sheetId of an existing sheet (1) ([ISO/IEC29500-4:2011] 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:2011] section 22.9.2.19) attribute that specifies the name of the PivotTable ([ISO/IEC29500-1:2011] 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:2011] section A.2) element that defines the specified PivotTable ([ISO/IEC29500-1:2011] section 18.10) MUST be greater than or equal to 3. Field (1) showCalcMbrs of all PivotTable ([ISO/IEC29500-1:2011] section 18.10) MUST have the same value. Field (1) calculatedMembersInFilters of CT_PivotTableDefinition of all PivotTable ([ISO/IEC29500-1:2011] 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.

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

2.6.74 CT_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: