ISO/IEC 29500-4:2011

INTERNATIONAL ISO/IEC
STANDARD 29500-4
Second edition
2011-08-15
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 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 . xiii
Introduction . xiv
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 . 10
6. Acronyms and Abbreviations . 11
7. General Description. 12
8. Additional Shared Parts . 13
8.1 VML Drawing Part . 13
9. WordprocessingML . 15
9.1 Part Summary (Part 1, §11.3) . 15
9.1.1 Alternative Format Import Part (Part 1, §11.3.1) . 15
9.1.2 Comments Part (Part 1, §11.3.2) . 15
9.1.3 Document Settings Part (Part 1, §11.3.3) . 15
9.1.4 Endnotes Part (Part 1, §11.3.4) . 15
9.1.5 Fonts Table Part (Part 1, §11.3.5) . 15
9.1.6 Footer Part (Part 1, §11.3.6) . 15
9.1.7 Footnotes Part (Part 1, §11.3.7). 16
9.1.8 Glossary Document Part (Part 1, §11.3.8) . 16
9.1.9 Header Part (Part 1, §11.3.9) . 16
9.1.10 Main Document Part (Part 1, §11.3.10) . 16
9.1.11 Numbering Definitions Part (Part 1, §11.3.11) . 16
9.1.12 Style Definitions Part (Part 1, §11.3.12) . 16
9.1.13 Web Settings Part (Part 1, §11.3.13). 16
9.2 Document Template (Part 1, §11.4) . 17
9.3 Framesets (Part 1, §11.5) . 17
9.4 Master Documents and Subdocuments (Part 1, §11.6) . 17
9.5 Mail Merge Data Source (Part 1, §11.7) . 17
9.6 Mail Merger Header Data Source (Part 1, §11.8) . 17
9.7 XSL Transformation (Part 1, §11.9) . 17
10. SpreadsheetML . 18
10.1 Part Summary (Part 1, §12.3) . 18
10.1.1 Calculation Chain Part (Part 1, §12.3.1) . 18
10.1.2 Chartsheet Part (Part 1, §12.3.2) . 18
10.1.3 Comments Part (Part 1, §12.3.3) . 18
©ISO/IEC 2011 – All rights reserved iii

10.1.4 Connections Part (Part 1, §12.3.4) . 18
10.1.5 Custom Property Part (Part 1, §12.3.5). 18
10.1.6 Custom XML Mappings Part (Part 1, §12.3.6) . 19
10.1.7 Dialogsheet Part (Part 1, §12.3.7) . 19
10.1.8 Drawings Part (Part 1, §12.3.8) . 19
10.1.9 External Workbook References Part (Part 1, §12.3.9) . 19
10.1.10 Metadata Part (Part 1, §12.3.10) . 19
10.1.11 Pivot Table Part (Part 1, §12.3.11) . 19
10.1.12 Pivot Table Cache Definition Part (Part 1, §12.3.12) . 19
10.1.13 Pivot Table Cache Records Part (Part 1, §12.3.13) . 20
10.1.14 Query Table Part (Part 1, §12.3.14) . 20
10.1.15 Shared Strings Table Part (Part 1, §12.3.15) . 20
10.1.16 Shared Workbook Revision Headers Part (Part 1, §12.3.16) . 20
10.1.17 Shared Workbook Revision Log Part (Part 1, §12.3.17) . 20
10.1.18 Shared Workbook User Data part (Part 1, §12.3.18) . 20
10.1.19 Single Cell Table Definitions Part (Part 1, §12.3.19) . 20
10.1.20 Styles Part (Part 1, §12.3.20). 21
10.1.21 Table Definition Part (Part 1, §12.3.21) . 21
10.1.22 Volatile Dependencies Part (Part 1, §12.3.22) . 21
10.1.23 Workbook Part (Part 1, §12.3.23) . 21
10.1.24 Worksheet Part (Part 1, §12.3.24) . 21
10.2 External Workbooks (Part 1, §12.4) . 21
11. PresentationML . 22
11.1 Part Summary (Part 1, §13.3) . 22
11.1.1 Comment Authors Part (Part 1, §13.3.1) . 22
11.1.2 Comments Part (Part 1, §13.3.2) . 22
11.1.3 Handout Master Part (Part 1, §13.3.3) . 22
11.1.4 Notes Master Part (Part 1, §13.3.4) . 22
11.1.5 Notes Slide Part (Part 1, §13.3.5) . 22
11.1.6 Presentation Part (Part 1, §13.3.6) . 23
11.1.7 Presentation Properties Part (Part 1, §13.3.7) . 23
11.1.8 Slide Part (Part 1, §13.3.8) . 23
11.1.9 Slide Layout Part (Part 1, §13.3.9) . 23
11.1.10 Slide Master Part (Part 1, §13.3.10) . 23
11.1.11 Slide Synchronization Data Part (Part 1, §13.3.11) . 23
11.1.12 User Defined Tags Part (Part 1, §13.3.12) . 23
11.1.13 View Properties Part (Part 1, §13.3.13) . 24
11.2 HTML Publish Location (Part 1, §13.4). 24
11.3 Slide Synchronization Server Location (Part 1, §13.5) . 24
12. DrawingML . 25
12.1 Part Summary (Part 1, §14.2) . 25
12.1.1 Chart Part (Part 1, §14.2.1) . 25
12.1.2 Chart Drawing Part (Part 1, §14.2.2) . 25
12.1.3 Diagram Colors Part (Part 1, §14.2.3) . 25
12.1.4 Diagram Data Part (Part 1, §14.2.4) . 25
12.1.5 Diagram Layout Definition Part (Part 1, §14.2.5) . 25
12.1.6 Diagram Style Part (Part 1, §14.2.6) . 26
iv ©ISO/IEC 2011 – All rights reserved

12.1.7 Theme Part (Part 1, §14.2.7) . 26
12.1.8 Theme Override Part (Part 1, §14.2.8) . 26
12.1.9 Table Styles Part (Part 1, §14.2.9) . 26
13. Shared MLs . 27
13.1 Part Summary (Part 1, §15.2) . 27
13.1.1 Additional Characteristics Part (Part 1, §15.2.1) . 27
13.1.2 Audio Part (Part 1, §15.2.2) . 27
13.1.3 Bibliography Part (Part 1, §15.2.3) . 27
13.1.4 Content Part (Part 1, §15.2.4) . 27
13.1.5 Custom XML Data Storage Part (Part 1, §15.2.5) . 27
13.1.6 Custom XML Data Storage Properties Part (Part 1, §15.2.6) . 27
13.1.7 Embedded Control Persistence Part (Part 1, §15.2.9) . 28
13.1.8 Embedded Object Part (Part 1, §15.2.10) . 28
13.1.9 Embedded Package Part (Part 1, §15.2.11) . 28
13.1.10 Core File Properties Part (Part 1, §15.2.12.1) . 28
13.1.11 Custom File Properties Part (Part 1, §15.2.12.2) . 28
13.1.12 Extended File Properties Part (Part 1, §15.2.12.3) . 28
13.1.13 Font Part (Part 1, §15.2.13) . 28
13.1.14 Image Part (Part 1, §15.2.14) . 28
13.1.15 Printer Settings Part (Part 1, §15.2.15) . 28
13.1.16 Thumbnail Part (Part 1, §15.2.16) . 29
13.1.17 Video Part (Part 1, §15.2.17) . 29
13.2 Hyperlinks Part (Part 1, §15.3) . 29
14. WordprocessingML Reference Material . 30
14.1 Table of Contents . 30
14.2 Paragraphs and Rich Formatting . 33
14.2.1 Paragraphs . 33
14.2.2 Run Content . 34
14.3 Tables . 37
14.3.1 left (Table Cell Leading Edge Border) . 37
14.3.2 left (Table Leading Edge Border) . 38
14.3.3 left (Table Cell Leading Margin Exception) . 38
14.3.4 left (Table Cell Leading Margin Default) . 38
14.3.5 right (Table Cell Trailing Edge Border) . 38
14.3.6 right (Table Trailing Edge Border) . 39
14.3.7 right (Table Cell Trailing Margin Default) . 39
14.3.8 right (Table Cell Trailing Margin Exception) . 39
14.3.9 Additional attribute for cnfStyle element (Part 1, §17.4.7) . 40
14.3.10 Additional attribute for cnfStyle element (Part 1, §17.4.8) . 41
14.3.11 Additional attribute for tblLook element (Part 1, §17.4.55) . 42
14.3.12 Additional attribute for tblLook element (Part 1, §17.4.56) . 43
14.4 Fonts . 44
14.4.1 Elements . 44
14.5 Numbering . 45
14.5.1 pict (Picture Numbering Symbol Properties) . 45
14.6 Annotations . 46
14.6.1 Revisions . 46
©ISO/IEC 2011 – All rights reserved v

14.7 Settings . 55
14.7.1 Legacy Password Hash Algorithm . 55
14.7.2 Document Settings . 63
14.7.3 Compatibility Settings . 78
14.8 Miscellaneous Topics . 162
14.8.1 Text Box Content . 162
14.9 Fields and Hyperlinks . 165
14.9.1 Syntax . 165
14.9.2 Legacy language references . 166
14.9.3 Use of DOS File Paths . 173
14.9.4 Field definitions . 173
14.9.5 fldData (Custom Field Data) . 182
14.9.6 fldData (Custom Field Data) . 183
14.9.7 hyperlink (Hyperlink) (Part 1, §17.16.22) . 184
14.10 Simple Types . 184
14.10.1 Additional member types for the union in ST_DecimalNumberOrPercent (Part 1, §17.18.11) . 184
14.10.2 Additional enumeration values for ST_Jc (Part 1, §17.18.44). 184
14.10.3 Additional enumeration values for ST_JcTable (Part 1, §17.18.45) . 185
14.10.4 Additional enumeration values for ST_NumberFormat (Part 1, §17.18.59) . 185
14.10.5 Additional enumeration values for ST_StyleSort (Part 1, §17.18.82) . 186
14.10.6 Additional enumeration values for ST_TabJc (Part 1, §17.18.84) . 186
14.10.7 Additional enumeration values for ST_TextDirection (Part 1, §17.18.93) . 186
14.10.8 Additional member types for the union in ST_TextScale (Part 1, §17.18.95) . 187
14.10.9 ST_Cnf (Conditional Formatting Bitmask) . 187
14.10.10 ST_UnqualifiedPercentage (Percentage Value Without Percent Sign) . 188
14.10.11 ST_TextScaleDecimal (Text Expansion/Compression Percentage) . 189
14.11 Changed attributes . 189
14.11.1 Changed attribute for contentPart element (Part 1, §17.3.3.2) . 189
14.11.2 Changed attribute for control element (Part 1, §17.3.3.3) . 190
14.11.3 Changed attribute for movie element (Part 1, §17.3.3.17) . 190
14.11.4 Changed attribute for objectEmbed element (Part 1, §17.3.3.20) . 191
14.11.5 Changed attribute for objectLink element (Part 1, §17.3.3.21). 192
14.11.6 Changed attribute for bottom element (Part 1, §17.6.2) . 192
14.11.7 Changed attribute for left element (Part 1, §17.6.7) . 193
14.11.8 Changed attribute for printerSettings element (Part 1, §17.6.14) . 194
14.11.9 Changed attribute for right element (Part 1, §17.6.15) . 195
14.11.10 Changed attribute for top element (Part 1, §17.6.21) . 195
14.11.11 Changed attribute for embedBold element (Part 1, §17.8.3.3) . 197
14.11.12 Changed attribute for embedBoldItalic element (Part 1, §17.8.3.4) . 197
14.11.13 Changed attribute for embedItalic element (Part 1, §17.8.3.5) . 198
14.11.14 Changed attribute for embedRegular element (Part 1, §17.8.3.6) . 199
14.11.15 Changed attribute for footerReference element (Part 1, §17.10.2) . 199
14.11.16 Changed attribute for headerReference element (Part 1, §17.10.5) . 200
14.11.17 Changed attribute for dataSource element (Part 1, §17.14.9) . 201
14.11.18 Changed attribute for headerSource element (Part 1, §17.14.16) . 201
14.11.19 Changed attribute for recipientData element (Part 1, §17.14.28) . 202
14.11.20 Changed attribute for src element (Part 1, §17.14.30) . 203
14.11.21 Changed attribute for attachedTemplate element (Part 1, §17.15.1.6). 203
vi ©ISO/IEC 2011 – All rights reserved

14.11.22 Changed attribute for saveThroughXslt element (Part 1, §17.15.1.76) . 204
14.11.23 Changed attribute for longDesc element (Part 1, §17.15.2.23). 204
14.11.24 Changed attribute for sourceFileName element (Part 1, §17.15.2.39) . 205
14.11.25 Changed attribute for subDoc element (Part 1, §17.17.1.1) . 206
14.11.26 Changed attribute for altChunk element (Part 1, §17.17.2.1) . 206
15. SpreadsheetML Reference Material . 208
15.1 Table of Contents . 208
15.2 Workbook . 208
15.2.1 Additional attribute for fileSharing element (Part 1, §18.2.12). 208
15.2.2 Additional attribute for webPublishing element (Part 1, §18.2.24) . 209
15.2.3 Additional attributes for workbookProtection element (Part 1, §18.2.29) . 209
15.3 Worksheets . 215
15.3.1 Worksheets . 215
15.3.2 AutoFilter Settings . 218
15.4 Styles . 219
15.4.1 left (Leading Edge Border) . 219
15.4.2 right (Trailing Edge Border) . 220
15.5 Pivot Tables . 220
15.5.1 Pivot Tables . 220
15.6 External Data Connections . 220
15.6.1 Additional attribute for textPr element (Part 1, §18.13.12) . 220
15.7 Simple Types . 221
15.7.1 Additional enumeration values for ST_PivotAreaType (Part 1, §18.18.58) . 221
15.7.2 ST_UnsignedShortHex (Unsigned Short Hex) . 221
15.8 Formulas . 221
15.8.1 Attribute synonym for c element (Part 1, §18.6.1) . 221
15.8.2 Additional representation for dates and times (Part 1, §18.17.4 ) . 222
15.9 Changed attributes . 222
15.9.1 Changed attribute for externalReference element (Part 1, §18.2.8) . 222
15.9.2 Changed attribute for pivotCache element (Part 1, §18.2.17) . 222
15.9.3 Changed attribute for sheet element (Part 1, §18.2.19) . 222
15.9.4 Changed attribute for control element (Part 1, §18.3.1.19) . 223
15.9.5 Changed attribute for controlPr element (Part 1, §18.3.1.20) . 223
15.9.6 Changed attribute for customPr element (Part 1, §18.3.1.22) . 223
15.9.7 Changed attribute for dataRef element (Part 1, §18.3.1.30) . 224
15.9.8 Changed attribute for drawing element (Part 1, §18.3.1.36) . 224
15.9.9 Changed attribute for drawingHF element (Part 1, §18.3.1.37) . 224
15.9.10 Changed attribute for hyperlink element (Part 1, §18.3.1.47) . 224
15.9.11 Changed attribute for objectPr element (Part 1, §18.3.1.56) . 225
15.9.12 Changed attribute for oleObject element (Part 1, §18.3.1.59) . 225
15.9.13 Changed attribute for pageSetup element (Part 1, §18.3.1.63) . 225
15.9.14 Changed attribute for pageSetup element (Part 1, §18.3.1.64) . 225
15.9.15 Changed attribute for picture element (Part 1, §18.3.1.67) . 226
15.9.16 Changed attribute for pivotSelection element (Part 1, §18.3.1.69) . 226
15.9.17 Changed attribute for tablePart element (Part 1, §18.3.1.94) . 226
15.9.18 Changed attribute for pivotCacheDefinition element (Part 1, §18.10.1.67) . 226
15.9.19 Changed attribute for rangeSet element (Part 1, §18.10.1.79) . 226
©ISO/IEC 2011 – All rights reserved vii

15.9.20 Changed attribute for worksheetSource element (Part 1, §18.10.1.95) . 227
15.9.21 Changed attribute for header element (Part 1, §18.11.1.1) . 227
15.9.22 Changed attribute for externalBook element (Part 1, §18.14.7) . 227
15.9.23 Changed attribute for oleLink element (Part 1, §18.14.11) . 227
16. PresentationML Reference Material . 229
16.1 Table of Contents . 229
16.2 Presentation. 230
16.2.1 Presentation Properties . 230
16.3 Slides . 239
16.3.1 Embedded Objects . 239
16.4 Simple Types . 239
16.4.1 ST_WebColorType (HTML Slide Navigation Control Colors) . 239
16.4.2 ST_WebEncoding (Web Encoding) . 240
16.4.3 ST_WebScreenSize (HTML/Web Screen Size Target) . 240
16.5 Changed attributes . 241
16.5.1 Changed attribute for bold element (Part 1, §19.2.1.1) . 241
16.5.2 Changed attribute for boldItalic element (Part 1, §19.2.1.2) . 241
16.5.3 Changed attribute for font element (Part 1, §19.2.1.13) . 241
16.5.4 Changed attribute for handoutMasterId element (Part 1, §19.2.1.14) . 244
16.5.5 Changed attribute for italic element (Part 1, §19.2.1.16). 244
16.5.6 Changed attribute for notesMasterId element (Part 1, §19.2.1.20) . 244
16.5.7 Changed attribute for notesSz element (Part 1, §19.2.1.22) . 244
16.5.8 Changed attribute for regular element (Part 1, §19.2.1.29) . 245
16.5.9 Changed attribute for sld element (Part 1, §19.2.1.31) . 245
16.5.10 Changed attribute for sldId element (Part 1, §19.2.1.33). 246
16.5.11 Changed attribute for sldMasterId element (Part 1, §19.2.1.36) . 246
16.5.12 Changed attribute for SmartTags element (Part 1, §19.2.1.40) . 246
16.5.13 Changed attribute for gridSpacing element (Part 1, §19.2.2.3). 246
16.5.14 Changed attribute for origin element (Part 1, §19.2.2.9) . 247
16.5.15 Changed attribute for sld element (Part 1, §19.2.2.14) . 247
16.5.16 Changed attribute for bgRef element (Part 1, §19.3.1.3) . 248
16.5.17 Changed attribute for blipFill element (Part 1, §19.3.1.4) . 248
16.5.18 Changed attribute for clrMap element (Part 1, §19.3.1.6) . 248
16.5.19 Changed attribute for cNvPicPr element (Part 1, §19.3.1.11) . 250
16.5.20 Changed attribute for cNvPr element (Part 1, §19.3.1.12) . 250
16.5.21 Changed attribute for cNvSpPr element (Part 1, §19.3.1.13) . 252
16.5.22 Changed attribute for contentPart element (Part 1, §19.3.1.14) . 252
16.5.23 Changed attribute for custData element (Part 1, §19.3.1.17) . 253
16.5.24 Changed attribute for grpSpPr element (Part 1, §19.3.1.23) . 253
16.5.25 Changed attribute for sldLayoutId element (Part 1, §19.3.1.40) . 253
16.5.26 Changed attribute for spPr element (Part 1, §19.3.1.44) . 253
16.5.27 Changed attribute for tags element (Part 1, §19.3.1.47) . 254
16.5.28 Changed attribute for xfrm element (Part 1, §19.3.1.53) . 254
16.5.29 Changed attribute for control element (Part 1, §19.3.2.1) . 255
16.5.30 Changed attribute for oleObj element (Part 1, §19.3.2.4). 255
16.5.31 Changed attribute for pos element (Part 1, §19.4.5) . 255
16.5.32 Changed attribute for snd element (Part 1, §19.5.68) . 256
viii ©ISO/IEC 2011 – All rights reserved

16.5.33 Changed attribute for sndTgt element (Part 1, §19.5.70) . 256
17. DrawingML - Framework Reference Material . 258
17.1 DrawingML - Main . 258
17.1.1 Table of Contents . 258
17.1.2 Simple Types . 258
17.2 DrawingML - Legacy Compatibility . 262
17.2.1 Table of Contents . 262
17.2.2 Basics . 263
17.3 Changed attributes . 264
17.3.1 Changed attribute for hlinkHover element (Part 1, §20.1.2.2.23). 264
17.3.2 Changed attribute for snd element (Part 1, §20.1.2.2.32) . 265
17.3.3 Changed attribute for audioFile element (Part 1, §20.1.3.2) . 265
17.3.4 Changed attribute for quickTimeFile element (Part 1, §20.1.3.4) . 265
17.3.5 Changed attribute for videoFile element (Part 1, §20.1.3.6) . 265
17.3.6 Changed attribute for wavAudioFile element (Part 1, §20.1.3.7) . 266
17.3.7 Changed attribute for blip element (Part 1, §20.1.8.13) . 266
17.3.8 Changed attribute for blipFill element (Part 1, §20.2.2.1) . 266
17.3.9 Changed attribute for cNvPicPr element (Part 1, §20.2.2.2) . 267
17.3.10 Changed attribute for cNvPr element (Part 1, §20.2.2.3) . 267
17.3.11 Changed attribute for spPr element (Part 1, §20.2.2.6) . 269
17.3.12 Changed attribute for docPr element (Part 1, §20.4.2.5) . 269
17.3.13 Changed attribute for extent element (Part 1, §20.4.2.7) . 271
17.3.14 Changed attribute for lineTo element (Part 1, §20.4.2.9) . 272
17.3.15 Changed attribute for simplePos element (Part 1, §20.4.2.13) . 272
17.3.16 Changed attribute for start element (Part 1, §20.4.2.14) . 273
17.3.17 Changed attribute for blipFill element (Part 1, §20.5.2.2) . 274
17.3.18 Changed attribute for cNvPicPr element (Part 1, §20.5.2.7) . 274
17.3.19 Changed attribute for cNvPr element (Part 1, §20.5.2.8) . 275
17.3.20 Changed attribute for cNvSpPr element (Part 1, §20.5.2.9) . 276
17.3.21 Changed attribute for contentPart element (Part 1, §20.5.2.12) . 277
17.3.22 Changed attribute for ext element (Part 1, §20.5.2.14) . 277
17.3.23 Changed attribute for grpSpPr element (Part 1, §20.5.2.18) . 278
17.3.24 Changed attribute for pos element (Part 1, §20.5.2.26) .
...