CacheField class

Office 2013 and later

Defines the CacheField Class.This class is available in Office2010 or above. When the object is serialized out as xml, its qualified name is x14:cacheField.

Namespace:  DocumentFormat.OpenXml.Office2010.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

2.4.27 cacheField

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

The cacheField element is a CT_CacheField type element, as specified in section 2.6.48, that specifies that duplicate OLAP measures exist in a PivotTable, as specified in [ISO/IEC-29500-1] section 18.10, PivotCache definition. See section 2.2.4.5 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC-29500-1].

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

<xsd:element name="cacheField" type="CT_CacheField"/>

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

2.6.48 CT_CacheField

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

Referenced by: cacheField

This complex type specifies the ancestor CT_CacheField ([ISO/IEC-29500-4] section A.2) element that SHOULD<53> be ignored.

The following table lists the restrictions on attributes of the ancestor CT_CacheField element.

Name

Value

caption

MUST NOT be specified.

databaseField

MUST NOT be specified.

formula

MUST NOT be specified.

level

MUST equal "32767".

mappingCount

MUST NOT be specified.

memberPropertyField

MUST NOT be specified.

numFmtId

MUST equal zero ("0").

propertyName

MUST NOT be specified.

serverField

MUST NOT be specified.

sqlType

MUST NOT be specified.

uniqueList

MUST NOT be specified.

The following table lists the restrictions on child elements of the ancestor CT_CacheField element.

Child element

Restriction

CT_CacheField (this element)

Exactly 1 MUST exist.

CT_FieldGroup ([ISO/IEC-29500-4] section A.2)

MUST NOT exist.

CT_X ([ISO/IEC-29500-4] section A.2)

MUST NOT exist.

CT_SharedItems ([ISO/IEC-29500-4] section A.2)

MUST NOT exist.

If this element exists, there MUST exist a CT_DataField ([ISO/IEC-29500-4] section A.2) element with an fld attribute equal to the zero-based index of the ancestor CT_CacheField element in the list of CT_CacheField elements specified by CT_CacheFields ([ISO/IEC-29500-4] section A.2). Additionally, that CT_DataField element MUST have a descendant CT_DataField element (section 2.6.25) with a sourceField attribute specified.

For more details, see CT_DataField

Attributes:

ignore: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that MUST be "true" and MUST be ignored.

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

<xsd:complexType name="CT_CacheField">

<xsd:attribute name="ignore" type="xsd:boolean" default="false" use="optional"/>

</xsd:complexType>

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

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show: