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

1492.1.1CT_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:2012] section 18.10) field.

Attributes:

fillDownLabels: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the PivotTable ([ISO/IEC29500-1:2012] section 18.10) item labels are repeated for this PivotTable ([ISO/IEC29500-1:2012] section 18.10) field. This attribute is ignored when the compact attribute and the outline attribute of the PivotTable ([ISO/IEC29500-1:2012] section 18.10) field are "true". This attribute is ignored if the PivotTable ([ISO/IEC29500-1:2012] section 18.10) field is not on the PivotTable ([ISO/IEC29500-1:2012] section 18.10) row axis or the PivotTable ([ISO/IEC29500-1:2012] 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] section 3.2.2) attribute that specifies whether this PivotTable ([ISO/IEC29500-1:2012] section 18.10) field SHOULD<13> be ignored.

If this attribute is "true", the ancestor CT_PivotField ([ISO/IEC29500-4:2012] 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:2012] section A.2) element with an fld attribute that specifies this PivotTable ([ISO/IEC29500-1:2012] section 18.10) field. Additionally, that CT_DataField ([ISO/IEC29500-4:2012] 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] section 2.1) fragment specifies the contents of this complex type.

1493

1494

1495

1496

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

1496.1.1CT_PivotTableDefinition

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

Referenced by: pivotTableDefinition

This element specifies additional properties of a PivotTable ([ISO/IEC29500-1:2012] section 18.10) view.

Child Elements:

pivotEdits: A CT_PivotEdits element that specifies a collection of PivotTable What-if Analysis edits.

pivotChanges: A CT_PivotChanges element that specifies a collection of PivotTable What-if Analysis changes.

conditionalFormats: A CT_ConditionalFormats element that specifies a collection of conditional formats applied to the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view.

Attributes:

fillDownLabelsDefault: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies the behavior of PivotTable ([ISO/IEC29500-1:2012] section 18.10) fields that are not a part of the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view if they are later added to a PivotTable ([ISO/IEC29500-1:2012] section 18.10) view. MUST be a value from the following table.

Value	Meaning
"false"	Specifies that PivotTable ([ISO/IEC29500-1:2012] section 18.10) fields added to the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view behave as if the fillDownLabels attribute of the CT_PivotField elements associated with those PivotTable ([ISO/IEC29500-1:2012] section 18.10) fields are set to "false".
"true"	Specifies that PivotTable ([ISO/IEC29500-1:2012] section 18.10) fields added to the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view behave as if the fillDownLabels attribute of the CT_PivotField elements associated with those PivotTable ([ISO/IEC29500-1:2012] section 18.10) fields are set to "true".

visualTotalsForSets: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether hidden PivotTable ([ISO/IEC29500-1:2012] section 18.10) items will be included when calculating totals for PivotTable ([ISO/IEC29500-1:2012] section 18.10) named sets. MUST be a value from the following table.

Value	Meaning
"false"	Include hidden PivotTable ([ISO/IEC29500-1:2012] section 18.10) items in the set totals.
"true"	Do not include hidden PivotTable ([ISO/IEC29500-1:2012] section 18.10) items in the set totals.

calculatedMembersInFilters: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether PivotTable ([ISO/IEC29500-1:2012] section 18.10) OLAP-calculated members participate in PivotTable ([ISO/IEC29500-1:2012] section 18.10) manual filters and PivotTable ([ISO/IEC29500-1:2012] section 18.10) advanced filters.

Value	Meaning
"false"	PivotTable ([ISO/IEC29500-1:2012] section 18.10) OLAP-calculated members do not participate in PivotTable ([ISO/IEC29500-1:2012] section 18.10) manual filters and PivotTable ([ISO/IEC29500-1:2012] section 18.10) advanced filters.
"true"	PivotTable ([ISO/IEC29500-1:2012] section 18.10) OLAP-calculated members participate in PivotTable ([ISO/IEC29500-1:2012] section 18.10) manual filters and PivotTable ([ISO/IEC29500-1:2012] section 18.10) advanced filters as do other PivotTable ([ISO/IEC29500-1:2012] section 18.10) items.

altText: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the alternate text for the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view. The string MUST be less than or equal to 2,000 characters in length.

altTextSummary: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the alternate text summary for the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view. This string MUST be less than or equal to 2,000 characters in length.

enableEdit: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether PivotTable what-if analysis is enabled for the current PivotTable ([ISO/IEC29500-1:2012] section 18.10) view.

autoApply: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether PivotTable what-if analysis values are automatically allocated.

allocationMethod: An ST_AllocationMethod attribute that specifies the allocation method to use for PivotTable what-if analysis.

weightExpression: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the Multidimensional Expressions (MDX) of the weight expression for weighted allocations of PivotTable what-if analysis values. This string MUST be less than or equal to 65,535 characters in length.

hideValuesRow: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the values row in the PivotTable ([ISO/IEC29500-1:2012] section 18.10) report is visible.

Value	Meaning
"false"	The values row in the PivotTable ([ISO/IEC29500-1:2012] section 18.10) report is visible.
"true"	The values row in the PivotTable ([ISO/IEC29500-1:2012] section 18.10) report is not visible.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

1497

1498

1499

1500

1501

1502

1503

1504

1505

1506

1507

1508

1509

1510

1511

1512

1513

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