Share via

2.6.138 CT_PivotCacheIdVersion

  • Article

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

Referenced by: pivotCacheIdVersion

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

Attributes:

cacheIdSupportedVersion: An unsignedByte ([XMLSCHEMA2/2] section 3.3.24) attribute that specifies minimum version of the application where this pivotCacheId attribute of an existing CT_PivotCacheDefinition element is guaranteed to be unique.

cacheIdCreatedVersion: An unsignedByte ([XMLSCHEMA2/2] section 3.3.24) attribute that specifies the minimum version of the application where this pivotCacheId attribute of an existing CT_PivotCacheDefinition element can be changed upon saving the workbook.

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

 <xsd:complexType name="CT_PivotCacheIdVersion">
   <xsd:attribute name="cacheIdSupportedVersion" type="xsd:unsignedByte" use="required"/>
   <xsd:attribute name="cacheIdCreatedVersion" type="xsd:unsignedByte" use="required"/>
 </xsd:complexType>

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