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

1513.1.1CT_PivotCacheDefinition

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

Referenced by: pivotCacheDefinition

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

Attributes:

slicerData: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the Slicer Cache Relationship to PivotCache. MUST be "true" if the OLAP PivotTable ([ISO/IEC29500-1:2012] section 18.10) PivotCache definition is being referenced by a slicer cache.

pivotCacheId: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute which uniquely identifies this PivotTable ([ISO/IEC29500-1:2012] section 18.10) PivotCache. The value MUST be greater than or equal to zero. The value MUST NOT be zero if there is a slicer cache that uses this PivotTable ([ISO/IEC29500-1:2012] section 18.10) PivotCache as a data source, or if there is a CT_PivotCacheIdVersion element that is preceded by this element.

supportSubqueryNonVisual: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the OLAP source data of this PivotTable ([ISO/IEC29500-1:2012] section 18.10) supports hidden PivotTable items.

supportSubqueryCalcMem: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the OLAP source data of this PivotTable supports PivotTable calculated members in an OLAP subselect for filtering.

Value	Meaning
"true"	The OLAP source data of this PivotTable supports PivotTable calculated members in an OLAP subselect for filtering.
"false"	The OLAP source data of this PivotTable does not support PivotTable calculated members in an OLAP subselect for filtering.

supportAddCalcMems: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether PivotTable ([ISO/IEC29500-1:2012] section 18.10) calculated members are shown for filtering.

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

1514

1515

1516

1517

1518

1519

1520

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

1520.1.1CT_Connection

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

Referenced by: connection

A complex type that specifies the extended properties of an external connection ([ISO/IEC29500-1:2012] section 18.13).

Child Elements:

calculatedMembers: A CT_CalculatedMembers ([ISO/IEC29500-4:2012] section A.2) element that specifies a list of PivotTable ([ISO/IEC29500-1:2012] section 18.10) OLAP-calculated members associated with this external connection ([ISO/IEC29500-1:2012] section 18.13). If this external connection ([ISO/IEC29500-1:2012] section 18.13) is associated with a PivotTable ([ISO/IEC29500-1:2012] section 18.10) PivotCache, the list MUST NOT exist. If this element exists, the ancestor CT_connection ([ISO/IEC29500-4:2012] section A.2) element of this element MUST have a child CT_OlapPr ([ISO/IEC29500-1:2012] section 18.13.5) element.

Attributes:

culture: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the language associated with this external connection ([ISO/IEC29500-1:2012] section 18.13). The length of this string MUST be less than 85 characters. If the length of this string is greater than 0, the contents of this string MUST<14> be a language tag as specified by [RFC3066]. If this attribute is not present, the data connection is using the server language.

embeddedDataId: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies an embedded Custom Data part. The length of this value MUST be less than 65,536 characters. If the length of this string is greater than 0, the contents of this string MUST be equal to the id attribute of a CT_DatastoreItem element, in a Custom Data Properties part in this package ([ISO/IEC29500-1:2012] section 9).

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

1521

1522

1523

1524

1525

1526

1527

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

1527.1.1CT_Table

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

Referenced by: table

A complex type that specifies alternate text properties for the table.

Attributes:

altText: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the alternate text for the table. The string MUST be less than or equal to 25,000 characters in length.

altTextSummary: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the alternate text summary for the table. The string MUST be less than or equal to 50,000 characters in length.

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

1528

1529

1530

1531

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