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

1352.1.1CT_SlicerCaches

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

Referenced by: slicerCaches, slicerCaches

A complex type that specifies a list of slicer cache part identifiers for the workbook. MUST contain fewer than 2³¹ elements.

Child Elements:

slicerCache: A CT_SlicerCache element that specifies a slicer cache part identifier in this workbook.

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

1353

1354

1355

1356

1357

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

1357.1.1CT_SlicerCache

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

Referenced by: CT_SlicerCaches

A complex type that specifies a relationship identifier to a slicer cache part in this workbook.

Attributes:

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

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

1358

1359

1360

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

1360.1.1CT_CalculatedMember

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

Referenced by: calculatedMember

A complex type that specifies extended properties of a PivotTable ([ISO/IEC29500-1:2012] section 18.10) OLAP calculated member.

Child Elements:

tupleSet: A CT_TupleSet element (section 2.6.16) that specifies OLAP tuples within this OLAP named set.

Attributes:

displayFolder: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the display folder of this PivotTable ([ISO/IEC29500-1:2012] section 18.10) named set. The length of this value MUST be less than 65,536 characters. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember ([ISO/IEC29500-4:2012] section A.2) element is zero ("0").

flattenHierarchies: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to display members from different OLAP levels of the same PivotTable cache hierarchy of this PivotTable named set in the same PivotTable field. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").

Value	Meaning
"0"	Each member from a different level of the same PivotTable cache hierarchy of this PivotTable named set is displayed in a separate PivotTable field.
"1"	All members from different levels of the same PivotTable cache hierarchy of this PivotTable named set are displayed in the same PivotTable field.

dynamicSet: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether this PivotTable named set is a dynamic OLAP named set. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").

Value	Meaning
"0"	This PivotTable named set is a static OLAP named set.
"1"	This PivotTable named set is a dynamic OLAP named set.

hierarchizeDistinct: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to automatically order and remove duplicates from this PivotTable named set. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").

Value	Meaning
"0"	Do not automatically order and remove duplicates from this PivotTable named set.
"1"	Automatically order and remove duplicates from this PivotTable named set.

mdxLong: An ST_Xstring attribute that specifies Multidimensional Expressions (MDX) of the PivotTable OLAP calculated member. The length of this attribute MUST be zero or it MUST be greater than 32,767 characters and less than 1,073,741,823 characters. If this value is greater than 32,767 characters, the length of the mdx attribute in the ancestor CT_CalculatedMember element MUST be "1" and the first character of the mdx attribute MUST be equal to " ", the space character (0x0020).

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

1361

1362

1363

1364

1365

1366

1367

1368

1369

1370

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