2.6.31 CT_PivotField
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main
Referenced by: pivotField
This complex type specifies additional properties of a PivotTable ([ISO/IEC29500-1:2016] section 18.10) field.
Attributes:
fillDownLabels: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether the PivotTable ([ISO/IEC29500-1:2016] section 18.10) item labels are repeated for this PivotTable ([ISO/IEC29500-1:2016] section 18.10) field. This attribute is ignored when the compact attribute and the outline attribute of the PivotTable ([ISO/IEC29500-1:2016] section 18.10) field are "true". This attribute is ignored if the PivotTable ([ISO/IEC29500-1:2016] section 18.10) field is not on the PivotTable ([ISO/IEC29500-1:2016] section 18.10) row axis or the PivotTable ([ISO/IEC29500-1:2016] section 18.10) column axis. This value MUST be one of the following:
|
Value |
Meaning |
|---|---|
|
"false" |
The item labels are not repeated. |
|
"true" |
The item labels are repeated for each nested item. |
ignore: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether this PivotTable ([ISO/IEC29500-1:2016] section 18.10) field SHOULD<15> be ignored.
If this attribute is "true", the ancestor CT_PivotField ([ISO/IEC29500-4:2016] section A.2) MUST have only the following attributes specified, and these attributes MUST have the following values.
|
Name |
Value |
|---|---|
|
compact |
"false" |
|
dataField |
"true" |
|
defaultSubtotal |
"false" |
|
dragOff |
"false" |
|
dragToCol |
"false" |
|
dragToData |
"false" |
|
dragToPage |
"false" |
|
dragToRow |
"false" |
|
includeNewItemsInFilter |
"true" |
|
itemPageCount |
"false" |
|
outline |
"false" |
|
showAll |
"false" |
|
subtotalTop |
"false" |
|
topAutoShow |
"false" |
If this attribute is equal to "true", there MUST exist a CT_DataField ([ISO/IEC29500-4:2016] section A.2) element with an fld attribute that specifies this PivotTable ([ISO/IEC29500-1:2016] section 18.10) field. Additionally, that CT_DataField ([ISO/IEC29500-4:2016] section A.2) element MUST have a descendant CT_DataField element with a sourceField attribute specified.
For more details, see CT_DataField.
The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.
-
<xsd:complexType name="CT_PivotField"> <xsd:attribute name="fillDownLabels" type="xsd:boolean" use="optional" default="false"/> <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).