CacheField Class
Defines the CacheField Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:cacheField.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Office2010.Excel.CacheField
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class CacheField _
Inherits OpenXmlLeafElement
'Usage
Dim instance As CacheField
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class CacheField : OpenXmlLeafElement
Remarks
2.4.25 cacheField
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
This CT_CacheField element specifies that duplicate OLAP measures exist in a PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache Defintion. See Pivot Table Cache Definition under Extensions by Part for how this element integrates with [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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.48 CT_CacheField
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
Referenced by: cacheField
This complex type specifies the ancestor CT_CacheField ([ISO/IEC-29500-4] section A.2) element that SHOULD<39> be ignored.
The ancestor CT_CacheField ([ISO/IEC-29500-4] section A.2) element has the following restrictions on attributes:
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 0 |
propertyName |
MUST NOT be specified |
serverField |
MUST NOT be specified |
sqlType |
MUST NOT be specified |
uniqueList |
MUST NOT be specified |
The ancestor CT_CacheField ([ISO/IEC-29500-4] section A.2) element has the following restrictions on child elements:
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 a fld attribute equal to the zero-based index of the ancestor CT_CacheField ([ISO/IEC-29500-4] section A.2) element in the list of CT_CacheField ([ISO/IEC-29500-4] section A.2) elements specified by CT_CacheFields ([ISO/IEC-29500-4] section A.2). Additionally, that CT_DataField ([ISO/IEC-29500-4] section A.2) element MUST have a descendant CT_DataField element 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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.