[MS-XLSX]: Excel (.xlsx) Extensions to the Office Open XML ...

[MS-XLSX]:

Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File Format

Intellectual Property Rights Notice for Open Specifications Documentation

Technical Documentation. Microsoft publishes Open Specifications documentation ("this documentation") for protocols, file formats, data portability, computer languages, and standards support. Additionally, overview documents cover inter-protocol relationships and interactions.

Copyrights. This documentation is covered by Microsoft copyrights. Regardless of any other terms that are contained in the terms of use for the Microsoft website that hosts this documentation, you can make copies of it in order to develop implementations of the technologies that are described in this documentation and can distribute portions of it in your implementations that use these technologies or in your documentation as necessary to properly document the implementation. You can also distribute in your implementation, with or without modification, any schemas, IDLs, or code samples that are included in the documentation. This permission also applies to any documents that are referenced in the Open Specifications documentation.

No Trade Secrets. Microsoft does not claim any trade secret rights in this documentation. Patents. Microsoft has patents that might cover your implementations of the technologies

described in the Open Specifications documentation. Neither this notice nor Microsoft's delivery of this documentation grants any licenses under those patents or any other Microsoft patents. However, a given Open Specifications document might be covered by the Microsoft Open Specifications Promise or the Microsoft Community Promise. If you would prefer a written license, or if the technologies described in this documentation are not covered by the Open Specifications Promise or Community Promise, as applicable, patent licenses are available by contacting iplg@. License Programs. To see all of the protocols in scope under a specific license program and the associated patents, visit the Patent Map. Trademarks. The names of companies and products contained in this documentation might be covered by trademarks or similar intellectual property rights. This notice does not grant any licenses under those rights. For a list of Microsoft trademarks, visit trademarks. Fictitious Names. The example companies, organizations, products, domain names, email addresses, logos, people, places, and events that are depicted in this documentation are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, place, or event is intended or should be inferred.

Reservation of Rights. All other rights are reserved, and this notice does not grant any rights other than as specifically described above, whether by implication, estoppel, or otherwise.

Tools. The Open Specifications documentation does not require the use of Microsoft programming tools or programming environments in order for you to develop an implementation. If you have access to Microsoft programming tools and environments, you are free to take advantage of them. Certain Open Specifications documents are intended for use in conjunction with publicly available standards specifications and network programming art and, as such, assume that the reader either is familiar with the aforementioned material or has immediate access to it.

Support. For questions and support, please contact dochelp@.

[MS-XLSX] - v20221115 Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File Format Copyright ? 2022 Microsoft Corporation Release: November 15, 2022

1 / 389

Revision Summary

Date 7/13/2009 8/28/2009 11/6/2009 2/19/2010 3/31/2010 4/30/2010 6/7/2010 6/29/2010

Revision History 0.1 0.2 0.3 1.0 1.01 1.02 1.03 1.04

7/23/2010 1.04

9/27/2010 1.04

11/15/2010 1.04

12/17/2010 1.04 3/18/2011 1.5 6/10/2011 1.5 1/20/2012 2.0 4/11/2012 2.0 7/16/2012 3.0 10/8/2012 4.0 2/11/2013 4.1 7/30/2013 4.1 11/18/2013 4.2 2/10/2014 4.2 4/30/2014 4.3 7/31/2014 5.0 10/30/2014 5.1 3/16/2015 6.0

Revision Class Major Editorial Editorial Major Editorial Editorial Editorial Editorial None

None

None

None Minor None Major None Major Major Minor None Minor None Minor Major Minor Major

Comments Initial Availability Revised and edited the technical content

Revised and edited the technical content Updated and revised the technical content Revised and edited the technical content

Revised and edited the technical content Revised and edited the technical content

Changed language and formatting in the technical content. No changes to the meaning, language, or formatting of the technical content. No changes to the meaning, language, or formatting of the technical content.

No changes to the meaning, language, or formatting of the technical content. No changes to the meaning, language, or formatting of the technical content. Clarified the meaning of the technical content.

No changes to the meaning, language, or formatting of the technical content. Significantly changed the technical content. No changes to the meaning, language, or formatting of the technical content.

Significantly changed the technical content. Significantly changed the technical content.

Clarified the meaning of the technical content. No changes to the meaning, language, or formatting of the technical content. Clarified the meaning of the technical content.

No changes to the meaning, language, or formatting of the technical content. Clarified the meaning of the technical content. Significantly changed the technical content.

Clarified the meaning of the technical content. Significantly changed the technical content.

[MS-XLSX] - v20221115 Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File Format Copyright ? 2022 Microsoft Corporation Release: November 15, 2022

2 / 389

Date 9/4/2015 9/29/2016

Revision History

7.0

7.1

11/14/2016 7.1

1/18/2017 8.0

6/20/2017 8.0

12/12/2017 9.0

4/27/2018 10.0

5/9/2018

11.0

6/8/2018

12.0

8/1/2018

13.0

8/28/2018 14.0

10/10/2018 15.0

12/11/2018 16.0

1/11/2019 17.0

3/19/2019 17.1

11/19/2019 18.0

2/19/2020 19.0

10/15/2020 20.0

4/22/2021 21.0

8/17/2021 22.0

11/16/2021 23.0

2/15/2022 23.0

5/17/2022 23.1 8/16/2022 23.2 11/15/2022 23.3

Revision Class Major Minor

None

Major

None

Major Major Major Major Major Major Major Major Major Minor Major Major Major Major Major Major

None

Minor Minor Minor

Comments Significantly changed the technical content. Clarified the meaning of the technical content. No changes to the meaning, language, or formatting of the technical content. Significantly changed the technical content. No changes to the meaning, language, or formatting of the technical content. Significantly changed the technical content. Significantly changed the technical content. Significantly changed the technical content. Significantly changed the technical content. Significantly changed the technical content. Significantly changed the technical content. Significantly changed the technical content. Significantly changed the technical content. Significantly changed the technical content. Clarified the meaning of the technical content. Significantly changed the technical content. Significantly changed the technical content. Significantly changed the technical content. Significantly changed the technical content. Significantly changed the technical content. Significantly changed the technical content. No changes to the meaning, language, or formatting of the technical content. Clarified the meaning of the technical content. Clarified the meaning of the technical content. Clarified the meaning of the technical content.

[MS-XLSX] - v20221115 Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File Format Copyright ? 2022 Microsoft Corporation Release: November 15, 2022

3 / 389

Table of Contents

1 Introduction .......................................................................................................... 14 1.1 Glossary ......................................................................................................... 14 1.2 References ...................................................................................................... 20 1.2.1 Normative References ................................................................................. 21 1.2.2 Informative References ............................................................................... 22 1.3 Structure Overview (Synopsis) .......................................................................... 22 1.4 Relationship to Protocols and Other Structures .................................................... 22 1.5 Applicability Statement ..................................................................................... 22 1.6 Versioning and Localization ............................................................................... 23 1.7 Vendor-Extensible Fields ................................................................................... 23

2 Structures ............................................................................................................. 24 2.1 Part Enumerations............................................................................................ 24 2.1.1 Control Properties ....................................................................................... 24 2.1.2 Custom Data .............................................................................................. 24 2.1.3 Custom Data Properties ............................................................................... 25 2.1.4 Slicer Cache ............................................................................................... 25 2.1.5 Slicers ....................................................................................................... 25 2.1.6 Data Model ................................................................................................ 26 2.1.6.1 Command Annotations........................................................................... 26 2.1.6.2 DimensionAttribute Annotations .............................................................. 27 2.1.7 Timeline Cache ........................................................................................... 27 2.1.8 Timelines................................................................................................... 28 2.1.9 Survey ...................................................................................................... 28 2.1.10 Rich Value Data .......................................................................................... 28 2.1.11 Rich Value Structure ................................................................................... 29 2.1.12 Rich Value Array ......................................................................................... 29 2.1.13 Rich Styles................................................................................................. 29 2.1.14 Supporting Property Bag Data ...................................................................... 30 2.1.15 Supporting Property Bag Structure ............................................................... 30 2.1.16 Rich Value Types ........................................................................................ 31 2.1.17 Threaded Comments ................................................................................... 31 2.1.18 Persons ..................................................................................................... 31 2.1.19 Named Sheet Views .................................................................................... 32 2.1.20 Web Image Supporting Rich Data ................................................................. 32 2.2 Extensions ...................................................................................................... 33 2.2.1 SpreadsheetML Extensibility Elements ........................................................... 33 2.2.2 Formulas ................................................................................................... 33 2.2.2.1 Cell Formulas ....................................................................................... 59 2.2.2.2 Conditional Formatting Formulas............................................................. 59 2.2.2.3 Data Validation Formulas ....................................................................... 59 2.2.2.4 External Name Formulas ........................................................................ 59 2.2.2.5 Name Formulas .................................................................................... 60 2.2.2.6 Pivot Field Formulas .............................................................................. 60 2.2.2.7 Pivot Item Formulas .............................................................................. 60 2.2.3 Functions................................................................................................... 61 2.2.4 Extensions by Part ...................................................................................... 65 2.2.4.1 Connections ......................................................................................... 65 2.2.4.2 Drawing ............................................................................................... 66 2.2.4.3 External Workbook References ............................................................... 66 2.2.4.4 Metadata ............................................................................................. 67 2.2.4.5 Pivot Table ........................................................................................... 67 2.2.4.6 Pivot Table Cache Definition ................................................................... 69 2.2.4.7 Query Table ......................................................................................... 70 2.2.4.8 SlicerCache .......................................................................................... 70

[MS-XLSX] - v20221115 Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File Format Copyright ? 2022 Microsoft Corporation Release: November 15, 2022

4 / 389

2.2.4.9 Styles .................................................................................................. 71 2.2.4.10 Table Definition .................................................................................... 71 2.2.4.11 Workbook ............................................................................................ 72 2.2.4.12 Worksheet ........................................................................................... 73 2.3 Conceptual Overview ........................................................................................ 75 2.3.1 PivotTable What-if Analysis .......................................................................... 75 2.3.2 Slicers ....................................................................................................... 76 2.3.2.1 Slicer Cache ......................................................................................... 76

2.3.2.1.1 Slicer Source Data ........................................................................... 76 2.3.2.1.2 Slicer Cache Relationship to PivotCache.............................................. 76 2.3.2.1.3 Slicer Cache Relationship to Table ..................................................... 77 2.3.2.1.4 Slicer Cache Relationship to PivotTable View ....................................... 77 2.3.2.1.5 Slicer Cache Relationship to Table column .......................................... 78 2.3.2.1.6 Slicer Items .................................................................................... 78

2.3.2.1.6.1 Non-OLAP Slicer Items ............................................................... 78 2.3.2.1.6.2 OLAP Slicer Items ...................................................................... 78 2.3.2.1.7 Slicer Cross Filtering ........................................................................ 79 2.3.2.2 Slicer View ........................................................................................... 79 2.3.2.2.1 Slicer View Relationship to Slicer Cache.............................................. 79 2.3.2.3 Slicers and Cube Functions..................................................................... 80 2.3.2.4 Slicer Styles ......................................................................................... 80 2.3.3 Non-Worksheet PivotTable ........................................................................... 80 2.3.4 PivotValues ................................................................................................ 81 2.3.4.1 PivotValueCell....................................................................................... 81 2.3.4.1.1 Value ............................................................................................. 81 2.3.4.1.2 Server Formatting ........................................................................... 81 2.3.5 Timelines................................................................................................... 81 2.3.5.1 Timeline Cache ..................................................................................... 81 2.3.5.1.1 Timeline Source Data ....................................................................... 82 2.3.5.1.2 Timeline Cache Relationship to PivotCache ......................................... 82 2.3.5.1.3 Timeline Cache Relationship to PivotTable View ................................... 82 2.3.5.1.4 Timeline State................................................................................. 82 2.3.5.2 Timeline View ....................................................................................... 82 2.3.5.2.1 Timeline View Relationship to Timeline Cache ..................................... 83 2.3.5.3 Timelines and Cube Functions................................................................. 83 2.3.5.4 Timeline Styles ..................................................................................... 83 2.3.6 Rich Data................................................................................................... 83 2.3.6.1 Rich Values .......................................................................................... 83 2.3.6.1.1 Array Type ..................................................................................... 84 2.3.6.1.2 Entity Type ..................................................................................... 84 2.3.6.1.3 Error Types..................................................................................... 84 2.3.6.1.3.1 Blocked Error Type..................................................................... 85 2.3.6.1.3.2 Busy Error Types ....................................................................... 85 2.3.6.1.3.3 Calc Error Type .......................................................................... 85 2.3.6.1.3.4 Connect Error Type .................................................................... 85 2.3.6.1.3.5 Name Error Type ....................................................................... 86 2.3.6.1.3.6 Field Error Type ......................................................................... 86 2.3.6.1.3.7 Spill Error Type.......................................................................... 86 2.3.6.1.3.8 Unknown Error Type................................................................... 86 2.3.6.1.4 Formatted Number Type................................................................... 87 2.3.6.1.5 Hyperlink Type ................................................................................ 87 2.3.6.1.6 ImageUrl Type ................................................................................ 87 2.3.6.1.7 Linked Entity Types ......................................................................... 88 2.3.6.1.7.1 Linked Entity and Linked Entity Core Types ................................... 88 2.3.6.1.7.2 Linked Entity 2 and Linked Entity 2 Core Types.............................. 89 2.3.6.1.8 SourceAttribution Type..................................................................... 90 2.3.6.1.9 Stock History Cache Type ................................................................. 91 2.3.6.1.10 Web Image Type ............................................................................. 91

[MS-XLSX] - v20221115 Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File Format Copyright ? 2022 Microsoft Corporation Release: November 15, 2022

5 / 389

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download