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

1599.1.1CT_PivotHierarchy

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

Referenced by: pivotHierarchy

A complex type that specifies whether the ancestor CT_PivotHierarchy element, as specified in [ISO/IEC29500-4:2012] section A.2, SHOULD<15> be ignored.

The ancestor CT_PivotHierarchy element has the following restrictions on attributes.

Name	Value
caption	MUST NOT be specified.
dragOff	MUST equal "false".
dragToCol	MUST equal "false".
dragToData	MUST equal "true".
dragToPage	MUST equal "false".
dragToRow	MUST equal "false".
includeNewItemsInFilter	MUST equal "true".
multipleItemSelectionAllowed	MUST NOT be specified.
outline	MUST NOT be specified.
showInFieldList	MUST NOT be specified.
subtotalTop	MUST NOT be specified.

The ancestor CT_PivotHierarchy element has the following restrictions on child elements.

Child element	Restriction
CT_PivotHierarchy (this element)	Exactly 1 MUST exist.
CT_Members ([ISO/IEC29500-4:2012] section A.2)	MUST NOT exist.
CT_MemberProperties ([ISO/IEC29500-4:2012] section A.2)	MUST NOT exist.

If this element exists, there MUST exist a CT_DataField element, as specified in [ISO/IEC29500-4:2012] section A.2, with an fld attribute equal to the zero-based index of a CT_CacheField element, as specified in [ISO/IEC29500-4:2012] section A.2, in the list of CT_CacheField elements specified by CT_CacheFields, as specified in [ISO/IEC29500-4:2012] section A.2, with a hierarchy attribute that specifies a CT_CacheHierarchy, as specified in [ISO/IEC29500-4:2012] section A.2, with a zero-based index in the list of CT_CacheHierarchy elements specified by the CT_CacheHierarchies element, as specified in([ISO/IEC29500-4:2012] section A.2, equal to the zero-based index of the ancestor CT_PivotHierarchy element in the list of CT_PivotHierarchy elements specified by CT_PivotHierarchies, as specified in [ISO/IEC29500-4:2012] section A.2. Additionally, that CT_DataField element MUST have a descendant CT_DataField element, as specified in section 2.6.25, with a sourceField attribute specified.

For more details, see section 2.6.25.

Attributes:

ignore: A Boolean attribute, as specified in [XMLSCHEMA2] section 3.2.2, 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.

1600

1601

1602

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

1602.1.1CT_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:2012] section A.2) element that SHOULD<16> 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:2012] section A.2)	MUST NOT exist.
CT_X ([ISO/IEC29500-4:2012] section A.2)	MUST NOT exist.
CT_SharedItems ([ISO/IEC29500-4:2012] section A.2)	MUST NOT exist.

If this element exists, there MUST exist a CT_DataField ([ISO/IEC29500-4:2012] 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:2012] 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.

1603

1604

1605

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