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/IEC29500-4:2016] section A.2) element that SHOULD<18> 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/IEC29500-4:2016] section A.2)

MUST NOT exist.

CT_X ([ISO/IEC29500-4:2016] section A.2)

MUST NOT exist.

CT_SharedItems ([ISO/IEC29500-4:2016] section A.2)

MUST NOT exist.

If this element exists, there MUST exist a CT_DataField ([ISO/IEC29500-4:2016] 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/IEC29500-4:2016] 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/2] section 3.2.2) attribute that MUST be "true" and MUST be ignored.

The following W3C XML Schema ([XMLSCHEMA1/2] 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/2] section 2.1).