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

1 Introduction

The Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File Format specifies extensions to the Office Open XML file formats described in [ISO/IEC29500-1:2011]. The extensions are specified using conventions provided by the Office Open XML file formats described in [ISO/IEC29500-3:2011]. The extensions are a collection of structures and parts in a container that specify appropriate content, which can include unstructured or semi-structured tables of numbers, text, or both numbers and text, equations or functions, external data connections, charts, and images. Content in such a container is typically organized in a grid-based layout, and often includes numeric data, structured data, and formulas.

Sections 1.7 and 2 of this specification are normative and can contain the terms MAY, SHOULD, MUST, MUST NOT, and SHOULD NOT as defined in RFC 2119. All other sections and examples in this specification are informative.

1.1 Glossary

The following terms are defined in [MS-GLOS]:

attribute
Augmented Backus-Naur Form (ABNF)
credential
GUID
salt
Unicode
unique identifier (UID)
XML
XML namespace

The following terms are defined in [MS-OFCGLOS]:

add-in
Boolean
calculate
cell
cell reference
cell value
character set
color scale
column
condition
conditional formatting
control
cube function
custom filter
custom list
data bar
data connection
data marker
data point
data provider
data source
data table
data validation
defined name
descendant
dimension
display folder
English Metric Unit (EMU)
field
filter
formula
hash
hidden
hierarchy
icon
icon set
Input Method Editor (IME)
left-to-right
locale
locked
MDX unique name
measure
multidimensional expression (MDX)
Object Linking and Embedding (OLE)
OLAP
OLAP All level
OLAP All member
OLAP allocation
OLAP hierarchy
OLAP level
OLAP measure
OLAP member
OLAP named set
OLAP subselect
OLAP tuple
OLAP weight expression
OLE DB
PivotTable
PivotTable field list
pixel
plot area
point
protection
query table
range
right-to-left
root element
row
security descriptor
selected
shape
sheet
sort
sort condition
sort order
source data
sparkline
spreadsheet data model
table
workbook
worksheet
XML schema definition (XSD)
XOR obfuscation
zoom level

The following terms are specific to this document:

future function: A function that can be written to but is not implemented in a file.

MAY, SHOULD, MUST, SHOULD NOT, MUST NOT: These terms (in all caps) are used as described in [RFC2119]. All statements of optional behavior use either MAY, SHOULD, or SHOULD NOT.

1.2 References

References to Microsoft Open Specifications documentation do not include a publishing year because links are to the latest version of the technical documents, which are updated frequently. References to other documents include a publishing year when one is available.

1.2.1 Normative References

We conduct frequent surveys of the normative references to assure their continued availability. If you have any issue with finding a normative reference, please contact [e-mail]. We will assist you in finding the relevant information. Please check the archive site, http://msdn2.microsoft.com/en-us/library/E4BD6494-06AD-4aed-9823-445E921C9624, as an additional source.

[CSS-Level2-2009] Bos, B., Celik, T., Hickson, I., and Wium Lie, H., Eds., "Cascading Style Sheets Level 2 Revision 1 (CSS 2.1) Specification", W3C Candidate Recommendation 08 September 2009, http://www.w3.org/TR/2009/CR-CSS2-20090908/

[ISO/IEC29500:2011] ISO/IEC, "Information technology -- Document description and processing languages -- Office Open XML File Formats -- Parts 1-4", ISO/IEC 29500-1:2011, 2011, http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=59575

[ISO/IEC29500-1:2011] ISO/IEC, "Information Technology -- Document description and processing languages -- Office Open XML File Formats -- Part 1: Fundamentals and Markup Language Reference", ISO/IEC 29500-1:2011, 2011, http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=59575

[ISO/IEC-29500-1] International Organization for Standardization, "Information technology -- Document description and processing languages -- Office Open XML File Formats -- Part 1: Fundamentals and Markup Language Reference", ISO/IEC 29500-1:2008, http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=51463

[ISO/IEC29500-3:2011] ISO/IEC, "Information technology -- Document description and processing languages -- Office Open XML File Formats -- Part 3: Markup Compatibility and Extensibility", ISO/IEC 29500-3:2011, 2011, http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=59577

[ISO/IEC29500-4:2011] ISO/IEC, "Information technology -- Document description and processing languages -- Office Open XML File Formats -- Part 4: Transitional Migration Features", ISO/IEC 29500-4:2011, 2011, http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=59577

[MS-ODRAWXML] Microsoft Corporation, "Office Drawing Extensions to Office Open XML Structure Specification".

[MS-OFFCRYPTO] Microsoft Corporation, "Office Document Cryptography Structure".

[MS-OWEXML] Microsoft Corporation, "Office Web Extensibility Extensions to Office Open XML Structure Specification".

[MS-WSO] Microsoft Corporation, "Windows System Overview".

[MS-XLDM] Microsoft Corporation, "Spreadsheet Data Model File Format".

[MS-XLSB] Microsoft Corporation, "Excel Binary File Format (.xlsb) Structure Specification".

[RFC2119] Bradner, S., "Key words for use in RFCs to Indicate Requirement Levels", BCP 14, RFC 2119, March 1997, http://www.rfc-editor.org/rfc/rfc2119.txt

[RFC3066] Alvestrand, H., "Tags for the Identification of Language", RFC 3066, January 2001, http://www.ietf.org/rfc/rfc3066.txt

[RFC5234] Crocker, D., Ed., and Overell, P., "Augmented BNF for Syntax Specifications: ABNF", STD 68, RFC 5234, January 2008, http://www.rfc-editor.org/rfc/rfc5234.txt

[UNICODE5.1] The Unicode Consortium, "The Unicode Standard, Version 5.1.0, defined by: The Unicode Standard, Version 5.0 (Boston, MA, Addison-Wesley, 2007. ISBN 0-321-48091-0), as amended by Unicode 5.1.0", http://www.unicode.org/versions/Unicode5.1.0/

[W3C-XML] Bray, T., Paoli, J., Sperberg-McQueen, C.M., Maler, E., Yergeau, F., Eds., "Extensible Markup Language (XML) 1.1 (Second Edition)", W3C Recommendation, August 2006, http://www.w3.org/TR/2006/REC-xml11-20060816/

[XMLNS] Bray, T., Hollander, D., Layman, A., et al., Eds., "Namespaces in XML 1.0 (Third Edition)", W3C Recommendation, December 2009, http://www.w3.org/TR/2009/REC-xml-names-20091208/

[XMLSCHEMA1] Thompson, H.S., Beech, D., Maloney, M., Eds., and Mendelsohn, N., Ed., "XML Schema Part 1: Structures", W3C Recommendation, May 2001, http://www.w3.org/TR/2001/REC-xmlschema-1-20010502/

[XMLSCHEMA2] Biron, P.V., and Malhotra, A., Eds., "XML Schema Part 2: Datatypes", W3C Recommendation, May 2001, http://www.w3.org/TR/2001/REC-xmlschema-2-20010502/

1.2.2 Informative References

[ISO/IEC29500-2:2011] ISO/IEC, "Information technology -- Document description and processing languages -- Office Open XML File Formats -- Part 2: Open Packaging Conventions", ISO/IEC 29500-2:2011, 2011, http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=59576

[MS-GLOS] Microsoft Corporation, "Windows Protocols Master Glossary".

[MS-OFCGLOS] Microsoft Corporation, "Microsoft Office Master Glossary".

1.3 Structure Overview (Synopsis)

This document specifies spreadsheet-related extensions to Office Open XML file formats as described in [ISO/IEC29500-1:2011]. Workbook data is contained in a ZIP package conforming to the Open Packaging Conventions as described in [ISO/IEC29500-2:2011]. Individual files stored in the ZIP package, called parts [ISO/IEC29500-1:2011], contain information about the content and structure of a workbook, including workbook data, such as worksheet definitions. Some parts [ISO/IEC29500-1:2011]) store information by using XML and other parts [ISO/IEC29500-1:2011] store information by using binary data. The extensions specified in this document use the conventions specified by [ISO/IEC29500-3:2011], and they are both structures within parts specified by [ISO/IEC29500-1:2011] and extension parts within the package described by [ISO/IEC29500-2:2011].

1.4 Relationship to Protocols and Other Structures

This file format is a specified set of extensions to Office Open XML SpreadsheetML, specified in [ISO/IEC29500-1:2011]. This specification is dependent on the structures and concepts defined in the following references:

 [ISO/IEC29500-1:2011] for baseline SpreadsheetML persistence format.

 [ISO/IEC29500-2:2011] for open packaging conventions.

 [ISO/IEC29500-3:2011] for markup compatibility and extensibility.

 [ISO/IEC29500-4:2011] for backward compatibility considerations.

 [MS-OFFCRYPTO] for the persistence format for document signing, information rights management, document encryption, and obfuscation.

 [MS-ODRAWXML] for the persistence format for shapes.

1.5 Applicability Statement

This document specifies a persistence format for extensions to Office Open XML file formats as described in [ISO/IEC29500-1:2011] SpreadsheetML documents. The extensions specified in this document allow for expressing additional content and properties, and are not applicable as a stand-alone file format. Each structure specified in this document is integrated with SpreadsheetML documents as described in [ISO/IEC29500-1:2011] in a particular way, as specified in the section for that structure. All structures are integrated into SpreadsheetML documents in such a way that maintains compatibility with implementations of the Office Open XML file formats as described in [ISO/IEC29500-1:2011].

The extensions specified in this document do not require any other extensions to be used, and do not prohibit any other extensions from being used in the same document.

This persistence format provides interoperability with applications that create or read documents conforming to this structure.

1.6 Versioning and Localization

This document covers versioning issues in the following areas:

 Structure Versions: There is only one version of Excel Extensions to the Office Open XML SpreadsheetML File Format.

 Localization: The CT_ProtectedRange structure contains fields (1) that specify locale-dependent meaning.

The Security Considerations section also specifies processes and data that are locale-dependent. See each structure and section description for more information.

1.7 Vendor-Extensible Fields

Specified in this document are extensions, using conventions described in [ISO/IEC29500-3:2011], both as structures within parts described in [ISO/IEC29500-1:2011] and as extension parts within the package described in [ISO/IEC29500-2:2011]. Implementations are not required to preserve or remove additional parts when modifying an existing document. See [ISO/IEC29500-3:2011] for more information.