ISO/IEC 29500-1:2011

INTERNATIONAL ISO/IEC
STANDARD 29500-1
Second edition
2011-08-15
Information technology — Document
description and processing languages —
Office Open XML File Formats —
Part 1:
Fundamentals and Markup Language
Reference
Technologies de l'information — Description des documents et
langages de traitement — Formats de fichier "Office Open XML" —
Partie 1: Principes essentiels et référence de langage de balisage

Reference number
©
ISO/IEC 2011
©  ISO/IEC 2011
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any form or by any means,
electronic or mechanical, including photocopying and microfilm, without permission in writing from either ISO at the address below or
ISO's member body in the country of the requester.
ISO copyright office
Case postale 56  CH-1211 Geneva 20
Tel. + 41 22 749 01 11
Fax + 41 22 749 09 47
E-mail copyright@iso.org
Web www.iso.org
Published in Switzerland
ii © ISO/IEC 2011 – All rights reserved

Table of Contents
Foreword . viii
Introduction . ix
1. Scope .1
2. Conformance .2
2.1 Goal .2
2.2 Issues .2
2.3 What ISO/IEC 29500 Specifies .3
2.4 Document Conformance .3
2.5 Application Conformance .4
2.6 Application Descriptions .5
2.7 Interoperability Guidelines .6
3. Normative References .8
4. Terms and Definitions . 12
5. Notational Conventions . 15
6. Acronyms and Abbreviations . 16
7. General Description. 17
8. Overview . 18
8.1 Packages and Parts . 18
8.2 Consumers and Producers . 18
8.3 WordprocessingML . 18
8.4 SpreadsheetML . 19
8.5 PresentationML. 20
8.6 Supporting MLs . 21
9. Packages . 23
9.1 Office Open XML's Use of OPC. 23
9.2 Relationships in Office Open XML . 24
10. Markup Compatibility and Extensibility . 29
10.1 Constraints on Office Open XML's Use of Markup Compatibility and Extensibility . 29
11. WordprocessingML . 30
11.1 Glossary of WordprocessingML-Specific Terms . 30
11.2 Package Structure . 30
11.3 Part Summary . 32
11.4 Document Template . 59
11.5 Framesets . 59
11.6 Master Documents and Subdocuments . 60
11.7 Mail Merge Data Source . 62
11.8 Mail Merge Header Data Source . 62
11.9 XSL Transformation . 63
©ISO/IEC 2011 – All rights reserved iii

12. SpreadsheetML . 65
12.1 Glossary of SpreadsheetML-Specific Terms . 65
12.2 Package Structure . 66
12.3 Part Summary . 68
12.4 External Workbooks . 102
13. PresentationML . 104
13.1 Glossary of PresentationML-Specific Terms . 104
13.2 Package Structure . 104
13.3 Part Summary . 107
13.4 HTML Publish Location . 125
13.5 Slide Synchronization Server Location . 126
14. DrawingML . 128
14.1 Glossary of DrawingML-Specific Terms . 128
14.2 Part Summary . 128
15. Shared . 141
15.1 Glossary of Shared Terms . 141
15.2 Part Summary . 142
15.3 Hyperlinks . 165
16. Part Overview . 167
16.1 WordprocessingML Summary . 167
16.2 SpreadsheetML Summary . 167
16.3 PresentationML Summary . 168
16.4 DrawingML Summary . 169
16.5 Shared Summary . 169
17. WordprocessingML Reference Material . 171
17.1 Table of Contents . 171
17.2 Main Document Story. 191
17.3 Paragraphs and Rich Formatting . 199
17.4 Tables . 398
17.5 Custom Markup . 528
17.6 Sections. 608
17.7 Styles . 677
17.8 Fonts . 748
17.9 Numbering . 771
17.10 Headers and Footers . 820
17.11 Footnotes and Endnotes . 835
17.12 Glossary Document . 875
17.13 Annotations . 896
17.14 Mail Merge . 1043
17.15 Settings . 1089
17.16 Fields and Hyperlinks . 1298
17.17 Miscellaneous Topics . 1442
17.18 Simple Types . 1453
18. SpreadsheetML Reference Material . 1685
iv ©ISO/IEC 2011 – All rights reserved

18.1 Table of Contents . 1685
18.2 Workbook . 1704
18.3 Worksheets . 1757
18.4 Shared String Table . 1902
18.5 Tables . 1914
18.6 Calculation Chain . 1932
18.7 Comments . 1935
18.8 Styles . 1943
18.9 Metadata . 2001
18.10 Pivot Tables. 2018
18.11 Shared Workbook Data . 2183
18.12 QueryTable Data . 2217
18.13 External Data Connections . 2225
18.14 Supplementary Workbook Data . 2249
18.15 Volatile Dependencies . 2263
18.16 Custom XML Mappings . 2269
18.17 Formulas . 2277
18.18 Simple Types . 2671
19. PresentationML Reference Material . 2761
19.1 Table of Contents . 2761
19.2 Presentation . 2767
19.3 Slides . 2814
19.4 Comments . 2870
19.5 Animation . 2875
19.6 Slide Synchronization Data . 2981
19.7 Simple Types . 2982
20. DrawingML - Framework Reference Material . 3015
20.1 DrawingML - Main . 3015
20.2 DrawingML - Picture . 3457
20.3 DrawingML - Locked Canvas . 3466
20.4 DrawingML - WordprocessingML Drawing . 3467
20.5 DrawingML - SpreadsheetML Drawing . 3516
21. DrawingML - Components Reference Material . 3554
21.1 DrawingML - Main . 3554
21.2 DrawingML - Charts . 3760
21.3 DrawingML - Chart Drawings . 3923
21.4 DrawingML - Diagrams . 3951
22. Shared MLs Reference Material . 4084
22.1 Math . 4084
22.2 Extended Properties . 4244
22.3 Custom Properties . 4254
22.4 Variant Types . 4257
22.5 Custom XML Data Properties . 4274
22.6 Bibliography . 4277
22.7 Additional Characteristics . 4325
©ISO/IEC 2011 – All rights reserved v

22.8 Office Document Relationships . 4329
22.9 Shared Simple Types . 4331
23. Custom XML Schema References . 4354
23.1 Table of Contents . 4354
23.2 Elements . 4354
Annex A. (normative) Schemas – W3C XML Schema . 4359
A.1 WordprocessingML . 4359
A.2 SpreadsheetML . 4425
A.3 PresentationML. 4509
A.4 DrawingML - Framework . 4540
A.5 DrawingML - Components . 4605
A.6 Shared MLs. 4657
A.7 Custom XML Schema References . 4681
Annex B. (informative) Schemas – RELAX NG . 4683
B.1 WordprocessingML . 4683
B.2 SpreadsheetML . 4729
B.3 PresentationML. 4824
B.4 DrawingML - Framework . 4850
B.5 DrawingML - Components . 4899
B.6 Shared MLs. 4935
B.7 Custom XML Schema References . 4952
B.8 Additional Resources . 4952
Annex C. (informative) Additional Syntax Constraints . 4955
Annex D. (informative) Namespace Prefix Mapping in Examples . 4956
Annex E. (informative) WordprocessingML Custom XML Data Extraction . 4958
Annex F. (normative) WordprocessingML Page Borders . 4961
Annex G. (normative) Predefined SpreadsheetML Style Definitions . 4962
G.1 Built-in Table Styles . 4962
G.2 Built-in Cell Styles. 5018
G.3 Built-in PivotTable AutoFormats . 5022
Annex H. (informative) Example Predefined DrawingML Shape and Text Geometries . 5038
Annex I. (informative) Bidirectional Support . 5039
I.1 Introduction . 5039
I.2 Shared (WordprocessingML and DrawingML) . 5039
I.3 WordprocessingML . 5041
I.4 SpreadsheetML . 5044
I.5 PresentationML. 5045
I.6 DrawingML . 5045
I.7 The Unicode Bidirectional Algorithm and Office Open XML . 5045
Annex J. (informative) Accessibility Best Practices . 5049
J.1 The Value of Creating an Accessible Office Open XML Implementation . 5049
vi ©ISO/IEC 2011 – All rights reserved

J.2 Needs by Type of Disability . 5050
J.3 Best Practices for Developers . 5053
J.4 Best Practices for Document and Template Authors . 5056
J.5 Best Practices for Customers of Office Open XML Implementations . 5069
Annex K. (informative) Root Element Locations . 5082
K.1 Grouped by Part Name . 5082
K.2 Grouped by Schema Name . 5084
Annex L. (informative) Primer . 5088
L.1 Introduction to WordprocessingML . 5088
L.2 Introduction to SpreadsheetML. 5180
L.3 Introduction to PresentationML . 5319
L.4 Introduction to DrawingML . 5351
L.5 Introduction to VML. 5510
L.6 Introduction to Shared MLs . 5524
L.7 Miscellaneous Topics . 5555
Annex M. (informative) Differences Between ISO/IEC 29500 and ECMA-376:2006 . 5570
M.1 WordprocessingML . 5570
M.2 SpreadsheetML . 5573
M.3 PresentationML. 5574
M.4 DrawingML . 5575
M.5 VML . 5576
M.6 Shared . 5576
M.7 Custom XML Schema References . 5577

©ISO/IEC 2011 – All rights reserved vii

Foreword
ISO (the International Organization for Standardization) and IEC (the International Electrotechnical Commission)
form the specialized system for worldwide standardization. National bodies that are members of ISO or IEC
participate in the development of International Standards through technical committees established by the
respective organization to deal with particular fields of technical activity. ISO and IEC technical committees
collaborate in fields of mutual interest. Other international organizations, governmental and non-governmental,
in liaison with ISO and IEC, also take part in the work. In the field of information technology, ISO and IEC have
established a joint technical committee, ISO/IEC JTC 1.
International Standards are drafted in accordance with the rules given in the ISO/IEC Directives, Part 2.
The main task of the joint technical committee is to prepare International Standards. Draft International
Standards adopted by the joint technical committee are circulated to national bodies for voting. Publication as
an International Standard requires approval by at least 75 % of the national bodies casting a vote.
Attention is drawn to the possibility that some of the elements of this document may be the subject of patent
rights. ISO and IEC shall not be held responsible for identifying any or all such patent rights.
ISO/IEC 29500-1 was prepared by ISO/IEC JTC 1, Information technology, Subcommittee SC 34, Document
description and processing languages.
This second edition cancels and replaces the first edition (ISO/IEC 29500-1:2008), which has been technically
revised by incorporation of the Amendment ISO/IEC 29500-1:2008/Amd.1:2010 and the Technical Corrigendum
ISO/IEC 29500-1:2008/Cor.1:2010.
ISO/IEC 29500 consists of the following parts, under the general title Information technology — Document
description and processing languages — Office Open XML File Formats:
 Part 1: Fundamentals and Markup Language Reference
 Part 2: Open Packaging Conventions
 Part 3: Markup Compatibility and Extensibility
 Part 4: Transitional Migration Features
Annexes A, & and ' form a normative part of this Part of ISO/IEC 29500. Annexes B– and ,–D are for
information only.
This Part of ISO/IEC 29500 includes five annexes (Annex A, Annex B, Annex F, Annex G, and Annex H) that refer
to data files provided in electronic form.
viii ©ISO/IEC 2011 – All rights reserved

Introduction
ISO/IEC 29500 specifies a family of XML schemas, collectively called Office Open XML, which define the XML
vocabularies for word-processing, spreadsheet, and presentation documents, as well as the packaging of
documents that conform to these schemas.
The goal is to enable the implementation of the Office Open XML formats by the widest set of tools and
platforms, fostering interoperability across office productivity applications and line-of-business systems, as well
as to support and strengthen document archival and preservation, all in a way that is fully compatible with the
existing corpus of Microsoft Office documents.
The following organizations have participated in the creation of ISO/IEC 29500 and their contributions are
gratefully acknowledged:
Apple, Barclays Capital, BP, The British Library, Essilor, Intel, Microsoft, NextPage, Novell, Statoil, Toshiba, and
the United States Library of Congress
©ISO/IEC 2011 – All rights reserved ix

INTERNATIONAL STANDARD ISO/IEC 29500-1:2011(E)

Information technology — Document description and
processing languages — Office Open XML File Formats
Part 1:
Fundamentals and Markup Language Reference

1. Scope
ISO/IEC 29500 defines a set of XML vocabularies for representing word-processing documents, spreadsheets and
presentations. On the one hand, the goal of ISO/IEC 29500 is to be capable of faithfully representing the pre-
existing corpus of word-processing documents, spreadsheets and presentations that had been produced by the
Microsoft Office applications (from Microsoft Office 97 to Microsoft Office 2008, inclusive) at the date of the
creation of ISO/IEC 29500. It also specifies requirements for Office Open XML consumers and producers. On the
other hand, the goal is to facilitate extensibility and interoperability by enabling implementations by multiple
vendors and on multiple platforms.
This Part of ISO/IEC29500 specifies concepts for documents and applications of both strict and transitional
conformance.
©ISO/IEC 2011 – All rights reserved 1

2. Conformance
The text in ISO/IEC 29500 is divided into normative and informative categories. Text marked informative (using
the mechanisms described in §7) is for information purposes only. Unless stated otherwise, all text is normative.
Use of the word “shall” indicates required behavior.
Any behavior that is not explicitly specified by ISO/IEC 29500 is implicitly unspecified (§4).
2.1 Goal
This subclause is informative
The goal of this clause is to define conformance, and to provide interoperability guidelines in a way that fosters
broad and innovative use of the Office Open XML file format, while maximizing interoperability and preserving
investment in existing files and applications (§4). By meeting this goal, ISO/IEC 29500 benefits the following
audiences:
 Developers that design, implement, or maintain Office Open XML applications.
 Developers that interact programmatically with Office Open XML applications.
 Governmental or commercial entities that procure Office Open XML applications.
 Testing organizations that verify conformance of specific Office Open XML applications to ISO/IEC 29500.
(Note that ISO/IEC 29500 does not include a test suite.)
 Educators and authors who teach about Office Open XML applications.
End informative subclause
2.2 Issues
This subclause is informative
To achieve the above goal, the following issues need to be considered:
1. The application domain encompasses a range of possible consumers (§4) and producers (§4) so broad
that defining specific application behaviors would restrict innovation. For example, stipulating visual
layout would be inappropriate for a consumer that extracts data for machine consumption, or that
renders text in sound. Another example is that restricting capacity or precision runs the risk of diluting
the value of future advances in hardware.
2. Commonsense user expectations regarding the interpretation of an Office Open XML package (§4) play
such an important role in that package's value that a purely syntactic definition of conformance would
fail to effect a useful level of interoperability. For example, such a definition would admit an application
that reads a package, and then writes it in a manner that, though syntactically valid, differs arbitrarily
from the original.
2 ©ISO/IEC 2011 – All rights reserved

3. Legitimate operations on a package include deliberate transformations, making blanket change
prohibitions inappropriate in the conformance definition. For example, collapsing spreadsheet formulas
to their calculated values, or converting complex presentation graphics to static bitmaps, could be
correct for an application whose published purpose is to perform those operations. Again,
commonsense user expectation makes the difference.
4. Existing files and applications exercise a broad range of formats and functionality that, if required by the
conformance definition, would add an impractical amount of bulk to ISO/IEC 29500 and could
inadvertently obligate new applications to implement a prohibitive amount of functionality. This issue is
caused by the breadth of currently available functionality and is compounded by the existence of legacy
formats.
End informative subclause
2.3 What ISO/IEC 29500 Specifies
To address the issues listed above, ISO/IEC 29500 constrains both syntax and semantics, but it is not intended to
predefine application behavior. Therefore, it includes, among others, the following three types of information:
1. W3C XML Schemas and an associated validation procedure for validating document syntax against those
schemas. (The validation procedure includes un-zipping, locating files, processing the extensibility XML
elements and attributes, and W3C XML Schema validation.)
2. Additional syntax constraints in written form. [Note: These constraints are described in written form
because they could not feasibly be expressed in the schema language. end note]
3. Descriptions of XML element semantics. The semantics of an XML element refers to its intended
interpretation by a human being.
2.4 Document Conformance
Document conformance is purely syntactic; it involves only Items 1 and 2 in §2.3 above.
 A conforming document shall conform to the transitional W3C XML Schema or the strict W3C XML
Schema (Item 1), and any additional syntax constraints (Item 2).
 The document shall be of category Wordprocessing, Spreadsheet, or Presentation.
 The document character set shall conform to the Unicode Standard and ISO/IEC 10646, with either the
UTF-8 or UTF-16 encoding form, as required by the XML 1.0 standard.
 Any XML element or attribute not explicitly included in ISO/IEC 29500 shall use the extensibility
mechanisms described by ISO/IEC 29500-1 and ISO/IEC 29500-3.
Each Part of this multi-part standard has its own conformance clause. The term conformance class is used to
disambiguate conformance within different Parts of this multi-part standard. This Part of ISO/IEC 29500 defines
the following document conformance classes:
 WML Strict, if the document is a conforming document of category Wordprocessing that conforms to
the strict schema and does not include any features from Part 4.
©ISO/IEC 2011 – All rights reserved 3

 SML Strict, if the document is a conforming document of category Spreadsheet that conforms to the
strict schema and does not include any features from Part 4.
 PML Strict, if the document is a conforming document of category Presentation that conforms to the
strict schema and does not include any features from Part 4.
In addition, documents of conformance class WML Strict, SML Strict, or PML Strict shall not embed documents
of conformance class WML Transitional, SML Transitional, or PML Transitional as defined in Part 4.
Document categories Wordprocessing, Spreadsheet, and Presentation are defined in §4.
[Note: Other document conformance classes could be defined in the future. end note]
[Note: A document cannot be of more than one of the above conformance classes. end note]
2.5 Application Conformance
Application conformance incorporates both syntax and semantics; it involves items 1, 2, and 3 in §2.3 above.
 A conforming consumer shall not reject any conforming documents of at least one document
conformance class.
 A conforming producer shall be able to produce conforming documents of at least one document
conformance class.
 A conforming application shall treat the information in Office Open XML documents in a manner
consistent with the semantic definitions given in ISO/IEC 29500. An application's intended behavior
need not require that application to process all of the information in an Office Open XML document.
However, the information that it does process shall be processed in a manner that is consistent with the
semantic definitions given in ISO/IEC 29500.
[Note: This note illustrates the third bullet above. Conforming applications might serve various functions.
Examples include a viewer, an editor, and a back-end processor. Here is an illustration of how the third bullet
applies to each of those examples:
 If a conforming viewer supports a given feature, then when it displays information using that feature, it
respects the semantics of that feature as described in the Standard.
 If a conforming editor supports a given feature, then when it provides its user with an interface for
manipulating information using that feature, it respects the semantics of that feature as described in the
Standard.
 If a conforming back-end processor supports a given feature, then when that processor transforms or
assembles information involving that feature, that processor respects the semantics of that feature as
described in the Standard.
end note]
This Part of ISO/IEC 29500 defines the following application conformance classes:
4 ©ISO/IEC 2011 – All rights reserved

 WML Strict, if the application is a conforming application that is a consumer or producer of documents
having conformance class WML Strict.
 SML Strict, if the application is a conforming application that is a consumer or producer of documents
having conformance class SML Strict.
 PML Strict, if the application is a conforming application that is a consumer or producer of documents
having conformance class PML Strict.
Conformance can also involve the use of application descriptions; see §2.6 for details.
2.6 Application Descriptions
An application can be defined as conforming to zero or more application descriptions in a particular
conformance class.
The application descriptions defined within ISO/IEC 29500 are:
 Base
 Full
[Note: These application descriptions should not be taken as limiting the ability of an application provider to
create innovative applications. They are intended as a mechanism for labelling applications rather than for
restricting their capabilities. The intention is to promote interoperability between different applications that
share the same conformance class. Application descriptions are orthogonal to the conformance of the
documents produced by those applications. For example, a tool used for automated translation of documents
might have an application descript
...