Compartir a través de

2.6.47 CT_PivotHierarchy

  • Artículo

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:2016] section A.2, SHOULD<17> 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:2016] section A.2)

MUST NOT exist.

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

MUST NOT exist.

If this element exists, there MUST exist a CT_DataField element, as specified in [ISO/IEC29500-4:2016] section A.2, with an fld attribute equal to the zero-based index of a CT_CacheField element, as specified in [ISO/IEC29500-4:2016] section A.2, in the list of CT_CacheField elements specified by CT_CacheFields, as specified in [ISO/IEC29500-4:2016] section A.2, with a hierarchy attribute that specifies a CT_CacheHierarchy, as specified in [ISO/IEC29500-4:2016] 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:2016] 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:2016] 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/2] section 3.2.2, 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_PivotHierarchy">
   <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).