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
Dostları ilə paylaş: