WIXLIB

[MS-XLSX]:Excel (.xlsx) Extensions to the Office Open XMLSpreadsheetML File FormatIntellectual Property Rights Notice for Open Specifications Documentation Technical Documentation. Microsoft publishes Open Specifications documentation (“thisdocumentation”) for protocols, file formats, data portability, computer languages, and standardssupport. Additionally, overview documents cover inter-protocol relationships and interactions.Copyrights. This documentation is covered by Microsoft copyrights. Regardless of any otherterms that are contained in the terms of use for the Microsoft website that hosts thisdocumentation, you can make copies of it in order to develop implementations of the technologiesthat are described in this documentation and can distribute portions of it in your implementationsthat use these technologies or in your documentation as necessary to properly document theimplementation. You can also distribute in your implementation, with or without modification, anyschemas, IDLs, or code samples that are included in the documentation. This permission alsoapplies 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 technologiesdescribed in the Open Specifications documentation. Neither this notice nor Microsoft's delivery ofthis documentation grants any licenses under those patents or any other Microsoft patents.However, a given Open Specifications document might be covered by the Microsoft OpenSpecifications 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 SpecificationsPromise or Community Promise, as applicable, patent licenses are available by contactingiplg@microsoft.com.License Programs. To see all of the protocols in scope under a specific license program and theassociated patents, visit the Patent Map.Trademarks. The names of companies and products contained in this documentation might becovered by trademarks or similar intellectual property rights. This notice does not grant anylicenses under those rights. For a list of Microsoft trademarks, visitwww.microsoft.com/trademarks.Fictitious Names. The example companies, organizations, products, domain names, emailaddresses, 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 otherthan as specifically described above, whether by implication, estoppel, or otherwise.Tools. The Open Specifications documentation does not require the use of Microsoft programmingtools or programming environments in order for you to develop an implementation. If you have accessto Microsoft programming tools and environments, you are free to take advantage of them. CertainOpen Specifications documents are intended for use in conjunction with publicly available standardsspecifications and network programming art and, as such, assume that the reader either is familiarwith the aforementioned material or has immediate access to it.Support. For questions and support, please contact dochelp@microsoft.com.1 / 385[MS-XLSX] - v20220517Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File FormatCopyright 2022 Microsoft CorporationRelease: May 17, 2022

Revision 3/20090.1MajorInitial Availability8/28/20090.2EditorialRevised and edited the technical content11/6/20090.3EditorialRevised and edited the technical content2/19/20101.0MajorUpdated and revised the technical content3/31/20101.01EditorialRevised and edited the technical content4/30/20101.02EditorialRevised and edited the technical content6/7/20101.03EditorialRevised and edited the technical content6/29/20101.04EditorialChanged language and formatting in the technical content.7/23/20101.04NoneNo changes to the meaning, language, or formatting of thetechnical content.9/27/20101.04NoneNo changes to the meaning, language, or formatting of thetechnical content.11/15/20101.04NoneNo changes to the meaning, language, or formatting of thetechnical content.12/17/20101.04NoneNo changes to the meaning, language, or formatting of thetechnical content.3/18/20111.5MinorClarified the meaning of the technical content.6/10/20111.5NoneNo changes to the meaning, language, or formatting of thetechnical content.1/20/20122.0MajorSignificantly changed the technical content.4/11/20122.0NoneNo changes to the meaning, language, or formatting of thetechnical content.7/16/20123.0MajorSignificantly changed the technical content.10/8/20124.0MajorSignificantly changed the technical content.2/11/20134.1MinorClarified the meaning of the technical content.7/30/20134.1NoneNo changes to the meaning, language, or formatting of thetechnical content.11/18/20134.2MinorClarified the meaning of the technical content.2/10/20144.2NoneNo changes to the meaning, language, or formatting of thetechnical content.4/30/20144.3MinorClarified the meaning of the technical content.7/31/20145.0MajorSignificantly changed the technical content.10/30/20145.1MinorClarified the meaning of the technical content.3/16/20156.0MajorSignificantly changed the technical content.2 / 385[MS-XLSX] - v20220517Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File FormatCopyright 2022 Microsoft CorporationRelease: May 17, 2022

0MajorSignificantly changed the technical content.9/29/20167.1MinorClarified the meaning of the technical content.11/14/20167.1NoneNo changes to the meaning, language, or formatting of thetechnical content.1/18/20178.0MajorSignificantly changed the technical content.6/20/20178.0NoneNo changes to the meaning, language, or formatting of thetechnical content.12/12/20179.0MajorSignificantly changed the technical content.4/27/201810.0MajorSignificantly changed the technical content.5/9/201811.0MajorSignificantly changed the technical content.6/8/201812.0MajorSignificantly changed the technical content.8/1/201813.0MajorSignificantly changed the technical content.8/28/201814.0MajorSignificantly changed the technical content.10/10/201815.0MajorSignificantly changed the technical content.12/11/201816.0MajorSignificantly changed the technical content.1/11/201917.0MajorSignificantly changed the technical content.3/19/201917.1MinorClarified the meaning of the technical content.11/19/201918.0MajorSignificantly changed the technical content.2/19/202019.0MajorSignificantly changed the technical content.10/15/202020.0MajorSignificantly changed the technical content.4/22/202121.0MajorSignificantly changed the technical content.8/17/202122.0MajorSignificantly changed the technical content.11/16/202123.0MajorSignificantly changed the technical content.2/15/202223.0NoneNo changes to the meaning, language, or formatting of thetechnical content.5/17/202223.1MinorClarified the meaning of the technical content.3 / 385[MS-XLSX] - v20220517Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File FormatCopyright 2022 Microsoft CorporationRelease: May 17, 2022

Table of Contents1Introduction . 141.1Glossary . 141.2References . 201.2.1Normative References . 211.2.2Informative References . 221.3Structure Overview (Synopsis) . 221.4Relationship to Protocols and Other Structures . 221.5Applicability Statement . 221.6Versioning and Localization . 231.7Vendor-Extensible Fields . 232Structures . 242.1Part Enumerations. 242.1.1Control Properties . 242.1.2Custom Data . 242.1.3Custom Data Properties . 252.1.4Slicer Cache . 252.1.5Slicers . 252.1.6Data Model . 262.1.6.1Command Annotations. 262.1.6.2DimensionAttribute Annotations . 272.1.7Timeline Cache . 272.1.8Timelines . 282.1.9Survey . 282.1.10Rich Value Data . 282.1.11Rich Value Structure . 292.1.12Rich Value Array . 292.1.13Rich Styles. 292.1.14Supporting Property Bag Data . 302.1.15Supporting Property Bag Structure . 302.1.16Rich Value Types . 312.1.17Threaded Comments . 312.1.18Persons . 312.1.19Named Sheet Views . 322.1.20Web Image Supporting Rich Data . 322.2Extensions . 332.2.1SpreadsheetML Extensibility Elements . 332.2.2Formulas . 332.2.2.1Cell Formulas . 592.2.2.2Conditional Formatting Formulas . 592.2.2.3Data Validation Formulas . 592.2.2.4External Name Formulas . 592.2.2.5Name Formulas . 602.2.2.6Pivot Field Formulas . 602.2.2.7Pivot Item Formulas . 602.2.3Functions . 612.2.4Extensions by Part . 652.2.4.1Connections . 652.2.4.2Drawing . 662.2.4.3External Workbook References . 662.2.4.4Metadata . 672.2.4.5Pivot Table . 672.2.4.6Pivot Table Cache Definition . 692.2.4.7Query Table . 702.2.4.8SlicerCache . 704 / 385[MS-XLSX] - v20220517Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File FormatCopyright 2022 Microsoft CorporationRelease: May 17, 2022

2.2.4.9Styles . 712.2.4.10Table Definition . 712.2.4.11Workbook . 722.2.4.12Worksheet . 732.3Conceptual Overview . 752.3.1PivotTable What-if Analysis . 752.3.2Slicers . 762.3.2.1Slicer Cache . 762.3.2.1.1Slicer Source Data . 762.3.2.1.2Slicer Cache Relationship to PivotCache. 762.3.2.1.3Slicer Cache Relationship to Table . 772.3.2.1.4Slicer Cache Relationship to PivotTable View . 772.3.2.1.5Slicer Cache Relationship to Table column . 782.3.2.1.6Slicer Items . 782.3.2.1.6.1Non-OLAP Slicer Items . 782.3.2.1.6.2OLAP Slicer Items . 782.3.2.1.7Slicer Cross Filtering . 792.3.2.2Slicer View . 792.3.2.2.1Slicer View Relationship to Slicer Cache . 792.3.2.3Slicers and Cube Functions . 802.3.2.4Slicer Styles . 802.3.3Non-Worksheet PivotTable . 802.3.4PivotValues . 812.3.4.1PivotValueCell. 812.3.4.1.1Value . 812.3.4.1.2Server Formatting . 812.3.5Timelines . 812.3.5.1Timeline Cache . 812.3.5.1.1Timeline Source Data . 822.3.5.1.2Timeline Cache Relationship to PivotCache . 822.3.5.1.3Timeline Cache Relationship to PivotTable View . 822.3.5.1.4Timeline State. 822.3.5.2Timeline View . 822.3.5.2.1Timeline View Relationship to Timeline Cache . 832.3.5.3Timelines and Cube Functions . 832.3.5.4Timeline Styles . 832.3.6Rich Data. 832.3.6.1Rich Values . 832.3.6.1.1Array Type . 842.3.6.1.2Entity Type . 842.3.6.1.3Error Types . 842.3.6.1.3.1Blocked Error Type . 852.3.6.1.3.2Busy Error Types . 852.3.6.1.3.3Calc Error Type . 852.3.6.1.3.4Connect Error Type . 852.3.6.1.3.5Name Error Type . 862.3.6.1.3.6Field Error Type . 862.3.6.1.3.7Spill Error Type. 862.3.6.1.3.8Unknown Error Type . 862.3.6.1.4Formatted Number Type. 872.3.6.1.5Hyperlink Type . 872.3.6.1.6ImageUrl Type . 872.3.6.1.7Linked Entity Types . 882.3.6.1.7.1Linked Entity and Linked Entity Core Types . 882.3.6.1.7.2Linked Entity 2 and Linked Entity 2 Core Types . 892.3.6.1.8SourceAttribution Type. 902.3.6.1.9Stock History Cache Type . 912.3.6.1.10Web Image Type . 915 / 385[MS-XLSX] - v20220517Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File FormatCopyright 2022 Microsoft CorporationRelease: May 17, 2022