ISO/IEC 29500-4:2016

INTERNATIONAL ISO/IEC
STANDARD 29500-4
Fourth edition
2016-11-01
Information technology — Document
description and processing
languages — Office Open XML File
Formats —
Part 4:
Transitional Migration Features
Technologies de l’information — Description des documents et
langages de traitement — Formats de fichier “Office Open XML” —
Partie 4: Caractéristiques de migration transitoire
Reference number
©
ISO/IEC 2016
COPYRIGHT PROTECTED DOCUMENT
© ISO/IEC 2016, Published in Switzerland
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized otherwise in any form
or by any means, electronic or mechanical, including photocopying, or posting on the internet or an intranet, without prior
written permission. Permission can be requested from either ISO at the address below or ISO’s member body in the country of
the requester.
ISO copyright office
Ch. de Blandonnet 8 • CP 401
CH-1214 Vernier, Geneva, Switzerland
Tel. +41 22 749 01 11
Fax +41 22 749 09 47
copyright@iso.org
www.iso.org
ii © ISO/IEC 2016 – All rights reserved

Contents
Foreword . xv
Introduction . xvi
1. Scope .1
2. Conformance .2
2.1 Document Conformance .2
2.2 Application Conformance .2
3. Normative References .4
4. Terms and Definitions .8
5. Notational Conventions .9
6. Acronyms and Abbreviations . 10
7. General Description. 11
8. Additional Shared Parts . 13
8.1 General . 13
8.2 VML Drawing Part . 13
9. WordprocessingML . 15
9.1 General . 15
9.2 Part Summary (Part 1, §11.3) . 15
9.2.1 Alternative Format Import Part (Part 1, §11.3.1) . 15
9.2.2 Comments Part (Part 1, §11.3.2) . 15
9.2.3 Document Settings Part (Part 1, §11.3.3) . 15
9.2.4 Endnotes Part (Part 1, §11.3.4) . 15
9.2.5 Fonts Table Part (Part 1, §11.3.5) . 15
9.2.6 Footer Part (Part 1, §11.3.6) . 15
9.2.7 Footnotes Part (Part 1, §11.3.7). 16
9.2.8 Glossary Document Part (Part 1, §11.3.8) . 16
9.2.9 Header Part (Part 1, §11.3.9) . 16
9.2.10 Main Document Part (Part 1, §11.3.10) . 16
9.2.11 Numbering Definitions Part (Part 1, §11.3.11) . 16
9.2.12 Style Definitions Part (Part 1, §11.3.12) . 16
9.2.13 Web Settings Part (Part 1, §11.3.13). 17
9.3 Document Template (Part 1, §11.4) . 17
9.4 Framesets (Part 1, §11.5) . 17
9.5 Master Documents and Subdocuments (Part 1, §11.6) . 17
9.6 Mail Merge Data Source (Part 1, §11.7) . 17
9.7 Mail Merger Header Data Source (Part 1, §11.8) . 17
9.8 XSL Transformation (Part 1, §11.9). 17
10. SpreadsheetML . 18
10.1 General . 18
10.2 Part Summary (Part 1, §12.3) . 18
©ISO/IEC 2016 – All rights reserved iii

10.2.1 Calculation Chain Part (Part 1, §12.3.1) . 18
10.2.2 Chartsheet Part (Part 1, §12.3.2) . 18
10.2.3 Comments Part (Part 1, §12.3.3) . 18
10.2.4 Connections Part (Part 1, §12.3.4) . 18
10.2.5 Custom Property Part (Part 1, §12.3.5). 18
10.2.6 Custom XML Mappings Part (Part 1, §12.3.6) . 19
10.2.7 Dialogsheet Part (Part 1, §12.3.7) . 19
10.2.8 Drawings Part (Part 1, §12.3.8) . 19
10.2.9 External Workbook References Part (Part 1, §12.3.9) . 19
10.2.10 Metadata Part (Part 1, §12.3.10) . 19
10.2.11 Pivot Table Part (Part 1, §12.3.11) . 19
10.2.12 Pivot Table Cache Definition Part (Part 1, §12.3.12) . 19
10.2.13 Pivot Table Cache Records Part (Part 1, §12.3.13) . 20
10.2.14 Query Table Part (Part 1, §12.3.14) . 20
10.2.15 Shared Strings Table Part (Part 1, §12.3.15) . 20
10.2.16 Shared Workbook Revision Headers Part (Part 1, §12.3.16) . 20
10.2.17 Shared Workbook Revision Log Part (Part 1, §12.3.17) . 20
10.2.18 Shared Workbook User Data part (Part 1, §12.3.18) . 20
10.2.19 Single Cell Table Definitions Part (Part 1, §12.3.19) . 20
10.2.20 Styles Part (Part 1, §12.3.20). 21
10.2.21 Table Definition Part (Part 1, §12.3.21) . 21
10.2.22 Volatile Dependencies Part (Part 1, §12.3.22) . 21
10.2.23 Workbook Part (Part 1, §12.3.23) . 21
10.2.24 Worksheet Part (Part 1, §12.3.24) . 21
10.3 External Workbooks (Part 1, §12.4) . 21
11. PresentationML . 22
11.1 General . 22
11.2 Part Summary (Part 1, §13.3) . 22
11.2.1 Comment Authors Part (Part 1, §13.3.1) . 22
11.2.2 Comments Part (Part 1, §13.3.2) . 22
11.2.3 Handout Master Part (Part 1, §13.3.3) . 22
11.2.4 Notes Master Part (Part 1, §13.3.4) . 22
11.2.5 Notes Slide Part (Part 1, §13.3.5) . 22
11.2.6 Presentation Part (Part 1, §13.3.6) . 23
11.2.7 Presentation Properties Part (Part 1, §13.3.7) . 23
11.2.8 Slide Part (Part 1, §13.3.8) . 23
11.2.9 Slide Layout Part (Part 1, §13.3.9) . 23
11.2.10 Slide Master Part (Part 1, §13.3.10) . 23
11.2.11 Slide Synchronization Data Part (Part 1, §13.3.11) . 23
11.2.12 User Defined Tags Part (Part 1, §13.3.12) . 23
11.2.13 View Properties Part (Part 1, §13.3.13) . 24
11.3 HTML Publish Location (Part 1, §13.4) . 24
11.4 Slide Synchronization Server Location (Part 1, §13.5) . 24
12. DrawingML . 25
12.1 General . 25
12.2 Part Summary (Part 1, §14.2) . 25
12.2.1 Chart Part (Part 1, §14.2.1) . 25
iv ©ISO/IEC 2016 – All rights reserved

12.2.2 Chart Drawing Part (Part 1, §14.2.2) . 25
12.2.3 Diagram Colors Part (Part 1, §14.2.3) . 25
12.2.4 Diagram Data Part (Part 1, §14.2.4) . 25
12.2.5 Diagram Layout Definition Part (Part 1, §14.2.5) . 25
12.2.6 Diagram Style Part (Part 1, §14.2.6) . 26
12.2.7 Theme Part (Part 1, §14.2.7) . 26
12.2.8 Theme Override Part (Part 1, §14.2.8) . 26
12.2.9 Table Styles Part (Part 1, §14.2.9) . 26
13. Shared MLs . 27
13.1 General . 27
13.2 Part Summary (Part 1, §15.2) . 27
13.2.1 Additional Characteristics Part (Part 1, §15.2.1) . 27
13.2.2 Audio Part (Part 1, §15.2.2) . 27
13.2.3 Bibliography Part (Part 1, §15.2.3) . 27
13.2.4 Content Part (Part 1, §15.2.4) . 27
13.2.5 Custom XML Data Storage Part (Part 1, §15.2.5) . 27
13.2.6 Custom XML Data Storage Properties Part (Part 1, §15.2.6) . 27
13.2.7 Embedded Control Persistence Part (Part 1, §15.2.9) . 28
13.2.8 Embedded Object Part (Part 1, §15.2.10) . 28
13.2.9 Embedded Package Part (Part 1, §15.2.11) . 28
13.2.10 Core File Properties Part (Part 1, §15.2.12.1) . 28
13.2.11 Custom File Properties Part (Part 1, §15.2.12.2) . 28
13.2.12 Extended File Properties Part (Part 1, §15.2.12.3) . 28
13.2.13 Font Part (Part 1, §15.2.13) . 28
13.2.14 Image Part (Part 1, §15.2.14) . 28
13.2.15 Printer Settings Part (Part 1, §15.2.15) . 28
13.2.16 Thumbnail Part (Part 1, §15.2.16) . 29
13.2.17 Video Part (Part 1, §15.2.17) . 29
13.3 Hyperlinks Part (Part 1, §15.3). 29
14. WordprocessingML Reference Material . 30
14.1 General . 30
14.2 Table of Contents . 30
14.3 Paragraphs and Rich Formatting . 34
14.3.1 Paragraphs . 34
14.3.2 Run Content . 35
14.4 Tables . 38
14.4.1 left (Table Cell Leading Edge Border) . 38
14.4.2 left (Table Leading Edge Border) . 38
14.4.3 left (Table Cell Leading Margin Exception) . 38
14.4.4 left (Table Cell Leading Margin Default) . 38
14.4.5 right (Table Cell Trailing Edge Border) . 39
14.4.6 right (Table Trailing Edge Border) . 39
14.4.7 right (Table Cell Trailing Margin Default) . 39
14.4.8 right (Table Cell Trailing Margin Exception) . 39
14.4.9 Additional attribute for cnfStyle element (Part 1, §17.4.7) . 39
14.4.10 Additional attribute for cnfStyle element (Part 1, §17.4.8) . 40
14.4.11 Additional attribute for tblLook element (Part 1, §17.4.54) . 41
©ISO/IEC 2016 – All rights reserved v

14.4.12 Additional attribute for tblLook element (Part 1, §17.4.55) . 42
14.4.13 hMerge (Horizontally Merged Cell) . 43
14.5 Fonts . 45
14.5.1 Elements . 45
14.6 Numbering . 47
14.6.1 pict (Picture Numbering Symbol Properties) . 47
14.6.2 legacy (Legacy Numbering Level Properties) . 48
14.7 Annotations . 49
14.7.1 Revisions . 49
14.8 Settings . 58
14.8.1 Legacy Password Hash Algorithm . 58
14.8.2 Document Settings . 65
14.8.3 Compatibility Settings . 79
14.8.4 Web Page Settings . 158
14.9 Miscellaneous Topics . 159
14.9.1 Text Box Content . 159
14.10 Fields and Hyperlinks . 161
14.10.1 Syntax . 161
14.10.2 Legacy language references . 162
14.10.3 Use of DOS File Paths . 169
14.10.4 Field definitions . 169
14.10.5 fldData (Custom Field Data) . 178
14.10.6 fldData (Custom Field Data) . 179
14.10.7 hyperlink (Hyperlink) (Part 1, §17.16.22) . 180
14.11 Simple Types . 180
14.11.1 Additional member types for the union in ST_DecimalNumberOrPercent (Part 1, §17.18.11) . 180
14.11.2 Additional enumeration values for ST_Jc (Part 1, §17.18.44). 180
14.11.3 Additional enumeration values for ST_JcTable (Part 1, §17.18.45) . 180
14.11.4 Additional enumeration values for ST_NumberFormat (Part 1, §17.18.59) . 181
14.11.5 Additional enumeration values for ST_StyleSort (Part 1, §17.18.82) . 181
14.11.6 Additional enumeration values for ST_TabJc (Part 1, §17.18.84) . 182
14.11.7 Additional enumeration values for ST_TextDirection (Part 1, §17.18.93) . 182
14.11.8 Additional member types for the union in ST_TextScale (Part 1, §17.18.95) . 182
14.11.9 ST_Cnf (Conditional Formatting Bitmask) . 182
14.11.10 ST_UnqualifiedPercentage (Percentage Value Without Percent Sign) . 184
14.11.11 ST_TextScaleDecimal (Text Expansion/Compression Percentage) . 184
14.11.12 Changed enumeration value for ST_BrType (Part 1, §17.18.4) . 185
14.12 Changed attributes . 185
14.12.1 General . 185
14.12.2 Changed attribute for contentPart element (Part 1, §17.3.3.2) . 185
14.12.3 Changed attribute for control element (Part 1, §17.3.3.3) . 186
14.12.4 Changed attribute for movie element (Part 1, §17.3.3.17) . 186
14.12.5 Changed attribute for objectEmbed element (Part 1, §17.3.3.20) . 187
14.12.6 Changed attribute for objectLink element (Part 1, §17.3.3.21). 188
14.12.7 Changed attribute for bottom element (Part 1, §17.6.2) . 188
14.12.8 Changed attribute for left element (Part 1, §17.6.7) . 189
14.12.9 Changed attribute for printerSettings element (Part 1, §17.6.14) . 190
14.12.10 Changed attribute for right element (Part 1, §17.6.15) . 191
vi ©ISO/IEC 2016 – All rights reserved

14.12.11 Changed attribute for top element (Part 1, §17.6.21) . 191
14.12.12 Changed attribute for embedBold element (Part 1, §17.8.3.3) . 193
14.12.13 Changed attribute for embedBoldItalic element (Part 1, §17.8.3.4) . 193
14.12.14 Changed attribute for embedItalic element (Part 1, §17.8.3.5) . 194
14.12.15 Changed attribute for embedRegular element (Part 1, §17.8.3.6) . 195
14.12.16 Changed attribute for footerReference element (Part 1, §17.10.2) . 195
14.12.17 Changed attribute for headerReference element (Part 1, §17.10.5) . 196
14.12.18 Changed attribute for dataSource element (Part 1, §17.14.9) . 197
14.12.19 Changed attribute for headerSource element (Part 1, §17.14.16) . 197
14.12.20 Changed attribute for recipientData element (Part 1, §17.14.28) . 198
14.12.21 Changed attribute for src element (Part 1, §17.14.30) . 199
14.12.22 Changed attribute for attachedTemplate element (Part 1, §17.15.1.6). 199
14.12.23 Changed attribute for saveThroughXslt element (Part 1, §17.15.1.76) . 200
14.12.24 Changed attribute for longDesc element (Part 1, §17.15.2.23). 200
14.12.25 Changed attribute for sourceFileName element (Part 1, §17.15.2.39) . 201
14.12.26 Changed attribute for subDoc element (Part 1, §17.17.1.1) . 202
14.12.27 Changed attribute for altChunk element (Part 1, §17.17.2.1) . 202
15. SpreadsheetML Reference Material . 204
15.1 General . 204
15.2 Table of Contents . 204
15.3 Workbook . 205
15.3.1 Additional attribute for fileSharing element (Part 1, §18.2.12). 205
15.3.2 Additional attribute for webPublishing element (Part 1, §18.2.24) . 205
15.3.3 Additional attributes for workbookProtection element (Part 1, §18.2.29) . 206
15.3.4 Modified content for Date Conversion for Serial Date-Times (Part 1, §18.17.4.1) . 212
15.4 Worksheets . 213
15.4.1 Worksheets . 213
15.4.2 AutoFilter Settings . 215
15.5 Styles . 216
15.5.1 left (Leading Edge Border) . 216
15.5.2 right (Trailing Edge Border) . 217
15.6 Pivot Tables. 217
15.6.1 Pivot Tables . 217
15.7 External Data Connections . 217
15.7.1 Additional attribute for textPr element (Part 1, §18.13.12) . 217
15.8 Simple Types . 218
15.8.1 Additional enumeration values for ST_PivotAreaType (Part 1, §18.18.58) . 218
15.8.2 ST_UnsignedShortHex (Unsigned Short Hex) . 218
15.8.3 Removed enumeration values for ST_CellType (Part 1, §18.18.11) . 218
15.9 Formulas . 218
15.9.1 Attribute synonym for c element (Part 1, §18.6.1) . 218
15.9.2 Additional representation for dates and times (Part 1, §18.17.4 ) . 219
15.10 Changed attributes . 219
15.10.1 Changed attribute for externalReference element (Part 1, §18.2.8) . 219
15.10.2 Changed attribute for pivotCache element (Part 1, §18.2.17) . 219
15.10.3 Changed attribute for sheet element (Part 1, §18.2.19) . 219
15.10.4 Changed attribute for control element (Part 1, §18.3.1.19) . 220
©ISO/IEC 2016 – All rights reserved vii

15.10.5 Changed attribute for controlPr element (Part 1, §18.3.1.20) . 220
15.10.6 Changed attribute for customPr element (Part 1, §18.3.1.22) . 220
15.10.7 Changed attribute for dataRef element (Part 1, §18.3.1.30) . 221
15.10.8 Changed attribute for drawing element (Part 1, §18.3.1.36) . 221
15.10.9 Changed attribute for drawingHF element (Part 1, §18.3.1.37) . 221
15.10.10 Changed attribute for hyperlink element (Part 1, §18.3.1.47) . 221
15.10.11 Changed attribute for objectPr element (Part 1, §18.3.1.56) . 222
15.10.12 Changed attribute for oleObject element (Part 1, §18.3.1.59) . 222
15.10.13 Changed attribute for pageSetup element (Part 1, §18.3.1.63) . 222
15.10.14 Changed attribute for pageSetup element (Part 1, §18.3.1.64) . 222
15.10.15 Changed attribute for picture element (Part 1, §18.3.1.67) . 223
15.10.16 Changed attribute for pivotSelection element (Part 1, §18.3.1.69) . 223
15.10.17 Changed attribute for tablePart element (Part 1, §18.3.1.94) . 223
15.10.18 Changed attribute for pivotCacheDefinition element (Part 1, §18.10.1.67) . 223
15.10.19 Changed attribute for rangeSet element (Part 1, §18.10.1.79) . 223
15.10.20 Changed attribute for worksheetSource element (Part 1, §18.10.1.95) . 224
15.10.21 Changed attribute for header element (Part 1, §18.11.1.1) . 224
15.10.22 Changed attribute for externalBook element (Part 1, §18.14.7) . 224
15.10.23 Changed attribute for oleLink element (Part 1, §18.14.11) . 224
16. PresentationML Reference Material . 226
16.1 General . 226
16.2 Table of Contents . 226
16.3 Presentation . 227
16.3.1 Presentation Properties . 227
16.4 Slides . 235
16.4.1 Embedded Objects . 235
16.5 Simple Types . 236
16.5.1 ST_WebColorType (HTML Slide Navigation Control Colors) . 236
16.5.2 ST_WebEncoding (Web Encoding) . 236
16.5.3 ST_WebScreenSize (HTML/Web Screen Size Target) . 236
16.6 Changed attributes . 237
16.6.1 Changed attribute for bold element (Part 1, §19.2.1.1) . 237
16.6.2 Changed attribute for boldItalic element (Part 1, §19.2.1.2) . 238
16.6.3 Changed attribute for handoutMasterId element (Part 1, §19.2.1.14) . 238
16.6.4 Changed attribute for italic element (Part 1, §19.2.1.16). 238
16.6.5 Changed attribute for notesMasterId element (Part 1, §19.2.1.20) . 239
16.6.6 Changed attribute for notesSz element (Part 1, §19.2.1.22) . 239
16.6.7 Changed attribute for regular element (Part 1, §19.2.1.29) . 240
16.6.8 Changed attribute for sld element (Part 1, §19.2.1.31) . 240
16.6.9 Changed attribute for sldId element (Part 1, §19.2.1.33). 240
16.6.10 Changed attribute for sldMasterId element (Part 1, §19.2.1.36) . 240
16.6.11 Changed attribute for SmartTags element (Part 1, §19.2.1.40) . 241
16.6.12 Changed attribute for gridSpacing element (Part 1, §19.2.2.3). 241
16.6.13 Changed attribute for origin element (Part 1, §19.2.2.9) . 242
16.6.14 Changed attribute for sld element (Part 1, §19.2.2.14) . 242
16.6.15 Changed attribute for bgRef element (Part 1, §19.3.1.3) . 243
16.6.16 Changed attribute for blipFill element (Part 1, §19.3.1.4) . 243
viii ©ISO/IEC 2016 – All rights reserved

16.6.17 Changed attribute for clrMap element (Part 1, §19.3.1.6) . 243
16.6.18 Changed attribute for cNvPicPr element (Part 1, §19.3.1.11) . 245
16.6.19 Changed attribute for cNvPr element (Part 1, §19.3.1.12) . 245
16.6.20 Changed attribute for cNvSpPr element (Part 1, §19.3.1.13) . 247
16.6.21 Changed attribute for contentPart element (Part 1, §19.3.1.14) . 247
16.6.22 Changed attribute for custData element (Part 1, §19.3.1.17) . 248
16.6.23 Changed attribute for grpSpPr element (Part 1, §19.3.1.23) . 248
16.6.24 Changed attribute for sldLayoutId element (Part 1, §19.3.1.40) . 248
16.6.25 Changed attribute for spPr element (Part 1, §19.3.1.44) . 248
16.6.26 Changed attribute for tags element (Part 1, §19.3.1.47) . 249
16.6.27 Changed attribute for xfrm element (Part 1, §19.3.1.53) . 249
16.6.28 Changed attribute for control element (Part 1, §19.3.2.1) . 250
16.6.29 Changed attribute for oleObj element (Part 1, §19.3.2.4). 250
16.6.30 Changed attribute for pos element (Part 1, §19.4.5) . 250
16.6.31 Changed attribute for snd element (Part 1, §19.5.68) . 251
16.6.32 Changed attribute for sndTgt element (Part 1, §19.5.70) . 251
17. DrawingML - Framework Reference Material . 252
17.1 General . 252
17.2 DrawingML - Main . 252
17.2.1 Table of Contents . 252
17.2.2 Simple Types . 252
17.3 DrawingML - Legacy Compatibility . 256
17.3.1 Table of Contents . 256
17.3.2 Basics . 257
17.4 Changed attributes . 257
17.4.1 Changed attribute for hlinkHover element (Part 1, §20.1.2.2.23). 257
17.4.2 Changed attribute for snd element (Part 1, §20.1.2.2.32) . 258
17.4.3 Changed attribute for audioFile element (Part 1, §20.1.3.2) . 258
17.4.4 Changed attribute for quickTimeFile element (Part 1, §20.1.3.4) . 259
17.4.5 Changed attribute for videoFile element (Part 1, §20.1.3.6) . 259
17.4.6 Changed attribute for wavAudioFile element (Part 1, §20.1.3.7) . 259
17.4.7 Changed attribute for blip element (Pa
...