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

1876.1.1CT_TabularSlicerCacheItems

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

Referenced by: CT_TabularSlicerCache

A complex type that specifies non-OLAP slicer items that are cached within this slicer cache.

Child Elements:

i: A CT_TabularSlicerCacheItem element that specifies a non-OLAP slicer item that is cached within this slicer cache. All CT_TabularSlicerCacheItem elements within this slicer cache MUST have unique x attributes. At least one CT_TabularSlicerCacheItem element MUST have s attribute be "true".

Attributes:

count: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of i child elements of this element.

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

1877

1878

1879

1880

1881

1882

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

1882.1.1CT_TabularSlicerCacheItem

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

Referenced by: CT_TabularSlicerCacheItems

A complex type that specifies a non-OLAP slicer item that is cached within this slicer cache.

Attributes:

x: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies an index of the associated PivotTable ([ISO/IEC29500-1:2012] section 18.10) cache item in the associated PivotTable ([ISO/IEC29500-1:2012] section 18.10) cache field. MUST be within the range of items as specified by the count attribute of the CT_PivotCacheRecords ([ISO/IEC29500-4:2012] section A.2) element of the associated non-OLAP PivotTable ([ISO/IEC29500-1:2012] section 18.10) PivotCache specified by the pivotCacheId attribute of the CT_TabularSlicerCache element that is an ancestor of this element.

s: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether a non-OLAP slicer item is selected.

Value	Meaning
"true"	A non-OLAP slicer item is selected.
"false"	A non-OLAP slicer item is not selected.

nd: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether a non-OLAP slicer item does not have data associated with it. This attribute MUST NOT exist if the crossFilter attribute of the CT_TabularSlicerCache element is equal to "none". For more information, see Slicer Cross Filtering.

Value	Meaning
"true"	A non-OLAP slicer item does not have data associated with it.
"false"	A non-OLAP slicer item has data associated with it.

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

1883

1884

1885

1886

1887

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

1887.1.1CT_PivotTableReferences

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: pivotTableReferences

A complex type that specifies a list of PivotTable ([ISO/IEC29500-1:2012] section 18.10) part identifiers for Non-Worksheet PivotTables. MUST contain fewer than 2³¹ elements.

Child Elements:

pivotTableReference: A CT_PivotTableReference element that specifies a PivotTable part identifier of a Non-Worksheet PivotTable.

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

1888

1889

1890

1891

1892

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

1892.1.1CT_PivotTableReference

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: CT_PivotTableReferences

A complex type that specifies a relationship identifier to a PivotTable ([ISO/IEC29500-1:2012] section 18.10) part in this workbook. The PivotTable specified by the element pivotTableDefinition ([ISO/IEC29500-1:2012] section 18.10.1.73) identified by this type MUST be a Non-Worksheet PivotTable and MUST satisfy the following criteria.

• 
  The ref attribute of the child element location ([ISO/IEC29500-1:2012] section 18.10.1.49) MUST begin with "A1".
  
• 
  The enableEdit attribute of the CT_PivotTableDefinition element, as specified in section 2.6.32, MUST NOT exist or MUST be "false" if exists; CT_PivotEdits and CT_PivotChanges elements MUST NOT exist in this part.
  
• 
  The PivotTable name specified by the name attribute of the element pivotTableDefinition ([ISO/IEC29500-1:2012] section 18.10.1.73), MUST be unique among all the PivotTables in the workbook.
  
• 
  There MUST be a child CT_PivotCache ([ISO/IEC29500-4:2012] section A.2) element within the pivotCaches element, specified by section 2.4.39, with the attribute cacheID having the same value as the cacheId attribute of the element pivotTableDefinition ([ISO/IEC29500-1:2012] section 18.10.1.73).
  
• 
  The PivotTable MUST NOT have CT_ConditionalFormats element as specified by section 2.6.49.
  

Attributes:

r:id: An ST_RelationshipId ([ISO/IEC29500-1:2012] section 22.8.2.1) attribute that specifies a relationship identifier to a PivotTable part in this workbook.

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

1893

1894

1895

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