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

1776.1.1CT_Slicer

Target namespace: http://schemas.microsoft.com/office/drawing/2010/slicer

Referenced by: slicer

This complex type specifies which slicer view is associated with this drawing element.

Child Elements:

extLst: A CT_OfficeArtExtensionList ([ISO/IEC29500-4:2012] section A.4.1) element that specifies future extensibility for this element.

Attributes:

name: A string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the name of the slicer view that is associated with this drawing element. The value of this attribute MUST match the value of the name attribute of a slicer element within the CT_Slicers element for the current worksheet.

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

1777

1778

1779

1780

1781

1782

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

1782.1.1CT_SlicerCacheDefinition

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

Referenced by: slicerCacheDefinition

A complex type that specifies a slicer cache.

Child Elements:

pivotTables: A CT_SlicerCachePivotTables element (section 2.6.72) that specifies a group of CT_SlicerCachePivotTable elements (section 2.6.73) that specify the PivotTable ([ISO/IEC29500-1:2012] section 18.10) views that are filtered by the slicer cache (section 2.1.4).

data: A CT_SlicerCacheData element (section 2.6.71) that specifies a data source for the slicer cache.

extLst: A CT_ExtensionList element, as specified in [ISO/IEC29500-4:2012] section A.2, that specifies future extensibility for this element.

Attributes:

name: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the name of the slicer cache. MUST adhere to the name production rule provided in section 2.2.2. MUST be a unique case-insensitive name within the scope of defined names.

xr10:uid: An ST_Guid ([ISO/IEC29500-1:2012] section 22.9.2.4) attribute that specifies the unique id of the slicer cache. If any instance of this type specifies this attribute, then all instances MUST specify it, and the values must be distinct.

sourceName: An ST_Xstring attribute that specifies the MDX unique name or PivotTable ([ISO/IEC29500-1:2012] section 18.10) cache field of the associated PivotTable PivotCache used by the slicer cache.

• 
  If the slicer source data (section 2.3.2.1.1)is a non-OLAP data source, the value of this attribute MUST be equal to the name attribute of a CT_CacheField ([ISO/IEC29500-4:2012] section A.2) element in the list of cache fields, as specified in section 2.3.2.1.2, and specify a PivotTable cache field. The specified CT_CacheField MUST have a serverField attribute equal to "false". The includeNewItemsInFilter attributes of the CT_PivotField ([ISO/IEC29500-4:2012] section A.2) elements of all included CT_CacheField elements MUST be equal.
  
• 
  If the slicer source data is an OLAP data source, the value MUST be equal to the value of the uniqueName attribute in one of the CT_CacheHierarchy ([ISO/IEC29500-4:2012] section A.2) elements within the associated OLAP pivot cache, as specified in section 2.3.2.1.4, and specify a MDX unique name. The following attributes of the CT_CacheHierarchy element MUST be "false": measure, set, and measures. The CT_PivotHierarchy ([ISO/IEC29500-4:2012] section A.2) element with a zero-based index in the list of CT_PivotHierarchy elements specified by the CT_PivotHierarchies ([ISO/IEC29500-4:2012] section A.2) equal to the zero-based index of the CT_CacheHierarchy element in the list of CT_CacheHierarchy elements specified by CT_CacheHierarchies ([ISO/IEC29500-4:2012] section A.2) MUST have an includeNewItemsInFilter attribute equal to "false".
  

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

1783

1784

1785

1786

1787

1788

1789

1790

1791

1792

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

1792.1.1CT_SlicerCacheData

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

Referenced by: CT_SlicerCacheDefinition

A complex type that specifies a data source for the slicer cache.

Child Elements:

olap: A CT_OlapSlicerCache element that specifies an OLAP data source.

tabular: A CT_TabularSlicerCache element that specifies a non-OLAP data source.

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

1793

1794

1795

1796

1797

1798

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