[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

showValue: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the cells in the conditional formatting range display both the data bar and the numeric value or only the data bar. The following table describes its possible values.

Value	Meaning
"false"	Only the data bar is displayed in the cell.
"true"	Both the data bar and the numeric value are displayed in the cell.

border: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the data bar has a border.

Value	Meaning
"true"	The data bar has a border.
"false"	The data bar has no border.

gradient: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the data bar has a gradient fill. The following table describes its possible values.

Value	Meaning
"false"	The data bar fill is a solid color.
"true"	The data bar fill is a gradient.

direction: An ST_DataBarDirection attribute section 2.7.7) that specifies the direction of the data bar.

negativeBarColorSameAsPositive: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the data bar has a negative bar color that is different from the positive bar color.

negativeBarBorderColorSameAsPositive: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the data bar has a negative border color that is different from the positive border color.

axisPosition: An ST_DataBarAxisPosition attribute (section 2.7.8) that specifies the axis position for the data bar.

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

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

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:2011] section 18.10) field (1).

Attributes:

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

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

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

2.6.32 CT_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:2011] 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:2011] section 18.10) view.

Attributes:

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

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

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

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

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

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

altText: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the alternate text for the PivotTable ([ISO/IEC29500-1:2011] 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:2011] section 22.9.2.19) attribute that specifies the alternate text summary for the PivotTable ([ISO/IEC29500-1:2011] 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:2011] section 18.10) view.