Share via

2.2.4.5 Pivot Table

  • Article

The extLst child element ([ISO/IEC29500-1:2016] section 18.2.10) of the pivotTableDefinition element ([ISO/IEC29500-1:2016] section 18.10.1.73) is extended by the addition of new child ext elements ([ISO/IEC29500-1:2016] section 18.2.7) whose structure is specified in the following table.

Ext URI

Child element

{962EF5D1-5CA2-4C93-8EF4-DBF5C05439D2}

pivotTableDefinition

{44433962-1CF7-4059-B4EE-95C3D5FFCF73}

pivotTableData

{C510F80B-63DE-4267-81D5-13C33094786E}

pivotTableServerFormats

{E67621CE-5B39-4880-91FE-76760E9C1902}

pivotTableUISettings

{747A6164-185A-40DC-8AA5-F01512510D54}

pivotTableDefinition16

See [ISO/IEC29500-3:2015] section 10.1.2 for more information about how extension lists are used.

The extLst child element ([ISO/IEC29500-1:2016] section 18.2.10) of the pivotField element ([ISO/IEC29500-1:2016] section 18.10.1.69) is extended by the addition of a new child ext element ([ISO/IEC29500-1:2016] section 18.2.7) whose structure is specified in the following table.

Ext URI

Child element

{2946ED86-A175-432A-8AC1-64E0C546D7DE}

pivotField

See [ISO/IEC29500-3:2015] section 10.1.2 for more information about how extension lists are used.

The extLst child element ([ISO/IEC29500-1:2016] section 18.2.10) of the dataField element ([ISO/IEC29500-1:2016] section 18.10.1.22) is extended by the addition of a new child ext element ([ISO/IEC29500-1:2016] section 18.2.7) whose structure is specified in the following table.

Ext URI

Child element

{E15A36E0-9728-4E99-A89B-3F7291B0FE68}

dataField

See [ISO/IEC29500-3:2015] section 10.1.2 for more information about how extension lists are used.

The extLst child element ([ISO/IEC29500-1:2016] section 18.2.10) of the pivotHierarchy element ([ISO/IEC29500-1:2016] section 18.10.1.72) is extended by the addition of a new child ext element ([ISO/IEC29500-1:2016] section 18.2.7) whose structure is specified in the following table.

Ext URI

Child element

{F1805F06-0CD304483-9156-8803C3D141DF}

pivotHierarchy

See [ISO/IEC29500-3:2015] section 10.1.2 for more information about how extension lists are used.

The filterColumn element ([ISO/IEC29500-1:2016] section 18.3.2.7) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2015] section 10.2.1) whose structure is specified in the following table.

AlternateContent components

Child element

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

iconFilter

Fallback

customFilters

([ISO/IEC29500-1:2016] section 18.3.2.3)

The filterColumn element ([ISO/IEC29500-1:2016] section 18.3.2.7) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2015] section 10.2.1) whose structure is specified in the following table.

AlternateContent components

Child element

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

customFilters

Fallback

Either customFilters

([ISO/IEC29500-1:2016] section 18.3.2.3)

or none

The extLst child element ([ISO/IEC29500-1:2016] section 18.2.10) of the filterColumn element ([ISO/IEC29500-1:2016] section 18.3.2.7) is extended by the addition of a new child ext element ([ISO/IEC29500-1:2016] section 18.2.7) whose structure is specified in the following table.

AlternateContent components

Child element

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

filter

Fallback

customFilters

([ISO/IEC29500-1:2016] section 18.3.2.3)

The filters element ([ISO/IEC29500-1:2016] section 18.3.2.8) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2015] section 10.2.1) whose structure is specified in the following table.

AlternateContent components

Child element

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

filter

Fallback

Either filter

([ISO/IEC29500-1:2016] section 18.3.2.6) or none

The sortState element ([ISO/IEC29500-1:2016] section 18.3.1.92) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2015] section 10.2.1) whose structure is specified in the following table.

AlternateContent components

Child element

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

sortCondition

Fallback

sortCondition

([ISO/IEC29500-1:2016] section 18.3.1.91)

The extLst child element ([ISO/IEC29500-1:2016] section 18.2.10) of the filter element ([ISO/IEC29500-1:2016] section 18.10.1.33) is extended by the addition of a new child ext element ([ISO/IEC29500-1:2016] section 18.2.7) whose structure is specified in the following table.

Ext URI

Child element

{0605FD5F-26C8-4aeb-8148-2DB25E43C511}

pivotFilter