2.2.4.12 Worksheet

  • Article

The extLst child element ([ISO/IEC29500-1:2016] section 18.2.10) of the worksheet element ([ISO/IEC29500-1:2016] section 18.3.1.99) 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

{78C0D931-6437-407D-A8EE-F0AAD7539E65}

conditionalFormattings

{CCE6A557-97BC-4B89-ADB6-D9C93CAAB3DF}

dataValidations

{05C60535-1F16-4FD2-B633-F4F36F0B64E0}

sparklineGroups

{A8765BA9-456A-4DAB-B4F3-ACF838C121DE}

slicerList

{FC87AEE6-9EDD-4A0A-B7FB-166176984837}

protectedRanges

{01252117-D84E-4E92-8308-4BE1C098FCBB}

ignoredErrors

{F7C9EE02-42E1-4005-9D12-6889AFFD525C}

webExtensions

{7E03D99C-DC04-49d9-9315-930204A7B6E9}

timelineRefs

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 cfRule element ([ISO/IEC29500-1:2016] section 18.3.1.10) 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

{B025F937-C7B1-47D3-B67F-A62EFF666E3E}

id

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

The sheetFormatPr element ([ISO/IEC29500-1:2016] section 18.3.1.81) is extended by the addition of a dyDescent attribute. To maintain compatibility with Office Open XML file formats implementations as specified in [ISO/IEC29500-1:2016], the namespace prefix of the attribute MUST be specified as an Ignorable attribute ([ISO/IEC29500-3:2015] section 10.1.1).

The row element ([ISO/IEC29500-1:2016] section 18.3.1.73) is extended by the addition of a dyDescent attribute. To maintain compatibility with Office Open XML file formats implementations as specified in [ISO/IEC29500-1:2016], the namespace prefix of the attribute MUST be specified as an Ignorable attribute ([ISO/IEC29500-3:2015] section 10.1.1).

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 sortState element ([ISO/IEC29500-1:2016] section 18.3.1.92) 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

{0FC57C36-975A-43D2-8416-536B9B585D1B}

richSortCondition

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 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

filters

([ISO/IEC29500-1:2016] section 18.3.2.8) such that instead of child filter ([ISO/IEC29500-1:2016] section 18.3.2.6) elements, there are filter elements

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 new child ext element ([ISO/IEC29500-1:2016] section 18.2.7) whose structure is specified in the following table.

Ext URI

Child element

{68452572-C921-441B-96FD-77FB3E787301}

filterColumn

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