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



Yüklə 3,69 Mb.
səhifə13/180
tarix09.01.2022
ölçüsü3,69 Mb.
#95757
1   ...   9   10   11   12   13   14   15   16   ...   180
AlternateContent components

Child element

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

iconFilter

Fallback

customFilters

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



The filterColumn element ([ISO/IEC29500-1:2011] section 18.3.2.7) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] 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:2011] section 18.3.2.3)

or none


The filterColumn element ([ISO/IEC29500-1:2011] section 18.3.2.7) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] 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:2011] section 18.3.2.8) such that instead of any child filter ([ISO/IEC29500-1:2011] section 18.3.2.6) elements, there are filter elements



Fallback

customFilters

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



The filters element ([ISO/IEC29500-1:2011] section 18.3.2.8) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] 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:2011] section 18.3.2.6) or none



The sortState element ([ISO/IEC29500-1:2011] section 18.3.1.92) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] 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:2011] section 18.3.1.91)



2.2.4.10 Workbook

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



Ext URI

Child element

{876F7934-8845-4945-9796-88D515C7AA90}

pivotCaches

{BBE1A952-AA13-448E-AADC-164F8A28A991}

slicerCaches

{79F54976-1DA5-4618-B147-ACDE4B953A38}

workbookPr

{841E416B-1EF1-43b6-AB56-02D37102CBD5}

pivotCaches

{983426D0-5260-488c-9760-48F4B6AC55F4}

pivotTableReferences

{A2CB5862-8E78-49c6-8D9D-AF26E26ADB89}

timelineCachePivotCaches

{D0CA8CA8-9F24-4464-BF8E-62219DCF47F9}

timelineCacheRefs

{140A7094-0E35-4892-8432-C4D2E57EDEB5}

workbookPr

{FCE2AD5D-F65C-4FA6-A056-5C36A1767C68}

dataModel

 

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

2.2.4.11 Worksheet

The extLst child element ([ISO/IEC29500-1:2011] section 18.2.10) of the worksheet element ([ISO/IEC29500-1:2011] section 18.3.1.99) is extended by the addition of new child ext elements ([ISO/IEC29500-1:2011] 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

{3A4CF648-6AED-40f4-86FF-DC5316D8AED3}

slicerList

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

timelineRefs

 

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

The extLst child element ([ISO/IEC29500-1:2011] section 18.2.10) of the cfRule element ([ISO/IEC29500-1:2011] section 18.3.1.10) is extended by the addition of a new child ext element ([ISO/IEC29500-1:2011] 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:2011] section 10.1.2 for more information about how extension lists are used.

The sheetFormatPr element ([ISO/IEC29500-1:2011] 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:2011], the namespace prefix of the attribute MUST be specified as an Ignorable attribute ([ISO/IEC29500-3:2011] section 10.1.1).

The row element ([ISO/IEC29500-1:2011] 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:2011], the namespace prefix of the attribute MUST be specified as an Ignorable attribute ([ISO/IEC29500-3:2011] section 10.1.1).

The sortState element ([ISO/IEC29500-1:2011] section 18.3.1.92) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] 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:2011] section 18.3.1.91)



The filterColumn element ([ISO/IEC29500-1:2011] section 18.3.2.7) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] 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:2011] section 18.3.2.3)



The filterColumn element ([ISO/IEC29500-1:2011] section 18.3.2.7) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] 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:2011] section 18.3.2.3)

or none


The filterColumn element ([ISO/IEC29500-1:2011] section 18.3.2.7) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] 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:2011] section 18.3.2.8) such that instead of child filter ([ISO/IEC29500-1:2011] section 18.3.2.6) elements, there are filter elements



Fallback

customFilters

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



The filters element ([ISO/IEC29500-1:2011] section 18.3.2.8) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] 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:2011] section 18.3.2.6) or none



2.3 Conceptual Overview

This section specifies how higher-level features of the file format are represented by combinations of low-level structures.

2.3.1 PivotTable What-if Analysis


Yüklə 3,69 Mb.

Dostları ilə paylaş:
1   ...   9   10   11   12   13   14   15   16   ...   180




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©muhaz.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin