Open Document Format for Office
Applications (OpenDocument)
Version 1.2
Committee Specification Draft 06
2 December 2010
Specification URIs:
This Version:
http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06.odt(Authoritative)
http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06.pdf
http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06.html
Previous Version:
http://docs.oasis-open.org/office/v1.2/cd05/OpenDocument-v1.2-cd05.odt (Authoritative)
http://docs.oasis-open.org/office/v1.2/cd05/OpenDocument-v1.2-cd05.pdf
http://docs.oasis-open.org/office/v1.2/cd05/OpenDocument-v1.2-cd05.html
Latest Version:
http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2.odt
http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2.pdf
http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2.html
Technical Committee:
OASIS Open Document Format for Office Applications (OpenDocument) TC
Chairs:Rob Weir, IBM
Michael Brauer, Oracle Corporation
Editors:
Patrick Durusau <patrick@durusau.net>
Michael Brauer, Oracle Corporation <michael.brauer@sun.com>
Related Work:
This specification supersedes OASIS OpenDocument v1.1 [ODF11].
This specification consists of this document as well as the following documents,
schemas and ontologies:

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 1 of 104

OpenDocument v1.2 part 1: OpenDocument Schema
OpenDocument v1.2 part 2: Recalculated Formula (OpenFormula) Format
OpenDocument v1.2 part 3: Packages
OpenDocument v1.2 Relax NG Schema
OpenDocument v1.2 Manifest Schema
OpenDocument v1.2 Digital Signature Schema
OpenDocument v1.2 Metadata Manifest Ontology
OpenDocument v1.2 Package Metadata Manifest Ontology
Declared XML Namespaces:
urn:oasis:names:tc:opendocument:xmlns:animation:1.0
urn:oasis:names:tc:opendocument:xmlns:chart:1.0
urn:oasis:names:tc:opendocument:xmlns:config:1.0
urn:oasis:names:tc:opendocument:xmlns:database:1.0
urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0
urn:oasis:names:tc:opendocument:xmlns:drawing:1.0
urn:oasis:names:tc:opendocument:xmlns:form:1.0
urn:oasis:names:tc:opendocument:xmlns:manifest:1.0
urn:oasis:names:tc:opendocument:xmlns:meta:1.0
urn:oasis:names:tc:opendocument:xmlns:data style:1.0
urn:oasis:names:tc:opendocument:xmlns:office:1.0
urn:oasis:names:tc:opendocument:xmlns:presentation:1.0
urn:oasis:names:tc:opendocument:xmlns:script:1.0
urn:oasis:names:tc:opendocument:xmlns:table:1.0
urn:oasis:names:tc:opendocument:xmlns:text:1.0
urn:oasis:names:tc:opendocument:xmlns:style:1.0
urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0
urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0
urn:oasis:names:tc:opendocument:xmlns:smil-compatible:1.0
urn:oasis:names:tc:opendocument:xmlns:of:1.2
http://docs.oasis-open.org/ns/office/1.2/meta/odf#
urn:oasis:names:tc:opendocument:xmlns:manifest:1.0
urn:oasis:names:tc:opendocument:xmlns:digitalsignature:1.0
http://docs.oasis-open.org/ns/office/1.2/meta/pkg#
Abstract:
This specification consists of this document as well as the following three parts:
Part 1 defines an XML schema for office applications and its semantics. The schema issuitable for office documents, including text documents, spreadsheets, charts andgraphical documents like drawings or presentations, but is not restricted to these kindsof documents.
Part 2 defines a formula language to be used in OpenDocument documents.
Part 3 defines a package format to be used for OpenDocument documents.
Status:This document was last revised or approved by the OASIS Open Document Format for
Office Applications (OpenDocument) Technical Committee on the above date. The levelof approval is also listed above. Check the current location noted above for possible
later revisions of this document. This document is updated periodically on no particularschedule.
Technical Committee members should send comments on this specification to theTechnical Committee's email list. Others should send comments to the TechnicalCommittee by using the "Send A Comment" button on the Technical Committee's web
page at www.oasis-open.org/committees/office.

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 2 of 104

For information on whether any patents have been disclosed that may be essential to
implementing this specification, and any offers of patent licensing terms, please refer tothe Intellectual Property Rights section of the Technical Committee web page(www.oasis-open.org/committees/office/ipr.php.)
Citation Format:
When referencing this specification the following citation format should be used:
OpenDocument-v1.2
OASIS Committee Specification Draft 06, Open Document
Format for Office Applications (OpenDocument) Version 1.2, December
2010 http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2csd06.odt

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 3 of 104

Notices
Copyright © OASIS® 2002–2010. All Rights Reserved.
All capitalized terms in the following text have the meanings assigned to them in the OASISIntellectual Property Rights Policy (the "OASIS IPR Policy"). The full Policy may be found at the
OASIS website.
This document and translations of it may be copied and furnished to others, and derivative works
that comment on or otherwise explain it or assist in its implementation may be prepared, copied,
published, and distributed, in whole or in part, without restriction of any kind, provided that theabove copyright notice and this section are included on all such copies and derivative works.
However, this document itself may not be modified in any way, including by removing the
copyright notice or references to OASIS, except as needed for the purpose of developing any
document or deliverable produced by an OASIS Technical Committee (in which case the rules
applicable to copyrights, as set forth in the OASIS IPR Policy, must be followed) or as required totranslate it into languages other than English.
The limited permissions granted above are perpetual and will not be revoked by OASIS or its
successors or assigns.
This document and the information contained herein is provided on an "AS IS" basis and OASISDISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO
ANY WARRANTY THAT THE USE OF THE INFORMATION HEREIN WILL NOT INFRINGE ANY
OWNERSHIP RIGHTS OR ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESSFOR A PARTICULAR PURPOSE.
OASIS requests that any OASIS Party or any other party that believes it has patent claims thatwould necessarily be infringed by implementations of this OASIS Committee Specification or
OASIS Standard, to notify OASIS TC Administrator and provide an indication of its willingness togrant patent licenses to such patent claims in a manner consistent with the IPR Mode of the
OASIS Technical Committee that produced this specification.
OASIS invites any party to contact the OASIS TC Administrator if it is aware of a claim ofownership of any patent claims that would necessarily be infringed by implementations of thisspecification by a patent holder that is not willing to provide a license to such patent claims in amanner consistent with the IPR Mode of the OASIS Technical Committee that produced thisspecification. OASIS may include such claims on its website, but disclaims any obligation to doso.
OASIS takes no position regarding the validity or scope of any intellectual property or otherrights that might be claimed to pertain to the implementation or use of the technology describedin this document or the extent to which any license under such rights might or might not be
available; neither does it represent that it has made any effort to identify any such rights.
Information on OASIS' procedures with respect to rights in any document or deliverable
produced by an OASIS Technical Committee can be found on the OASIS website. Copies ofclaims of rights made available for publication and any assurances of licenses to be madeavailable, or the result of an attempt made to obtain a general license or permission for the useof such proprietary rights by implementers or users of this OASIS Committee Specification or
OASIS Standard, can be obtained from the OASIS TC Administrator. OASIS makes norepresentation that any information or list of intellectual property rights will at any time becomplete, or that any claims in such list are, in fact, Essential Claims.
The names "OASIS", “OpenDocument”, “Open Document Format” and “ODF” are trademarks of
OASIS, the owner and developer of this specification, and should be used only to refer to theorganization and its official outputs. OASIS welcomes reference to, and implementation and use
OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 4 of 104

of, specifications, while reserving the right to enforce its marks against misleading uses. Pleasesee http://www.oasis-open.org/who/trademark.php for above guidance.

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 5 of 104

Table of Contents
1 Introduction................................................................................................................................ 98
1.1 Scope................................................................................................................................. 98
1.2 Terminology........................................................................................................................ 98
1.3 Normative References........................................................................................................ 98
1.4 Non Normative References................................................................................................ 99
2 Conformance........................................................................................................................... 100
Appendix A. Changes From Previous Specification Versions (Non Normative).........................102
A.1. Changes from “Open Document Format for Office Applications (OpenDocument) v1.1”....102
Appendix B. Acknowledgments (Non Normative).......................................................................103

Table of Contents Part 1
1 Introduction................................................................................................................................ 79
1.1 Introduction......................................................................................................................... 79
1.2 Terminology........................................................................................................................ 79
1.3 Normative References........................................................................................................ 79
1.4 Non Normative References................................................................................................ 82
1.5 Namespaces....................................................................................................................... 82
2 OpenDocument Documents, Consumers and Producers..........................................................85
2.1 Introduction......................................................................................................................... 85
2.2 Documents.......................................................................................................................... 85
2.2.1 OpenDocument Document.......................................................................................... 85
2.2.2 OpenDocument Extended Document..........................................................................86
2.2.3 OpenDocument Text Document...................................................................................86
2.2.4 OpenDocument Spreadsheet Document.....................................................................87
2.2.5 OpenDocument Drawing Document............................................................................87
2.2.6 OpenDocument Presentation Document.....................................................................87
2.2.7 OpenDocument Chart Document................................................................................87
2.2.8 OpenDocument Image Document...............................................................................88
2.2.9 OpenDocument Formula Document............................................................................88
2.2.10 OpenDocument Database Front End Document.......................................................88
2.3 Producers........................................................................................................................... 88
2.3.1 OpenDocument Producer............................................................................................ 88
2.3.2 OpenDocument Extended Producer............................................................................89

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 6 of 104

2.4 Consumer........................................................................................................................... 89
3 Document Structure................................................................................................................... 90
3.1 Document Representation ................................................................................................. 90
3.1.1 General....................................................................................................................... 90
3.1.2 <office:document>(Single OpenDocument XML Files)................................................90
3.1.3 Package OpenDocument Files....................................................................................90
3.1.3.1 General................................................................................................................................. 90
3.1.3.2 <office:document-content>...................................................................................................90
3.1.3.3 <office:document-styles>......................................................................................................91
3.1.3.4 <office:document-meta>.......................................................................................................91
3.1.3.5 <office:document-settings>..................................................................................................91

3.1.4 Summary of Document Representation.......................................................................91
3.2 <office:meta>...................................................................................................................... 92
3.3 <office:body>...................................................................................................................... 92
3.4 <office:text>........................................................................................................................ 93
3.5 <office:drawing>................................................................................................................. 93
3.6 <office:presentation>.......................................................................................................... 93
3.7 <office:spreadsheet>.......................................................................................................... 94
3.8 <office:chart>...................................................................................................................... 94
3.9 <office:image>.................................................................................................................... 94
3.10 <office:settings>............................................................................................................... 95
3.10.1 General..................................................................................................................... 95
3.10.2 <config:config-item-set>............................................................................................ 95
3.10.3 <config:config-item>.................................................................................................. 95
3.10.4 <config:config-item-map-indexed>............................................................................96
3.10.5 <config:config-item-map-entry>.................................................................................96
3.10.6 <config:config-item-map-named>..............................................................................96
3.11 Cursor Position Setting..................................................................................................... 96
3.12 <office:scripts>................................................................................................................. 97
3.13 <office:script>................................................................................................................... 97
3.14 <office:font-face-decls>.................................................................................................... 97
3.15 Styles................................................................................................................................ 97
3.15.1 General..................................................................................................................... 97
3.15.2 <office:styles>........................................................................................................... 98
3.15.3 <office:automatic-styles>........................................................................................... 98
3.15.4 <office:master-styles>............................................................................................... 98
3.16 Document Signatures....................................................................................................... 99

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 7 of 104

3.17 Foreign Elements and Attributes......................................................................................99
3.18 White Space Processing and EOL Handling..................................................................100
3.19 MIME Types and File Name Extensions.........................................................................100
4 Metadata.................................................................................................................................. 101
4.1 General............................................................................................................................. 101
4.2 RDF Metadata.................................................................................................................. 101
4.2.1 In Content Metadata (RDFa).....................................................................................101
4.2.2 manifest.rdf................................................................................................................ 101
4.2.2.1 General............................................................................................................................... 101
4.2.2.2 odf:ContentFile................................................................................................................... 101
4.2.2.3 odf:StylesFile...................................................................................................................... 102
4.2.2.4 odf:Element........................................................................................................................ 102
4.2.2.5 odf:prefix............................................................................................................................. 102
4.2.2.6 odf:suffix............................................................................................................................. 102

4.3 Non-RDF Metadata.......................................................................................................... 102
4.3.1 General..................................................................................................................... 102
4.3.2 Pre-Defined Metadata Elements...............................................................................103
4.3.2.1 <meta:generator>...............................................................................................................103
4.3.2.2 <dc:title>............................................................................................................................. 103
4.3.2.3 <dc:description>................................................................................................................. 103
4.3.2.4 <dc:subject>....................................................................................................................... 104
4.3.2.5 <meta:keyword>................................................................................................................. 104
4.3.2.6 <meta:initial-creator>..........................................................................................................104
4.3.2.7 <dc:creator>....................................................................................................................... 104
4.3.2.8 <meta:printed-by>...............................................................................................................104
4.3.2.9 <meta:creation-date>.........................................................................................................105
4.3.2.10 <dc:date>.......................................................................................................................... 105
4.3.2.11 <meta:print-date>.............................................................................................................105
4.3.2.12 <meta:template>...............................................................................................................105
4.3.2.13 <meta:auto-reload>..........................................................................................................106
4.3.2.14 <meta:hyperlink-behaviour>.............................................................................................106
4.3.2.15 <dc:language>.................................................................................................................. 106
4.3.2.16 <meta:editing-cycles>.......................................................................................................106
4.3.2.17 <meta:editing-duration>....................................................................................................107
4.3.2.18 <meta:document-statistic>...............................................................................................107

4.3.3 <meta:user-defined>................................................................................................. 107
5 Text Content............................................................................................................................. 108
5.1 Headings, Paragraphs and Basic Text Structure..............................................................108
5.1.1 General..................................................................................................................... 108

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 8 of 104

5.1.2 <text:h>..................................................................................................................... 108
5.1.3 <text:p>..................................................................................................................... 109
5.2 <text:page-sequence>...................................................................................................... 111
5.2.1 General...................................................................................................................... 111
5.2.2 <text:page>................................................................................................................ 111
5.3 Lists................................................................................................................................... 111
5.3.1 <text:list>................................................................................................................... 111
5.3.2 Default List Style ...................................................................................................... 112
5.3.3 <text:list-header>....................................................................................................... 112
5.3.4 <text:list-item>........................................................................................................... 112
5.3.5 List Item Style Rules.................................................................................................. 113
5.3.6 <text:numbered-paragraph>......................................................................................113
5.3.7 Numbered Paragraph Style Rules.............................................................................113
5.4 <text:section>.................................................................................................................... 114
5.4.1 General...................................................................................................................... 114
5.4.2 <text:section-source>................................................................................................ 115
5.5 Change Tracking............................................................................................................... 115
5.5.1 <text:tracked-changes>............................................................................................. 115
5.5.2 <text:changed-region>............................................................................................... 115
5.5.3 <text:insertion>.......................................................................................................... 116
5.5.4 <text:deletion>........................................................................................................... 116
5.5.5 <text:format-change>................................................................................................. 117
5.5.6 <office:change-info>.................................................................................................. 117
5.5.7 Change Marks........................................................................................................... 117
5.5.7.1 General............................................................................................................................... 117
5.5.7.2 <text:change-start>.............................................................................................................118
5.5.7.3 <text:change-end>..............................................................................................................118
5.5.7.4 <text:change>..................................................................................................................... 118

5.6 <text:soft-page-break>...................................................................................................... 118
5.7 Document Declarations..................................................................................................... 119
6 Paragraph Elements Content................................................................................................... 120
6.1 Basic Text Content............................................................................................................ 120
6.1.1 General..................................................................................................................... 120
6.1.2 White Space Characters........................................................................................... 120
6.1.3 <text:s>...................................................................................................................... 121
6.1.4 <text:tab>.................................................................................................................. 121
6.1.5 <text:line-break>....................................................................................................... 121

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 9 of 104

6.1.6 Soft Hyphens, Hyphens, and Non-breaking Spaces.................................................121
6.1.7 <text:span>................................................................................................................ 122
6.1.8 <text:a>..................................................................................................................... 123
6.1.9 <text:meta>................................................................................................................ 124
6.1.10 <text:number>......................................................................................................... 125
6.2 Bookmarks and References............................................................................................. 126
6.2.1 Bookmarks................................................................................................................ 126
6.2.1.1 General............................................................................................................................... 126
6.2.1.2 <text:bookmark>................................................................................................................. 126
6.2.1.3 <text:bookmark-start>.........................................................................................................126
6.2.1.4 <text:bookmark-end>..........................................................................................................126

6.2.2 References................................................................................................................ 127
6.2.2.1 General............................................................................................................................... 127
6.2.2.2 <text:reference-mark>........................................................................................................127
6.2.2.3 <text:reference-mark-start>................................................................................................127
6.2.2.4 <text:reference-mark-end>.................................................................................................128

6.3 Notes................................................................................................................................ 128
6.3.1 General..................................................................................................................... 128
6.3.2 <text:note>................................................................................................................ 128
6.3.3 <text:note-citation>.................................................................................................... 128
6.3.4 <text:note-body>....................................................................................................... 128
6.4 <text:ruby>........................................................................................................................ 129
6.4.1 General..................................................................................................................... 129
6.4.2 <text:ruby-base>....................................................................................................... 129
6.4.3 <text:ruby-text>......................................................................................................... 130
7 Text Fields................................................................................................................................ 132
7.1 General............................................................................................................................. 132
7.2 Common Characteristics of Field Elements......................................................................132
7.3 Document Fields............................................................................................................... 132
7.3.1 General..................................................................................................................... 132
7.3.2 <text:date>................................................................................................................ 132
7.3.3 <text:time>................................................................................................................. 133
7.3.4 <text:page-number>.................................................................................................. 133
7.3.5 <text:page-continuation>........................................................................................... 133
7.3.6 Subsequent Author Fields......................................................................................... 134
7.3.6.1 General............................................................................................................................... 134
7.3.6.2 <text:sender-firstname>......................................................................................................134
7.3.6.3 <text:sender-lastname>......................................................................................................134

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 10 of 104

7.3.6.4 <text:sender-initials>..........................................................................................................134
7.3.6.5 <text:sender-title>...............................................................................................................135
7.3.6.6 <text:sender-position>........................................................................................................135
7.3.6.7 <text:sender-email>............................................................................................................135
7.3.6.8 <text:sender-phone-private>..............................................................................................135
7.3.6.9 <text:sender-fax>................................................................................................................136
7.3.6.10 <text:sender-company>....................................................................................................136
7.3.6.11 <text:sender-phone-work>................................................................................................136
7.3.6.12 <text:sender-street>.........................................................................................................136
7.3.6.13 <text:sender-city>.............................................................................................................137
7.3.6.14 <text:sender-postal-code>................................................................................................137
7.3.6.15 <text:sender-country>.......................................................................................................137
7.3.6.16 <text:sender-state-or-province>.......................................................................................137

7.3.7 Author Fields............................................................................................................. 138
7.3.7.1 <text:author-name>............................................................................................................138
7.3.7.2 <text:author-initials>...........................................................................................................138

7.3.8 <text:chapter>........................................................................................................... 138
7.3.9 <text:file-name>......................................................................................................... 139
7.3.10 <text:template-name>.............................................................................................. 139
7.3.11 <text:sheet-name>................................................................................................... 139
7.4 Variable Fields.................................................................................................................. 140
7.4.1 General..................................................................................................................... 140
7.4.2 <text:variable-decls>................................................................................................. 140
7.4.3 <text:variable-decl>................................................................................................... 141
7.4.4 <text:variable-set>..................................................................................................... 141
7.4.5 <text:variable-get>.................................................................................................... 141
7.4.6 <text:variable-input>.................................................................................................. 141
7.4.7 <text:user-field-decls>............................................................................................... 142
7.4.8 <text:user-field-decl>................................................................................................. 142
7.4.9 <text:user-field-get>.................................................................................................. 142
7.4.10 <text:user-field-input>............................................................................................. 143
7.4.11 <text:sequence-decls>............................................................................................ 143
7.4.12 <text:sequence-decl>.............................................................................................. 143
7.4.13 <text:sequence>...................................................................................................... 144
7.4.14 <text:expression>.................................................................................................... 144
7.4.15 <text:text-input>....................................................................................................... 144
7.5 Metadata Fields................................................................................................................ 145
7.5.1 General..................................................................................................................... 145

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 11 of 104

7.5.2 <text:initial-creator>................................................................................................... 145
7.5.3 <text:creation-date>.................................................................................................. 145
7.5.4 <text:creation-time>................................................................................................... 145
7.5.5 <text:description>...................................................................................................... 146
7.5.6 <text:user-defined>................................................................................................... 146
7.5.7 <text:print-time>........................................................................................................ 146
7.5.8 <text:print-date>........................................................................................................ 146
7.5.9 <text:printed-by>....................................................................................................... 147
7.5.10 <text:title>................................................................................................................ 147
7.5.11 <text:subject>.......................................................................................................... 147
7.5.12 <text:keywords>...................................................................................................... 148
7.5.13 <text:editing-cycles>............................................................................................... 148
7.5.14 <text:editing-duration>............................................................................................ 148
7.5.15 <text:modification-time>.......................................................................................... 148
7.5.16 <text:modification-date>.......................................................................................... 149
7.5.17 <text:creator>.......................................................................................................... 149
7.5.18 Document Statistics Fields......................................................................................149
7.5.18.1 General............................................................................................................................. 149
7.5.18.2 <text:page-count>.............................................................................................................149
7.5.18.3 <text:paragraph-count>....................................................................................................150
7.5.18.4 <text:word-count>.............................................................................................................150
7.5.18.5 <text:character-count>......................................................................................................150
7.5.18.6 <text:table-count>.............................................................................................................151
7.5.18.7 <text:image-count>...........................................................................................................151
7.5.18.8 <text:object-count>...........................................................................................................151

7.5.19 <text:meta-field>...................................................................................................... 151
7.6 Database Fields............................................................................................................... 153
7.6.1 General..................................................................................................................... 153
7.6.2 <form:connection-resource>.....................................................................................153
7.6.3 <text:database-display>............................................................................................ 153
7.6.4 <text:database-next>................................................................................................. 154
7.6.5 <text:database-row-select>.......................................................................................154
7.6.6 <text:database-row-number>....................................................................................154
7.6.7 <text:database-name>............................................................................................... 155
7.7 More Fields....................................................................................................................... 155
7.7.1 Page Variable Fields................................................................................................. 155
7.7.1.1 General............................................................................................................................... 155
7.7.1.2 <text:page-variable-set>.....................................................................................................155

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 12 of 104

7.7.1.3 <text:page-variable-get>.....................................................................................................156

7.7.2 <text:placeholder>..................................................................................................... 156
7.7.3 <text:conditional-text>............................................................................................... 156
7.7.4 <text:hidden-text>...................................................................................................... 157
7.7.5 <text:reference-ref> .................................................................................................. 157
7.7.6 <text:bookmark-ref>.................................................................................................. 157
7.7.7 <text:note-ref>........................................................................................................... 157
7.7.8 <text:sequence-ref>.................................................................................................. 158
7.7.9 <text:script>............................................................................................................... 158
7.7.10 <text:execute-macro>.............................................................................................. 159
7.7.11 <text:hidden-paragraph>......................................................................................... 159
7.7.12 <text:dde-connection>............................................................................................. 159
7.7.13 <text:measure>........................................................................................................ 160
7.7.14 <text:table-formula> (deprecated)...........................................................................160
8 Text Indexes............................................................................................................................. 161
8.1 Index Marks...................................................................................................................... 161
8.1.1 General..................................................................................................................... 161
8.1.2 <text:toc-mark-start>................................................................................................. 161
8.1.3 <text:toc-mark-end>.................................................................................................. 161
8.1.4 <text:toc-mark>.......................................................................................................... 162
8.1.5 <text:user-index-mark-start>.....................................................................................162
8.1.6 <text:user-index-mark-end>......................................................................................162
8.1.7 <text:user-index-mark>.............................................................................................. 162
8.1.8 <text:alphabetical-index-mark-start>.........................................................................163
8.1.9 <text:alphabetical-index-mark-end>..........................................................................163
8.1.10 <text:alphabetical-index-mark>...............................................................................163
8.1.11 <text:bibliography-mark>......................................................................................... 164
8.2 Index Structure................................................................................................................. 164
8.2.1 General..................................................................................................................... 164
8.2.2 <text:index-body>...................................................................................................... 164
8.2.3 <text:index-title>........................................................................................................ 165
8.3 <text:table-of-content>...................................................................................................... 165
8.3.1 General..................................................................................................................... 165
8.3.2 <text:table-of-content-source>..................................................................................166
8.3.3 <text:table-of-content-entry-template>......................................................................166
8.4 <text:illustration-index>.................................................................................................... 166
8.4.1 General..................................................................................................................... 166

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 13 of 104

8.4.2 <text:illustration-index-source>.................................................................................167
8.4.3 <text:illustration-index-entry-template>.....................................................................167
8.5 <text:table-index>............................................................................................................. 167
8.5.1 General..................................................................................................................... 167
8.5.2 <text:table-index-source>.......................................................................................... 168
8.5.3 <text:table-index-entry-template>..............................................................................168
8.6 <text:object-index>........................................................................................................... 168
8.6.1 General..................................................................................................................... 168
8.6.2 <text:object-index-source>........................................................................................ 169
8.6.3 <text:object-index-entry-template>............................................................................169
8.7 <text:user-index>.............................................................................................................. 169
8.7.1 General..................................................................................................................... 169
8.7.2 <text:user-index-source>........................................................................................... 170
8.7.3 <text:user-index-entry-template>..............................................................................170
8.8 <text:alphabetical-index>.................................................................................................. 170
8.8.1 General..................................................................................................................... 170
8.8.2 <text:alphabetical-index-source>..............................................................................171
8.8.3 <text:alphabetical-index-auto-mark-file>...................................................................171
8.8.4 <text:alphabetical-index-entry-template>..................................................................172
8.9 <text:bibliography>........................................................................................................... 172
8.9.1 General..................................................................................................................... 172
8.9.2 <text:bibliography-source>........................................................................................ 172
8.9.3 <text:bibliography-entry-template>............................................................................172
8.10 <text:index-source-styles>.............................................................................................. 173
8.11 <text:index-source-style>................................................................................................ 173
8.12 <text:index-title-template>.............................................................................................. 173
8.13 Index Template Entries................................................................................................... 174
8.13.1 <text:index-entry-chapter>......................................................................................174
8.13.2 <text:index-entry-text>............................................................................................. 174
8.13.3 <text:index-entry-page-number>.............................................................................174
8.13.4 <text:index-entry-span>........................................................................................... 175
8.13.5 <text:index-entry-bibliography>...............................................................................175
8.13.6 <text:index-entry-tab-stop>.....................................................................................175
8.13.7 <text:index-entry-link-start>.....................................................................................175
8.13.8 <text:index-entry-link-end>......................................................................................176
9 Tables...................................................................................................................................... 177
9.1 Basic Tables..................................................................................................................... 177

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 14 of 104

9.1.1 General..................................................................................................................... 177
9.1.2 <table:table>............................................................................................................. 177
9.1.3 <table:table-row>...................................................................................................... 178
9.1.4 <table:table-cell>....................................................................................................... 178
9.1.5 <table:covered-table-cell>......................................................................................... 178
9.1.6 <table:table-column>................................................................................................. 179
9.1.7 <table:table-header-rows>........................................................................................ 179
9.1.8 <table:table-rows>..................................................................................................... 180
9.1.9 <table:table-row-group>............................................................................................ 180
9.1.10 <table:table-column-group>....................................................................................180
9.1.11 <table:table-header-columns>.................................................................................181
9.1.12 <table:table-columns>............................................................................................. 181
9.1.13 <table:title>.............................................................................................................. 181
9.1.14 <table:desc>............................................................................................................ 182
9.2 Advanced Tables.............................................................................................................. 182
9.2.1 Referencing Table Cells............................................................................................ 182
9.2.2 Absolute and relative cell addressing........................................................................183
9.2.3 Cell Range Address.................................................................................................. 183
9.2.4 Column and Row Range Addresses..........................................................................183
9.2.5 Cell Range Address List............................................................................................ 183
9.2.6 <table:table-source>................................................................................................. 183
9.2.7 <table:scenario>........................................................................................................ 184
9.2.8 <table:shapes>.......................................................................................................... 184
9.3 Advanced Table Cells....................................................................................................... 185
9.3.1 <table:cell-range-source>......................................................................................... 185
9.3.2 <table:detective>....................................................................................................... 185
9.3.3 <table:operation>...................................................................................................... 185
9.3.4 <table:highlighted-range>......................................................................................... 185
9.4 Spreadsheet Document Content......................................................................................186
9.4.1 <table:calculation-settings>......................................................................................186
9.4.2 <table:null-date>....................................................................................................... 186
9.4.3 <table:iteration>........................................................................................................ 186
9.4.4 <table:content-validations>.......................................................................................1879.4.5 <table:content-validation>......................................................................................... 187
9.4.6 <table:help-message>............................................................................................... 187
9.4.7 <table:error-message>.............................................................................................. 188
9.4.8 <table:error-macro>................................................................................................... 188

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 15 of 104

9.4.9 <table:label-range>................................................................................................... 188
9.4.10 <table:label-ranges>............................................................................................... 189
9.4.11 <table:named-expressions>....................................................................................189
9.4.12 <table:named-range>.............................................................................................. 189
9.4.13 <table:named-expression>......................................................................................189
9.4.14 <table:database-ranges>........................................................................................ 190
9.4.15 <table:database-range>.......................................................................................... 190
9.4.16 <table:database-source-sql>...................................................................................190
9.4.17 <table:database-source-table>...............................................................................191
9.4.18 <table:database-source-query>..............................................................................191
9.4.19 <table:sort>............................................................................................................. 191
9.4.20 <table:sort-by>........................................................................................................ 191
9.4.21 <table:subtotal-rules>.............................................................................................. 192
9.4.22 <table:sort-groups>................................................................................................. 192
9.4.23 <table:subtotal-rule>............................................................................................... 192
9.4.24 <table:subtotal-field>............................................................................................... 192
9.5 Filters................................................................................................................................ 193
9.5.1 General..................................................................................................................... 193
9.5.2 <table:filter>.............................................................................................................. 193
9.5.3 <table:filter-and>....................................................................................................... 193
9.5.4 <table:filter-or>.......................................................................................................... 193
9.5.5 <table:filter-condition>............................................................................................... 193
9.5.6 <table:filter-set-item>................................................................................................ 194
9.6 Data Pilot Tables............................................................................................................... 194
9.6.1 General..................................................................................................................... 194
9.6.2 <table:data-pilot-tables>........................................................................................... 195
9.6.3 <table:data-pilot-table>............................................................................................. 195
9.6.4 Data Pilot Table Source............................................................................................. 195
9.6.5 <table:source-cell-range>......................................................................................... 195
9.6.6 <table:source-service>.............................................................................................. 196
9.6.7 <table:data-pilot-field>.............................................................................................. 196
9.6.8 <table:data-pilot-level>.............................................................................................. 196
9.6.9 <table:data-pilot-subtotals>.......................................................................................197
9.6.10 <table:data-pilot-subtotal>......................................................................................197
9.6.11 <table:data-pilot-members>.....................................................................................197
9.6.12 <table:data-pilot-member>......................................................................................197
9.6.13 <table:data-pilot-display-info>.................................................................................198

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 16 of 104

9.6.14 <table:data-pilot-sort-info>......................................................................................198
9.6.15 <table:data-pilot-layout-info>..................................................................................198
9.6.16 <table:data-pilot-field-reference>............................................................................198
9.6.17 <table:data-pilot-groups>........................................................................................ 199
9.6.18 <table:data-pilot-group>.......................................................................................... 199
9.6.19 <table:data-pilot-group-member>............................................................................199
9.7 <table:consolidation>....................................................................................................... 199
9.8 <table:dde-links>.............................................................................................................. 200
9.9 Change Tracking in Spreadsheets...................................................................................200
9.9.1 General .................................................................................................................... 200
9.9.2 <table:tracked-changes>........................................................................................... 200
9.9.3 <table:insertion>........................................................................................................ 200
9.9.4 <table:dependencies>............................................................................................... 201
9.9.5 <table:dependency>.................................................................................................. 201
9.9.6 <table:deletions>....................................................................................................... 201
9.9.7 <table:cell-content-deletion>.....................................................................................201
9.9.8 <table:change-deletion>............................................................................................ 202
9.9.9 <table:deletion>......................................................................................................... 202
9.9.10 <table:cut-offs>........................................................................................................ 202
9.9.11 <table:insertion-cut-off>........................................................................................... 202
9.9.12 <table:movement-cut-off>........................................................................................ 203
9.9.13 <table:movement>................................................................................................... 203
9.9.14 <table:source-range-address>................................................................................2039.9.15 <table:target-range-address>..................................................................................2039.9.16 <table:change-track-table-cell>...............................................................................2049.9.17 <table:cell-content-change>....................................................................................2049.9.18 <table:cell-address>................................................................................................ 204
9.9.19 <table:previous>...................................................................................................... 205
10 Graphic Content..................................................................................................................... 206
10.1 General........................................................................................................................... 206
10.2 Enhanced Page Features for Graphical Applications.....................................................206
10.2.1 <style:handout-master>........................................................................................... 206
10.2.2 <draw:layer-set>...................................................................................................... 206
10.2.3 <draw:layer>............................................................................................................ 207
10.2.4 <draw:page>........................................................................................................... 207
10.2.5 <draw:equation>...................................................................................................... 208
10.3 Drawing Shapes............................................................................................................. 208

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 17 of 104

10.3.1 General................................................................................................................... 208
10.3.2 <draw:rect>............................................................................................................. 208
10.3.3 <draw:line>.............................................................................................................. 208
10.3.4 <draw:polyline>....................................................................................................... 209
10.3.5 <draw:polygon>....................................................................................................... 209
10.3.6 <draw:regular-polygon>.......................................................................................... 210
10.3.7 <draw:path>............................................................................................................. 211
10.3.8 <draw:circle>........................................................................................................... 211
10.3.9 <draw:ellipse>......................................................................................................... 212
10.3.10 <draw:connector>.................................................................................................. 212
10.3.11 <draw:caption>...................................................................................................... 213
10.3.12 <draw:measure>.................................................................................................... 213
10.3.13 <draw:control>....................................................................................................... 214
10.3.14 <draw:page-thumbnail>......................................................................................... 215
10.3.15 <draw:g>............................................................................................................... 215
10.3.16 <draw:glue-point>................................................................................................. 216
10.3.17 <svg:title>.............................................................................................................. 216
10.3.18 <svg:desc>............................................................................................................ 217
10.3.19 <office:event-listeners>......................................................................................... 217
10.4 Frames........................................................................................................................... 217
10.4.1 General................................................................................................................... 217
10.4.2 <draw:frame>.......................................................................................................... 218
10.4.3 <draw:text-box>....................................................................................................... 218
10.4.4 <draw:image>.......................................................................................................... 219
10.4.5 <office:binary-data>................................................................................................ 219
10.4.6 Objects.................................................................................................................... 220
10.4.6.1 General............................................................................................................................. 220
10.4.6.2 <draw:object>................................................................................................................... 220
10.4.6.3 <draw:object-ole>.............................................................................................................22010.4.7 <draw:applet>.......................................................................................................... 221
10.4.8 <draw:plugin>.......................................................................................................... 221
10.4.9 <draw:param>......................................................................................................... 221
10.4.10 <draw:floating-frame>........................................................................................... 222
10.4.11 Contours................................................................................................................ 222
10.4.11.1 General........................................................................................................................... 222
10.4.11.2 <draw:contour-polygon>.................................................................................................222
10.4.11.3 <draw:contour-path>.......................................................................................................222

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 18 of 104

10.4.12 <draw:a>............................................................................................................... 223
10.4.13 Client Side Image Maps........................................................................................ 223
10.4.13.1 General........................................................................................................................... 223
10.4.13.2 <draw:image-map>.........................................................................................................223
10.4.13.3 <draw:area-rectangle>...................................................................................................223
10.4.13.4 <draw:area-circle>..........................................................................................................224
10.4.13.5 <draw:area-polygon>......................................................................................................224

10.5 3D Shapes...................................................................................................................... 225
10.5.1 General................................................................................................................... 225
10.5.2 <dr3d:scene>.......................................................................................................... 225
10.5.3 <dr3d:light>............................................................................................................. 225
10.5.4 <dr3d:cube>............................................................................................................ 226
10.5.5 <dr3d:sphere>......................................................................................................... 226
10.5.6 <dr3d:extrude>........................................................................................................ 226
10.5.7 <dr3d:rotate>........................................................................................................... 226
10.6 Custom Shape................................................................................................................ 227
10.6.1 <draw:custom-shape>............................................................................................. 227
10.6.2 <draw:enhanced-geometry>....................................................................................227
10.6.3 <draw:handle>......................................................................................................... 228
10.7 Presentation Shapes...................................................................................................... 228
10.8 Presentation Animations................................................................................................. 229
10.8.1 <presentation:animations>......................................................................................229
10.8.2 <presentation:sound>............................................................................................. 229
10.8.3 <presentation:show-shape>....................................................................................229
10.8.4 <presentation:show-text>........................................................................................ 230
10.8.5 <presentation:hide-shape>.....................................................................................230
10.8.6 <presentation:hide-text>......................................................................................... 230
10.8.7 <presentation:dim>.................................................................................................. 230
10.8.8 <presentation:play>................................................................................................. 231
10.8.9 <presentation:animation-group>.............................................................................231
10.9 SMIL Presentation Animations........................................................................................ 231
10.9.1 General................................................................................................................... 231
10.9.2 <presentation:event-listener> .................................................................................232
10.9.3 Presentation Document Content.............................................................................232
10.9.3.1 <presentation:header>.....................................................................................................232
10.9.3.2 <presentation:header-decl>..............................................................................................232
10.9.3.3 <presentation:footer>.......................................................................................................232
10.9.3.4 <presentation:footer-decl>................................................................................................233

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 19 of 104

10.9.3.5 <presentation:date-time>..................................................................................................233
10.9.3.6 <presentation:date-time-decl>..........................................................................................233
10.9.3.7 <presentation:settings>....................................................................................................234
10.9.3.8 <presentation:show>........................................................................................................234

11 Chart Content......................................................................................................................... 235
11.1 <chart:chart>................................................................................................................... 235
11.2 Title, Subtitle and Footer................................................................................................. 235
11.2.1 <chart:title>.............................................................................................................. 235
11.2.2 <chart:subtitle>........................................................................................................ 235
11.2.3 <chart:footer>.......................................................................................................... 236
11.3 <chart:legend>................................................................................................................ 236
11.4 <chart:plot-area>............................................................................................................ 237
11.5 3D Plot Area.................................................................................................................... 237
11.6 <chart:wall>.................................................................................................................... 237
11.7 <chart:floor>.................................................................................................................... 237
11.8 <chart:axis>.................................................................................................................... 238
11.9 <chart:categories>.......................................................................................................... 238
11.10 <chart:grid>................................................................................................................... 238
11.11 <chart:series>............................................................................................................... 238
11.12 <chart:domain>............................................................................................................. 239
11.13 <chart:data-point>......................................................................................................... 239
11.14 <chart:data-label>......................................................................................................... 239
11.15 <chart:mean-value>...................................................................................................... 240
11.16 <chart:error-indicator>.................................................................................................. 240
11.17 <chart:regression-curve>.............................................................................................. 240
11.18 <chart:equation>........................................................................................................... 240
11.19 <chart:stock-gain-marker>............................................................................................ 241
11.20 <chart:stock-loss-marker>............................................................................................ 241
11.21 <chart:stock-range-line>............................................................................................... 241
12 Database Front-end Document Content................................................................................242
12.1 <office:database>........................................................................................................... 242
12.2 <db:data-source>........................................................................................................... 242
12.3 <db:connection-data>..................................................................................................... 242
12.4 <db:database-description>............................................................................................. 242
12.5 <db:file-based-database>............................................................................................... 243
12.6 <db:server-database>.................................................................................................... 243
12.7 <db:connection-resource>.............................................................................................. 243

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 20 of 104

12.8 <db:login>....................................................................................................................... 243
12.9 <db:driver-settings>........................................................................................................ 244
12.10 <db:auto-increment>.................................................................................................... 244
12.11 <db:delimiter>............................................................................................................... 244
12.12 <db:character-set>....................................................................................................... 244
12.13 <db:table-settings>....................................................................................................... 245
12.14 <db:table-setting>......................................................................................................... 245
12.15 <db:application-connection-settings>...........................................................................245
12.16 <db:table-filter>............................................................................................................ 245
12.17 <db:table-include-filter>................................................................................................ 246
12.18 <db:table-exclude-filter>............................................................................................... 246
12.19 <db:table-filter-pattern>................................................................................................ 246
12.20 <db:table-type-filter>.................................................................................................... 246
12.21 <db:table-type>............................................................................................................. 247
12.22 <db:data-source-settings>............................................................................................ 247
12.23 <db:data-source-setting>.............................................................................................. 247
12.24 <db:data-source-setting-value>....................................................................................247
12.25 Forms and Reports....................................................................................................... 248
12.25.1 General................................................................................................................. 248
12.25.2 <db:forms>............................................................................................................ 248
12.25.3 <db:reports>.......................................................................................................... 248
12.25.4 <db:component-collection>...................................................................................248
12.25.5 <db:component>................................................................................................... 249
12.26 <db:queries>................................................................................................................. 249
12.27 <db:query-collection>................................................................................................... 249
12.28 <db:query>................................................................................................................... 249
12.29 <db:order-statement>................................................................................................... 250
12.30 <db:filter-statement>..................................................................................................... 250
12.31 <db:update-table>........................................................................................................ 250
12.32 <db:table-representations>.......................................................................................... 250
12.33 <db:table-representation>............................................................................................ 251
12.34 <db:columns>............................................................................................................... 251
12.35 <db:column>................................................................................................................. 251
12.36 <db:schema-definition>................................................................................................ 251
12.37 <db:table-definitions>................................................................................................... 252
12.38 <db:table-definition>..................................................................................................... 252
12.39 <db:column-definitions>............................................................................................... 252

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 21 of 104

12.40 <db:column-definition>................................................................................................. 252
12.41 <db:keys>..................................................................................................................... 253
12.42 <db:key>....................................................................................................................... 253
12.43 <db:key-columns>........................................................................................................ 253
12.44 <db:key-column>.......................................................................................................... 253
12.45 <db:indices>................................................................................................................. 253
12.46 <db:index>.................................................................................................................... 254
12.47 <db:index-columns>..................................................................................................... 254
12.48 <db:index-column>....................................................................................................... 254
13 Form Content......................................................................................................................... 255
13.1 General........................................................................................................................... 255
13.2 <office:forms>................................................................................................................. 255
13.3 <form:form>.................................................................................................................... 255
13.4 <xforms:model>.............................................................................................................. 256
13.5 Controls.......................................................................................................................... 256
13.5.1 General................................................................................................................... 256
13.5.2 <form:text>.............................................................................................................. 256
13.5.3 <form:textarea>....................................................................................................... 257
13.5.4 <form:password>..................................................................................................... 257
13.5.5 <form:file>............................................................................................................... 257
13.5.6 <form:formatted-text>.............................................................................................. 258
13.5.7 <form:number>........................................................................................................ 258
13.5.8 <form:date>............................................................................................................. 259
13.5.9 <form:time>............................................................................................................. 259
13.5.10 <form:fixed-text>.................................................................................................... 259
13.5.11 <form:combobox>.................................................................................................. 260
13.5.12 <form:item>........................................................................................................... 260
13.5.13 <form:listbox>........................................................................................................ 260
13.5.14 <form:option>........................................................................................................ 260
13.5.15 <form:button>........................................................................................................ 261
13.5.16 <form:image>........................................................................................................ 261
13.5.17 <form:checkbox>................................................................................................... 261
13.5.18 <form:radio>.......................................................................................................... 262
13.5.19 <form:frame>......................................................................................................... 262
13.5.20 <form:image-frame>.............................................................................................. 262
13.5.21 <form:hidden>....................................................................................................... 263
13.5.22 <form:grid>............................................................................................................ 263

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 22 of 104

13.5.23 <form:column>....................................................................................................... 263
13.5.24 <form:value-range>............................................................................................... 264
13.5.25 <form:generic-control>.......................................................................................... 264
13.6 Event Listeners............................................................................................................... 264
13.7 <form:properties>........................................................................................................... 266
13.8 <form:property>.............................................................................................................. 266
13.9 <form:list-property>........................................................................................................ 266
13.10 <form:list-value>........................................................................................................... 267
14 Common Content................................................................................................................... 268
14.1 <office:annotation>......................................................................................................... 268
14.2 <office:annotation-end>.................................................................................................. 268
14.3 <meta:date-string>......................................................................................................... 268
14.4 Event Listener Tables..................................................................................................... 269
14.4.1 General................................................................................................................... 269
14.4.2 <script:event-listener>............................................................................................. 269
14.4.3 Event Types............................................................................................................. 269
14.4.4 Macro Name and Location......................................................................................269
14.5 <math:math>................................................................................................................... 270
14.6 DDE Connections........................................................................................................... 270
14.6.1 General................................................................................................................... 270
14.6.2 <text:dde-connection-decls>...................................................................................270
14.6.3 <text:dde-connection-decl>.....................................................................................270
14.6.4 <table:dde-link>....................................................................................................... 271
14.6.5 <office:dde-source>................................................................................................. 271
15 SMIL Animations.................................................................................................................... 272
15.1 General........................................................................................................................... 272
15.2 Basic Animation Elements.............................................................................................. 272
15.2.1 General .................................................................................................................. 272
15.2.2 <anim:animate>....................................................................................................... 272
15.2.3 <anim:animateTransform>.......................................................................................272
15.2.4 <anim:set>............................................................................................................... 273
15.2.5 <anim:animateMotion>............................................................................................ 273
15.2.6 <anim:animateColor>.............................................................................................. 273
15.2.7 <anim:transitionFilter>............................................................................................. 274
15.3 Animation Model Attributes............................................................................................. 274
15.3.1 General................................................................................................................... 274
15.3.2 Simple Animation Functions....................................................................................274

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 23 of 104

15.4 Animation Timing............................................................................................................ 274
15.4.1 General................................................................................................................... 274
15.4.2 <anim:par>.............................................................................................................. 274
15.4.3 <anim:seq>.............................................................................................................. 275
15.4.4 <anim:iterate>......................................................................................................... 275
15.5 <anim:audio>.................................................................................................................. 276
15.6 Animation Command Elements.......................................................................................276
15.6.1 <anim:command>.................................................................................................... 276
15.6.2 <anim:param>......................................................................................................... 277
16 Styles..................................................................................................................................... 278
16.1 General........................................................................................................................... 278
16.2 <style:style>.................................................................................................................... 278
16.3 <style:map>.................................................................................................................... 279
16.4 <style:default-style>....................................................................................................... 280
16.5 <style:page-layout>........................................................................................................ 280
16.6 <style:header-style>....................................................................................................... 280
16.7 <style:footer-style>......................................................................................................... 280
16.8 <style:default-page-layout>............................................................................................ 281
16.9 <style:master-page>....................................................................................................... 281
16.10 <style:header>.............................................................................................................. 282
16.11 <style:footer>................................................................................................................ 282
16.12 <style:header-left>........................................................................................................ 283
16.13 <style:footer-left>.......................................................................................................... 283
16.14 <style:region-left>......................................................................................................... 283
16.15 <style:region-center>.................................................................................................... 284
16.16 <style:region-right>....................................................................................................... 284
16.17 <presentation:notes>.................................................................................................... 284
16.18 <table:table-template>.................................................................................................. 285
16.19 Cell Styles.................................................................................................................... 285
16.19.1 General................................................................................................................. 285
16.19.2 <table:first-row>.................................................................................................... 285
16.19.3 <table:last-row>..................................................................................................... 286
16.19.4 <table:first-column>............................................................................................... 286
16.19.5 <table:last-column>............................................................................................... 286
16.19.6 <table:body>......................................................................................................... 286
16.19.7 <table:even-rows>................................................................................................. 287
16.19.8 <table:odd-rows>................................................................................................... 287

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 24 of 104

16.19.9 <table:even-columns>........................................................................................... 287
16.19.10 <table:odd-columns>........................................................................................... 287
16.20 <table:background>...................................................................................................... 287
16.21 <style:font-face>........................................................................................................... 288
16.22 <svg:font-face-src>....................................................................................................... 288
16.23 <svg:font-face-name>................................................................................................... 289
16.24 <svg:font-face-uri>........................................................................................................ 289
16.25 <svg:definition-src>...................................................................................................... 289
16.26 <svg:font-face-format>.................................................................................................. 289
16.27 Data Styles................................................................................................................... 290
16.27.1 General................................................................................................................. 290
16.27.2 <number:number-style>........................................................................................ 290
16.27.3 <number:number>................................................................................................. 290
16.27.4 <number:embedded-text>.....................................................................................290
16.27.5 <number:scientific-number>..................................................................................291
16.27.6 <number:fraction>................................................................................................. 291
16.27.7 <number:currency-style>.......................................................................................291
16.27.8 <number:currency-symbol>...................................................................................291
16.27.9 <number:percentage-style>..................................................................................292
16.27.10 <number:date-style>........................................................................................... 292
16.27.11 <number:day>...................................................................................................... 293
16.27.12 <number:month>................................................................................................. 293
16.27.13 <number:year>.................................................................................................... 293
16.27.14 <number:era>...................................................................................................... 293
16.27.15 <number:day-of-week>........................................................................................ 294
16.27.16 <number:week-of-year>......................................................................................294
16.27.17 <number:quarter>................................................................................................ 294
16.27.18 <number:time-style>............................................................................................ 294
16.27.19 <number:hours>.................................................................................................. 295
16.27.20 <number:minutes>............................................................................................... 295
16.27.21 <number:seconds>.............................................................................................. 295
16.27.22 <number:am-pm>................................................................................................ 295
16.27.23 <number:boolean-style>......................................................................................296
16.27.24 <number:boolean>.............................................................................................. 296
16.27.25 <number:text-style>............................................................................................. 296
16.27.26 <number:text>..................................................................................................... 296
16.27.27 <number:text-content>........................................................................................ 297

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 25 of 104

16.27.28 <style:text-properties>......................................................................................... 297
16.28 Text Style Families........................................................................................................ 298
16.28.1 Text Styles............................................................................................................. 298
16.28.2 Paragraph Styles................................................................................................... 298
16.28.3 Section Styles....................................................................................................... 298
16.28.4 Ruby Styles........................................................................................................... 298
16.29 Enhanced Text Styles................................................................................................... 298
16.29.1 <text:linenumbering-configuration>.......................................................................298
16.29.2 <text:linenumbering-separator>............................................................................299
16.29.3 <text:notes-configuration>.....................................................................................299
16.29.4 <text:note-continuation-notice-forward>................................................................299
16.29.5 <text:note-continuation-notice-backward>............................................................300
16.29.6 <text:bibliography-configuration>..........................................................................300
16.29.7 <text:sort-key>....................................................................................................... 300
16.30 <text:list-style>.............................................................................................................. 300
16.31 <text:list-level-style-bullet>........................................................................................... 301
16.32 <text:list-level-style-number>........................................................................................ 301
16.33 <text:list-level-style-image>.......................................................................................... 302
16.34 <text:outline-style>....................................................................................................... 302
16.35 <text:outline-level-style>............................................................................................... 302
16.36 Table Styles.................................................................................................................. 303
16.36.1 Table Styles........................................................................................................... 303
16.36.2 Table Column Styles.............................................................................................. 303
16.36.3 Table Row Styles................................................................................................... 303
16.36.4 Table Cell Styles.................................................................................................... 303
16.37 Graphic Styles.............................................................................................................. 303
16.38 Presentation Styles....................................................................................................... 303
16.39 Drawing Page Style...................................................................................................... 303
16.40 Enhanced Graphic Style Elements...............................................................................304
16.40.1 <draw:gradient>.................................................................................................... 304
16.40.2 <svg:linearGradient>............................................................................................. 304
16.40.3 <svg:radialGradient>............................................................................................. 304
16.40.4 <svg:stop>............................................................................................................. 305
16.40.5 <draw:hatch>......................................................................................................... 305
16.40.6 <draw:fill-image>................................................................................................... 305
16.40.7 <draw:opacity>...................................................................................................... 306
16.40.8 <draw:marker>...................................................................................................... 306

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 26 of 104

16.40.9 <draw:stroke-dash>............................................................................................... 307
16.41 <style:presentation-page-layout>.................................................................................307
16.42 <presentation:placeholder>.......................................................................................... 307
16.43 Chart Styles.................................................................................................................. 307
17 Formatting Elements.............................................................................................................. 309
17.1 General........................................................................................................................... 309
17.2 <style:page-layout-properties>.......................................................................................309
17.3 <style:background-image>............................................................................................. 309
17.4 <style:footnote-sep>....................................................................................................... 310
17.5 <style:header-footer-properties>....................................................................................310
17.6 <style:paragraph-properties>.......................................................................................... 311
17.7 <style:tab-stops>............................................................................................................ 311
17.8 <style:tab-stop>.............................................................................................................. 311
17.9 <style:drop-cap>............................................................................................................. 312
17.10 <style:ruby-properties>................................................................................................. 312
17.11 <style:section-properties>............................................................................................. 312
17.12 <style:columns>............................................................................................................ 312
17.13 <style:column>............................................................................................................. 313
17.14 <style:column-sep>...................................................................................................... 313
17.15 <style:table-properties>................................................................................................ 313
17.16 <style:table-column-properties>...................................................................................314
17.17 <style:table-row-properties>......................................................................................... 314
17.18 <style:table-cell-properties>......................................................................................... 314
17.19 <style:list-level-properties>.......................................................................................... 315
17.20 <style:list-level-label-alignment>..................................................................................315
17.21 <style:graphic-properties>............................................................................................ 315
17.22 <style:chart-properties>................................................................................................ 317
17.23 <chart:symbol-image>.................................................................................................. 318
17.24 <chart:label-separator>................................................................................................ 318
17.25 <style:drawing-page-properties>..................................................................................318
18 Datatypes............................................................................................................................... 320
18.1 Introduction..................................................................................................................... 320
18.2 W3C Schema Datatypes................................................................................................ 320
18.3 Other Datatypes............................................................................................................. 321
18.3.1 angle....................................................................................................................... 321
18.3.2 anyIRI ..................................................................................................................... 321
18.3.3 boolean................................................................................................................... 321

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 27 of 104

18.3.4 cellAddress.............................................................................................................. 321
18.3.5 cellRangeAddress................................................................................................... 321
18.3.6 cellRangeAddressList............................................................................................. 321
18.3.7 character................................................................................................................. 321
18.3.8 clipShape................................................................................................................ 321
18.3.9 color........................................................................................................................ 321
18.3.10 coordinate............................................................................................................. 321
18.3.11 countryCode.......................................................................................................... 322
18.3.12 CURIE................................................................................................................... 322
18.3.13 CURIEs................................................................................................................. 322
18.3.14 dateOrDateTime.................................................................................................... 322
18.3.15 distance................................................................................................................. 322
18.3.16 language............................................................................................................... 322
18.3.17 languageCode....................................................................................................... 322
18.3.18 length.................................................................................................................... 322
18.3.19 namespacedToken................................................................................................ 322
18.3.20 nonNegativeLength............................................................................................... 323
18.3.21 nonNegativePixelLength.......................................................................................323
18.3.22 pathData................................................................................................................ 323
18.3.23 percent.................................................................................................................. 323
18.3.24 point3D.................................................................................................................. 323
18.3.25 points..................................................................................................................... 323
18.3.26 positiveLength....................................................................................................... 323
18.3.27 relativeLength........................................................................................................ 323
18.3.28 safeCURIE............................................................................................................ 323
18.3.29 scriptCode............................................................................................................. 323
18.3.30 signedZeroToHundredPercent..............................................................................323
18.3.31 styleName............................................................................................................. 324
18.3.32 styleNameRef........................................................................................................ 324
18.3.33 styleNameRefs...................................................................................................... 324
18.3.34 targetFrameName................................................................................................. 324
18.3.35 textEncoding.......................................................................................................... 324
18.3.36 timeOrDateTime.................................................................................................... 324
18.3.37 URIorSafeCURIE.................................................................................................. 324
18.3.38 valueType.............................................................................................................. 324
18.3.39 variableName........................................................................................................ 324
18.3.40 vector3D................................................................................................................ 324

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 28 of 104

18.3.41 zeroToHundredPercent......................................................................................... 324
19 General Attributes.................................................................................................................. 325
19.1 General........................................................................................................................... 325
19.2 anim:color-interpolation.................................................................................................. 325
19.3 anim:color-interpolation-direction...................................................................................325
19.4 anim:audio-level............................................................................................................. 325
19.5 anim:command............................................................................................................... 326
19.6 anim:formula................................................................................................................... 326
19.7 anim:id (deprecated)....................................................................................................... 327
19.8 anim:iterate-interval........................................................................................................ 328
19.9 anim:iterate-type............................................................................................................. 328
19.10 anim:name.................................................................................................................... 328
19.11 anim:sub-item............................................................................................................... 328
19.12 anim:value.................................................................................................................... 329
19.13 chart:attached-axis....................................................................................................... 329
19.14 chart:automatic-content................................................................................................ 329
19.15 chart:class.................................................................................................................... 330
19.15.1 <chart:chart>, <chart:series>................................................................................330
19.15.2 <chart:grid>........................................................................................................... 336
19.16 chart:column-mapping (deprecated).............................................................................337
19.17 chart:data-source-has-labels (deprecated)..................................................................337
19.18 chart:dimension............................................................................................................ 337
19.19 chart:display-equation.................................................................................................. 338
19.20 chart:display-r-square................................................................................................... 338
19.21 chart:label-cell-address................................................................................................ 338
19.22 chart:legend-align......................................................................................................... 339
19.23 chart:legend-position.................................................................................................... 339
19.24 chart:name.................................................................................................................... 340
19.25 chart:repeated.............................................................................................................. 340
19.26 chart:row-mapping (deprecated)..................................................................................340
19.27 chart:style-name........................................................................................................... 340
19.28 chart:values-cell-range-address...................................................................................341
19.29 config:name.................................................................................................................. 341
19.30 config:type.................................................................................................................... 341
19.31 db:additional-column-statement...................................................................................342
19.32 db:append-table-alias-name......................................................................................... 342
19.33 db:apply-command....................................................................................................... 342

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 29 of 104

19.34 db:as-template.............................................................................................................. 342
19.35 db:base-dn.................................................................................................................... 343
19.36 db:boolean-comparison-mode......................................................................................343
19.37 db:catalog-name........................................................................................................... 343
19.38 db:command................................................................................................................. 343
19.39 db:data-source-setting-is-list........................................................................................ 344
19.40 db:data-source-setting-name........................................................................................ 344
19.41 db:data-source-setting-type.......................................................................................... 344
19.42 db:data-type.................................................................................................................. 345
19.43 db:database-name........................................................................................................ 345
19.44 db:decimal.................................................................................................................... 345
19.45 db:default-cell-style-name............................................................................................ 345
19.46 db:default-row-style-name............................................................................................ 345
19.47 db:delete-rule............................................................................................................... 346
19.48 db:description............................................................................................................... 346
19.49 db:enable-sql92-check................................................................................................. 346
19.50 db:encoding.................................................................................................................. 347
19.51 db:escape-processing.................................................................................................. 347
19.52 db:extension................................................................................................................. 347
19.53 db:field.......................................................................................................................... 347
19.54 db:hostname................................................................................................................. 347
19.55 db:ignore-driver-privileges............................................................................................ 348
19.56 db:is-ascending............................................................................................................ 348
19.57 db:is-autoincrement...................................................................................................... 348
19.58 db:is-clustered.............................................................................................................. 348
19.59 db:is-empty-allowed...................................................................................................... 349
19.60 db:is-first-row-header-line............................................................................................. 349
19.61 db:login-timeout............................................................................................................ 349
19.62 db:is-nullable................................................................................................................ 349
19.63 db:is-password-required............................................................................................... 350
19.64 db:is-unique.................................................................................................................. 350
19.65 db:precision.................................................................................................................. 350
19.66 db:is-table-name-length-limited....................................................................................350
19.67 db:local-socket............................................................................................................. 351
19.68 db:max-row-count......................................................................................................... 351
19.69 db:media-type............................................................................................................... 351
19.70 db:name........................................................................................................................ 351

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 30 of 104

19.70.1 General................................................................................................................. 351
19.70.2 <db:column>.......................................................................................................... 351
19.70.3 <db:column-definition>.......................................................................................... 352
19.70.4 <db:component>................................................................................................... 352
19.70.5 <db:component-collection>...................................................................................352
19.70.6 <db:index>............................................................................................................. 352
19.70.7 <db:index-column>................................................................................................ 352
19.70.8 <db:key>................................................................................................................ 352
19.70.9 <db:key-column>................................................................................................... 353
19.70.10 <db:query>.......................................................................................................... 353
19.70.11 <db:query-collection>.......................................................................................... 353
19.70.12 <db:table-definition>........................................................................................... 353
19.70.13 <db:table-representation>...................................................................................353
19.70.14 <db:update-table>............................................................................................... 353
19.71 db:parameter-name-substitution...................................................................................354
19.72 db:port.......................................................................................................................... 354
19.73 db:referenced-table-name............................................................................................ 354
19.74 db:related-column-name............................................................................................... 354
19.75 db:row-retrieving-statement.......................................................................................... 354
19.76 db:scale........................................................................................................................ 355
19.77 db:schema-name.......................................................................................................... 355
19.78 db:show-deleted........................................................................................................... 355
19.79 db:string........................................................................................................................ 355
19.80 db:style-name............................................................................................................... 355
19.80.1 General................................................................................................................. 355
19.80.2 <db:column>.......................................................................................................... 356
19.80.3 <db:query>............................................................................................................ 356
19.80.4 <db:table-representation>.....................................................................................356
19.81 db:suppress-version-columns.......................................................................................356
19.82 db:system-driver-settings............................................................................................. 356
19.83 db:thousand.................................................................................................................. 357
19.84 db:title........................................................................................................................... 357
19.85 db:type.......................................................................................................................... 357
19.85.1 General................................................................................................................. 357
19.85.2 <db:key>................................................................................................................ 357
19.85.3 <db:server-database>........................................................................................... 357
19.85.4 <db:table-definition>............................................................................................. 358

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 31 of 104

19.86 db:type-name................................................................................................................ 358
19.87 db:update-rule.............................................................................................................. 358
19.88 db:use-catalog.............................................................................................................. 359
19.89 db:use-system-user...................................................................................................... 359
19.90 db:user-name............................................................................................................... 359
19.91 db:visible...................................................................................................................... 359
19.92 dr3d:ambient-color........................................................................................................ 360
19.93 dr3d:center................................................................................................................... 360
19.94 dr3d:diffuse-color.......................................................................................................... 360
19.95 dr3d:direction................................................................................................................ 360
19.96 dr3d:distance................................................................................................................ 360
19.97 dr3d:enabled................................................................................................................ 361
19.98 dr3d:focal-length........................................................................................................... 361
19.99 dr3d:lighting-mode........................................................................................................ 361
19.99.1 General................................................................................................................. 361
19.99.2 <chart:plot-area>................................................................................................... 361
19.99.3 <dr3d:scene>........................................................................................................ 361
19.100 dr3d:max-edge ........................................................................................................... 362
19.101 dr3d:min-edge............................................................................................................ 362
19.102 dr3d:projection............................................................................................................ 362
19.103 dr3d:shade-mode....................................................................................................... 362
19.104 dr3d:shadow-slant...................................................................................................... 363
19.105 dr3d:size..................................................................................................................... 363
19.106 dr3d:specular.............................................................................................................. 363
19.107 dr3d:transform............................................................................................................ 363
19.108 dr3d:vpn...................................................................................................................... 364
19.109 dr3d:vrp...................................................................................................................... 364
19.110 dr3d:vup...................................................................................................................... 364
19.111 draw:align.................................................................................................................... 364
19.112 draw:angle.................................................................................................................. 365
19.113 draw:archive............................................................................................................... 365
19.114 draw:border................................................................................................................. 365
19.115 draw:caption-id........................................................................................................... 366
19.116 draw:caption-point-x................................................................................................... 366
19.117 draw:caption-point-y................................................................................................... 366
19.118 draw:chain-next-name................................................................................................ 366
19.119 draw:class-id............................................................................................................... 366

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 32 of 104

19.120 draw:class-names....................................................................................................... 367
19.121 draw:code................................................................................................................... 367
19.122 draw:color................................................................................................................... 367
19.122.1 General............................................................................................................... 367
19.122.2 <draw:hatch>....................................................................................................... 367
19.122.3 <presentation:dim>.............................................................................................. 367
19.123 draw:concave............................................................................................................. 368
19.124 draw:concentric-gradient-fill-allowed..........................................................................368
19.125 draw:control................................................................................................................ 368
19.126 draw:copy-of............................................................................................................... 368
19.127 draw:corner-radius...................................................................................................... 369
19.128 draw:corners............................................................................................................... 369
19.129 draw:cx....................................................................................................................... 369
19.130 draw:cy....................................................................................................................... 369
19.131 draw:data.................................................................................................................... 370
19.132 draw:display................................................................................................................ 370
19.133 draw:display-name..................................................................................................... 370
19.133.1 General............................................................................................................... 370
19.133.2 <draw:fill-image>................................................................................................. 370
19.133.3 <draw:gradient>.................................................................................................. 370
19.133.4 <draw:hatch>....................................................................................................... 371
19.133.5 <draw:marker> ................................................................................................... 371
19.133.6 <draw:opacity>.................................................................................................... 371
19.133.7 <draw:stroke-dash>............................................................................................. 371
19.133.8 <svg:linearGradient>........................................................................................... 371
19.133.9 <svg:radialGradient>........................................................................................... 371
19.134 draw:distance............................................................................................................. 372
19.134.1 General............................................................................................................... 372
19.134.2 <draw:hatch>....................................................................................................... 372
19.134.3 <draw:stroke-dash>............................................................................................. 372
19.135 draw:dots1.................................................................................................................. 372
19.136 draw:dots1-length....................................................................................................... 372
19.137 draw:dots2.................................................................................................................. 373
19.138 draw:dots2-length....................................................................................................... 373
19.139 draw:end..................................................................................................................... 373
19.140 draw:end-angle........................................................................................................... 373
19.141 draw:end-color............................................................................................................ 373

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 33 of 104

19.142 draw:end-glue-point.................................................................................................... 374
19.143 draw:end-intensity...................................................................................................... 374
19.144 draw:end-shape.......................................................................................................... 374
19.145 draw:enhanced-path................................................................................................... 374
19.146 draw:engine................................................................................................................ 376
19.147 draw:escape-direction................................................................................................ 377
19.148 draw:extrusion............................................................................................................ 377
19.149 draw:extrusion-allowed............................................................................................... 377
19.150 draw:extrusion-brightness.......................................................................................... 378
19.151 draw:extrusion-color................................................................................................... 378
19.152 draw:extrusion-depth.................................................................................................. 378
19.153 draw:extrusion-diffusion.............................................................................................. 378
19.154 draw:extrusion-first-light-direction..............................................................................379
19.155 draw:extrusion-first-light-harsh...................................................................................379
19.156 draw:extrusion-first-light-level.....................................................................................379
19.157 draw:extrusion-light-face............................................................................................ 379
19.158 draw:extrusion-metal.................................................................................................. 380
19.159 draw:extrusion-number-of-line-segments...................................................................380
19.160 draw:extrusion-origin.................................................................................................. 380
19.161 draw:extrusion-rotation-angle.....................................................................................381
19.162 draw:extrusion-rotation-center....................................................................................381
19.163 draw:extrusion-second-light-direction.........................................................................381
19.164 draw:extrusion-second-light-harsh.............................................................................382
19.165 draw:extrusion-second-light-level...............................................................................382
19.166 draw:extrusion-shininess............................................................................................ 382
19.167 draw:extrusion-skew................................................................................................... 382
19.168 draw:extrusion-specularity.......................................................................................... 383
19.169 draw:extrusion-viewpoint............................................................................................ 383
19.170 draw:filter-name.......................................................................................................... 383
19.171 draw:formula............................................................................................................... 383
19.172 draw:frame-name........................................................................................................ 385
19.173 draw:glue-point-leaving-directions.............................................................................385
19.174 draw:glue-point-type................................................................................................... 386
19.175 draw:glue-points......................................................................................................... 386
19.176 draw:handle-mirror-horizontal....................................................................................387
19.177 draw:handle-mirror-vertical......................................................................................... 387
19.178 draw:handle-polar....................................................................................................... 387

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 34 of 104

19.179 draw:handle-position.................................................................................................. 388
19.180 draw:handle-radius-range-maximum..........................................................................389
19.181 draw:handle-radius-range-minimum...........................................................................389
19.182 draw:handle-range-x-maximum..................................................................................390
19.183 draw:handle-range-x-minimum...................................................................................390
19.184 draw:handle-range-y-maximum..................................................................................390
19.185 draw:handle-range-y-minimum...................................................................................390
19.186 draw:handle-switched................................................................................................. 390
19.187 draw:id........................................................................................................................ 391
19.187.1 General............................................................................................................... 391
19.187.2 <draw:glue-point>............................................................................................... 391
19.187.3 <dr3d:cube>, <dr3d:extrude>, <dr3d:rotate>, <dr3d:scene>, <dr3d:sphere>,<draw:caption>, <draw:circle>, <draw:connector>, <draw:control>, <draw:custom-shape>,<draw:ellipse>, <draw:frame>, <draw:g>, <draw:line>, <draw:measure>, <draw:page>,<draw:page-thumbnail>, <draw:path>, <draw:polygon>, <draw:polyline>, <draw:rect>,<draw:regular-polygon> and <office:annotation>...............................................................391
19.188 draw:kind.................................................................................................................... 392
19.189 draw:layer................................................................................................................... 392
19.190 draw:line-skew............................................................................................................ 392
19.191 draw:mime-type.......................................................................................................... 393
19.192 draw:mirror-horizontal................................................................................................. 393
19.193 draw:mirror-vertical..................................................................................................... 393
19.194 draw:master-page-name............................................................................................. 394
19.195 draw:may-script.......................................................................................................... 394
19.196 draw:modifiers............................................................................................................ 394
19.197 draw:name.................................................................................................................. 394
19.197.1 General............................................................................................................... 394
19.197.2 <draw:caption>.................................................................................................... 395
19.197.3 <draw:circle>....................................................................................................... 395
19.197.4 <draw:connector>................................................................................................ 395
19.197.5 <draw:control>..................................................................................................... 395
19.197.6 <draw:custom-shape>......................................................................................... 395
19.197.7 <draw:ellipse>..................................................................................................... 395
19.197.8 <draw:equation>.................................................................................................. 396
19.197.9 <draw:fill-image>................................................................................................. 396
19.197.10 <draw:frame>.................................................................................................... 396
19.197.11 <draw:g>............................................................................................................ 396
19.197.12 <draw:gradient>................................................................................................ 396

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 35 of 104

19.197.13 <draw:hatch>..................................................................................................... 396
19.197.14 <draw:layer>...................................................................................................... 396
19.197.15 <draw:line>........................................................................................................ 397
19.197.16 <draw:marker>.................................................................................................. 397
19.197.17 <draw:measure>................................................................................................ 397
19.197.18 <draw:opacity>.................................................................................................. 397
19.197.19 <draw:page>..................................................................................................... 397
19.197.20 <draw:page-thumbnail>.....................................................................................397
19.197.21 <draw:param>................................................................................................... 398
19.197.22 <draw:path>...................................................................................................... 398
19.197.23 <draw:polygon>................................................................................................. 398
19.197.24 <draw:polyline>................................................................................................. 398
19.197.25 <draw:rect>....................................................................................................... 398
19.197.26 <draw:regular-polygon>....................................................................................398
19.197.27 <draw:stroke-dash>........................................................................................... 399
19.197.28 <office:annotation> (deprecated)......................................................................399
19.197.29 <svg:linearGradient>......................................................................................... 399
19.197.30 <svg:radialGradient>......................................................................................... 399
19.198 draw:nav-order........................................................................................................... 400
19.199 draw:nohref................................................................................................................. 400
19.200 draw:notify-on-update-of-ranges................................................................................400
19.201 draw:object................................................................................................................. 400
19.202 draw:opacity............................................................................................................... 401
19.203 draw:page-number...................................................................................................... 401
19.204 draw:path-stretchpoint-x............................................................................................. 401
19.205 draw:path-stretchpoint-y............................................................................................. 401
19.206 draw:points................................................................................................................. 402
19.207 draw:protected............................................................................................................ 402
19.208 draw:recreate-on-edit................................................................................................. 402
19.209 draw:rotation............................................................................................................... 403
19.210 draw:shape-id............................................................................................................. 403
19.211 draw:sharpness........................................................................................................... 403
19.212 draw:start.................................................................................................................... 403
19.213 draw:start-angle.......................................................................................................... 403
19.214 draw:start-color........................................................................................................... 404
19.215 draw:start-glue-point................................................................................................... 404
19.216 draw:start-intensity..................................................................................................... 404

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 36 of 104

19.217 draw:start-shape......................................................................................................... 404
19.218 draw:style................................................................................................................... 404
19.218.1 General............................................................................................................... 404
19.218.2 <draw:gradient>.................................................................................................. 405
19.218.3 <draw:hatch>....................................................................................................... 405
19.218.4 <draw:opacity>.................................................................................................... 406
19.218.5 <draw:stroke-dash>............................................................................................. 406
19.219 draw:style-name......................................................................................................... 406
19.219.1 General............................................................................................................... 406
19.219.2 <dr3d:cube>........................................................................................................ 406
19.219.3 <dr3d:extrude>.................................................................................................... 407
19.219.4 <dr3d:rotate>....................................................................................................... 407
19.219.5 <dr3d:scene>...................................................................................................... 407
19.219.6 <dr3d:sphere>..................................................................................................... 407
19.219.7 <draw:caption>.................................................................................................... 407
19.219.8 <draw:circle>....................................................................................................... 407
19.219.9 <draw:connector>................................................................................................ 408
19.219.10 <draw:control>................................................................................................... 408
19.219.11 <draw:custom-shape>.......................................................................................408
19.219.12 <draw:ellipse>................................................................................................... 408
19.219.13 <draw:frame>.................................................................................................... 408
19.219.14 <draw:g>........................................................................................................... 408
19.219.15 <draw:line>........................................................................................................ 409
19.219.16 <draw:measure>................................................................................................ 409
19.219.17 <draw:page>..................................................................................................... 409
19.219.18 <draw:page-thumbnail>.....................................................................................409
19.219.19 <draw:path>...................................................................................................... 409
19.219.20 <draw:polygon>................................................................................................. 409
19.219.21 <draw:polyline>................................................................................................. 410
19.219.22 <draw:rect>....................................................................................................... 410
19.219.23 <draw:regular-polygon>....................................................................................410
19.219.24 <office:annotation>............................................................................................ 410
19.219.25 <presentation:notes>........................................................................................ 410
19.219.26 <style:handout-master>.....................................................................................411
19.219.27 <style:master-page>.......................................................................................... 411
19.220 draw:text-areas........................................................................................................... 411
19.221 draw:text-path............................................................................................................. 412

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 37 of 104

19.222 draw:text-path-allowed............................................................................................... 412
19.223 draw:text-path-mode................................................................................................... 413
19.224 draw:text-path-same-letter-heights.............................................................................413
19.225 draw:text-path-scale................................................................................................... 413
19.226 draw:text-rotate-angle................................................................................................. 414
19.227 draw:text-style-name.................................................................................................. 414
19.228 draw:transform............................................................................................................ 414
19.229 draw:type.................................................................................................................... 415
19.229.1 General............................................................................................................... 415
19.229.2 <draw:connector>................................................................................................ 415
19.229.3 <draw:enhanced-geometry>................................................................................415
19.230 draw:value.................................................................................................................. 416
19.231 draw:z-index............................................................................................................... 416
19.232 fo:column-count.......................................................................................................... 416
19.233 fo:column-gap............................................................................................................. 416
19.234 fo:country.................................................................................................................... 417
19.234.1 <text:alphabetical-index-source>........................................................................417
19.234.2 <text:bibliography-configuration>........................................................................417
19.235 fo:end-indent.............................................................................................................. 417
19.236 fo:language................................................................................................................. 417
19.236.1 General............................................................................................................... 417
19.236.2 <text:alphabetical-index-source>........................................................................418
19.236.3 <text:bibliography-configuration>........................................................................418
19.237 fo:margin-left............................................................................................................... 418
19.238 fo:max-height.............................................................................................................. 418
19.239 fo:max-width............................................................................................................... 419
19.240 fo:min-height............................................................................................................... 419
19.241 fo:min-width................................................................................................................ 419
19.242 fo:script....................................................................................................................... 420
19.242.1 General............................................................................................................... 420
19.242.2 <text:alphabetical-index-source>........................................................................420
19.242.3 <text:bibliography-configuration>........................................................................420
19.243 fo:space-after.............................................................................................................. 420
19.244 fo:space-before........................................................................................................... 420
19.245 fo:start-indent............................................................................................................. 421
19.246 fo:text-indent............................................................................................................... 421
19.247 form:allow-deletes...................................................................................................... 421

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 38 of 104

19.248 form:allow-inserts....................................................................................................... 421
19.249 form:allow-updates..................................................................................................... 422
19.250 form:apply-design-mode............................................................................................. 422
19.251 form:apply-filter........................................................................................................... 422
19.252 form:auto-complete..................................................................................................... 423
19.253 form:automatic-focus.................................................................................................. 423
19.254 form:bound-column..................................................................................................... 423
19.255 form:button-type......................................................................................................... 424
19.256 form:command............................................................................................................ 424
19.257 form:command-type.................................................................................................... 424
19.258 form:control-implementation.......................................................................................425
19.259 form:convert-empty-to-null.......................................................................................... 425
19.260 form:current-selected.................................................................................................. 425
19.261 form:current-state....................................................................................................... 426
19.262 form:current-value...................................................................................................... 426
19.263 form:data-field............................................................................................................. 426
19.264 form:datasource.......................................................................................................... 427
19.265 form:default-button..................................................................................................... 427
19.266 form:delay-for-repeat.................................................................................................. 428
19.267 form:detail-fields......................................................................................................... 428
19.268 form:disabled.............................................................................................................. 428
19.269 form:dropdown............................................................................................................ 428
19.270 form:echo-char........................................................................................................... 429
19.271 form:enctype............................................................................................................... 429
19.272 form:escape-processing............................................................................................. 429
19.273 form:filter..................................................................................................................... 430
19.274 form:focus-on-click..................................................................................................... 430
19.275 form:for....................................................................................................................... 430
19.276 form:id......................................................................................................................... 430
19.277 form:ignore-result....................................................................................................... 431
19.278 form:image-align......................................................................................................... 431
19.279 form:image-data.......................................................................................................... 431
19.280 form:image-position.................................................................................................... 432
19.281 form:is-tristate............................................................................................................. 432
19.282 form:label.................................................................................................................... 432
19.283 form:linked-cell........................................................................................................... 433
19.284 form:list-linkage-type.................................................................................................. 433

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 39 of 104

19.285 form:list-source........................................................................................................... 433
19.286 form:list-source-type................................................................................................... 434
19.287 form:master-fields....................................................................................................... 435
19.288 form:max-length.......................................................................................................... 435
19.289 form:max-value........................................................................................................... 435
19.289.1 General............................................................................................................... 435
19.289.2 <form:date>......................................................................................................... 435
19.289.3 <form:formatted-text>.......................................................................................... 436
19.289.4 <form:number> and <form:value-range>.............................................................436
19.289.5 <form:time>......................................................................................................... 436
19.290 form:min-value............................................................................................................ 436
19.290.1 General............................................................................................................... 436
19.290.2 <form:date>......................................................................................................... 436
19.290.3 <form:formatted-text>.......................................................................................... 436
19.290.4 <form:number> and <form:value-range>.............................................................436
19.290.5 <form:time>......................................................................................................... 437
19.291 form:method................................................................................................................ 437
19.292 form:multi-line............................................................................................................. 437
19.293 form:multiple............................................................................................................... 437
19.294 form:name................................................................................................................... 438
19.295 form:navigation-mode................................................................................................. 438
19.296 form:order................................................................................................................... 438
19.297 form:orientation........................................................................................................... 439
19.298 form:page-step-size.................................................................................................... 439
19.299 form:printable.............................................................................................................. 439
19.300 form:property-name.................................................................................................... 439
19.301 form:readonly.............................................................................................................. 440
19.302 form:repeat................................................................................................................. 440
19.303 form:selected.............................................................................................................. 440
19.304 form:size..................................................................................................................... 441
19.305 form:source-cell-range................................................................................................ 441
19.306 form:spin-button.......................................................................................................... 441
19.307 form:state.................................................................................................................... 442
19.308 form:step-size............................................................................................................. 442
19.309 form:tab-cycle............................................................................................................. 442
19.310 form:tab-index............................................................................................................. 443
19.311 form:tab-stop............................................................................................................... 443

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 40 of 104

19.312 form:text-style-name................................................................................................... 444
19.313 form:title...................................................................................................................... 444
19.314 form:toggle.................................................................................................................. 444
19.315 form:validation............................................................................................................ 444
19.316 form:value................................................................................................................... 445
19.316.1 General .............................................................................................................. 445
19.316.2 <form:button>...................................................................................................... 445
19.316.3 <form:date>......................................................................................................... 445
19.316.4 <form:number> and <form:value-range>.............................................................445
19.316.5 <form:checkbox>, <form:combobox>, <form:file>, <form:formatted-text>,<form:hidden>, <form:image>, <form:option>, <form:password>, <form:radio>, <form:text>,<form:textarea>.................................................................................................................. 445
19.316.6 <form:time>......................................................................................................... 446
19.317 form:visual-effect........................................................................................................ 446
19.318 form:xforms-list-source............................................................................................... 446
19.319 form:xforms-submission.............................................................................................. 446
19.320 grddl:transformation.................................................................................................... 446
19.321 meta:cell-count........................................................................................................... 447
19.322 meta:character-count.................................................................................................. 447
19.323 meta:date.................................................................................................................... 447
19.324 meta:delay.................................................................................................................. 447
19.325 meta:draw-count......................................................................................................... 448
19.326 meta:frame-count........................................................................................................ 448
19.327 meta:image-count....................................................................................................... 448
19.328 meta:name.................................................................................................................. 448
19.329 meta:non-whitespace-character-count.......................................................................448
19.330 meta:object-count....................................................................................................... 449
19.331 meta:ole-object-count................................................................................................. 449
19.332 meta:page-count......................................................................................................... 449
19.333 meta:paragraph-count................................................................................................ 449
19.334 meta:row-count........................................................................................................... 449
19.335 meta:sentence-count.................................................................................................. 450
19.336 meta:syllable-count..................................................................................................... 450
19.337 meta:table-count......................................................................................................... 450
19.338 meta:value-type.......................................................................................................... 450
19.339 meta:word-count......................................................................................................... 451
19.340 number:automatic-order............................................................................................. 451
19.341 number:calendar......................................................................................................... 451
OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 41 of 104

19.342 number:country........................................................................................................... 452
19.343 number:decimal-places.............................................................................................. 452
19.343.1 General............................................................................................................... 452
19.343.2 <number:number>............................................................................................... 452
19.343.3 <number:seconds> ............................................................................................. 453
19.343.4 <number:scientific-number>................................................................................453
19.344 number:decimal-replacement.....................................................................................453
19.345 number:denominator-value......................................................................................... 453
19.346 number:display-factor................................................................................................. 454
19.347 number:format-source................................................................................................ 454
19.348 number:grouping........................................................................................................ 454
19.349 number:language........................................................................................................ 455
19.350 number:min-denominator-digits..................................................................................455
19.351 number:min-exponent-digits.......................................................................................455
19.352 number:min-integer-digits........................................................................................... 455
19.353 number:min-numerator-digits......................................................................................455
19.354 number:position.......................................................................................................... 456
19.355 number:possessive-form............................................................................................ 456
19.356 number:rfc-language-tag............................................................................................ 456
19.357 number:script.............................................................................................................. 457
19.358 number:style............................................................................................................... 457
19.358.1 General............................................................................................................... 457
19.358.2 <number:day>..................................................................................................... 457
19.358.3 <number:day-of-week>........................................................................................ 457
19.358.4 <number:era>...................................................................................................... 458
19.358.5 <number:hours>.................................................................................................. 458
19.358.6 <number:minutes>............................................................................................... 458
19.358.7 <number:month>................................................................................................. 458
19.358.8 <number:quarter>................................................................................................ 459
19.358.9 <number:seconds>.............................................................................................. 459
19.358.10 <number:year>.................................................................................................. 459
19.359 number:textual............................................................................................................ 459
19.360 number:title................................................................................................................. 460
19.361 number:transliteration-country....................................................................................460
19.362 number:transliteration-format.....................................................................................460
19.363 number:transliteration-language.................................................................................460
19.364 number:transliteration-style........................................................................................ 461

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 42 of 104

19.365 number:truncate-on-overflow......................................................................................461
19.366 office:automatic-update.............................................................................................. 461
19.367 office:boolean-value................................................................................................... 462
19.368 office:conversion-mode.............................................................................................. 462
19.369 office:currency............................................................................................................ 463
19.370 office:date-value......................................................................................................... 463
19.371 office:dde-application................................................................................................. 463
19.372 office:dde-item............................................................................................................ 463
19.373 office:dde-topic........................................................................................................... 464
19.374 office:display............................................................................................................... 464
19.375 office:mimetype........................................................................................................... 464
19.376 office:name................................................................................................................. 464
19.376.1 General............................................................................................................... 464
19.376.2 <draw:a>............................................................................................................. 464
19.376.3 <draw:area-circle>.............................................................................................. 465
19.376.4 <draw:area-rectangle>........................................................................................ 465
19.376.5 <draw:area-polygon>.......................................................................................... 465
19.376.6 <office:annotation>.............................................................................................. 465
19.376.7 <office:annotation-end>......................................................................................465
19.376.8 <office:dde-source>............................................................................................. 466
19.376.9 <text:a>............................................................................................................... 466
19.376.10 <text:dde-connection-decl>...............................................................................466
19.377 office:process-content (deprecated)...........................................................................466
19.378 office:server-map........................................................................................................ 466
19.379 office:string-value....................................................................................................... 467
19.380 office:target-frame...................................................................................................... 467
19.381 office:target-frame-name............................................................................................ 467
19.382 office:time-value......................................................................................................... 468
19.383 office:title.................................................................................................................... 468
19.384 office:value................................................................................................................. 468
19.385 office:value-type......................................................................................................... 469
19.386 office:version.............................................................................................................. 470
19.387 presentation:action..................................................................................................... 471
19.388 presentation:animations............................................................................................. 472
19.389 presentation:class...................................................................................................... 472
19.390 presentation:class-names........................................................................................... 473
19.391 presentation:delay...................................................................................................... 473

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 43 of 104

19.392 presentation:direction................................................................................................. 473
19.393 presentation:endless.................................................................................................. 475
19.394 presentation:effect...................................................................................................... 475
19.395 presentation:force-manual.......................................................................................... 476
19.396 presentation:full-screen.............................................................................................. 476
19.397 presentation:group-id................................................................................................. 477
19.398 presentation:master-element......................................................................................477
19.399 presentation:mouse-as-pen........................................................................................ 477
19.400 presentation:mouse-visible......................................................................................... 477
19.401 presentation:name...................................................................................................... 478
19.402 presentation:node-type............................................................................................... 478
19.403 presentation:object..................................................................................................... 479
19.404 presentation:pages..................................................................................................... 479
19.405 presentation:path-id.................................................................................................... 479
19.406 presentation:pause..................................................................................................... 479
19.407 presentation:placeholder............................................................................................ 480
19.408 presentation:play-full.................................................................................................. 480
19.409 presentation:presentation-page-layout-name.............................................................480
19.410 presentation:preset-class........................................................................................... 480
19.411 presentation:preset-id................................................................................................. 481
19.412 presentation:preset-sub-type......................................................................................481
19.413 presentation:show...................................................................................................... 481
19.414 presentation:show-end-of-presentation-slide.............................................................481
19.415 presentation:show-logo.............................................................................................. 482
19.416 presentation:source.................................................................................................... 482
19.417 presentation:speed..................................................................................................... 482
19.418 presentation:start-scale.............................................................................................. 483
19.419 presentation:start-page.............................................................................................. 483
19.420 presentation:start-with-navigator................................................................................483
19.421 presentation:stay-on-top............................................................................................. 483
19.422 presentation:style-name............................................................................................. 484
19.423 presentation:transition-on-click..................................................................................484
19.424 presentation:use-date-time-name...............................................................................484
19.425 presentation:use-footer-name....................................................................................485
19.426 presentation:use-header-name..................................................................................485
19.427 presentation:user-transformed...................................................................................485
19.428 presentation:verb........................................................................................................ 485

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 44 of 104

19.429 script:event-name....................................................................................................... 486
19.430 script:language........................................................................................................... 487
19.431 script:macro-name...................................................................................................... 487
19.432 smil:accelerate............................................................................................................ 487
19.433 smil:accumulate.......................................................................................................... 487
19.434 smil:additive................................................................................................................ 487
19.435 smil:attributeName...................................................................................................... 488
19.436 smil:autoReverse........................................................................................................ 489
19.437 smil:begin................................................................................................................... 489
19.438 smil:by........................................................................................................................ 489
19.439 smil:calcMode............................................................................................................. 489
19.440 smil:decelerate........................................................................................................... 490
19.441 smil:direction.............................................................................................................. 490
19.442 smil:dur....................................................................................................................... 490
19.443 smil:end...................................................................................................................... 490
19.444 smil:endsync............................................................................................................... 490
19.445 smil:fadeColor............................................................................................................. 491
19.446 smil:fill......................................................................................................................... 491
19.447 smil:fillDefault............................................................................................................. 491
19.448 smil:from..................................................................................................................... 491
19.449 smil:keySplines........................................................................................................... 492
19.450 smil:keyTimes............................................................................................................. 492
19.451 smil:mode................................................................................................................... 492
19.452 smil:repeatCount........................................................................................................ 492
19.453 smil:repeatDur............................................................................................................ 492
19.454 smil:restart.................................................................................................................. 493
19.455 smil:restartDefault....................................................................................................... 493
19.456 smil:subtype................................................................................................................ 493
19.457 smil:targetElement...................................................................................................... 493
19.458 smil:to......................................................................................................................... 494
19.459 smil:type..................................................................................................................... 494
19.460 smil:values.................................................................................................................. 494
19.461 style:adjustment.......................................................................................................... 494
19.462 style:apply-style-name................................................................................................ 495
19.463 style:auto-update........................................................................................................ 495
19.464 style:base-cell-address............................................................................................... 495
19.465 style:char.................................................................................................................... 495

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 45 of 104

19.466 style:class................................................................................................................... 496
19.467 style:color................................................................................................................... 496
19.468 style:condition............................................................................................................. 496
19.469 style:data-style-name................................................................................................. 497
19.469.1 General............................................................................................................... 497
19.469.2 <presentation:date-time-decl>............................................................................497
19.469.3 <style:style>........................................................................................................ 498
19.469.4 <text:creation-date>............................................................................................ 498
19.469.5 <text:creation-time>............................................................................................. 498
19.469.6 <text:database-display>......................................................................................498
19.469.7 <text:date>.......................................................................................................... 498
19.469.8 <text:editing-duration>........................................................................................ 499
19.469.9 <text:expression>................................................................................................ 499
19.469.10 <text:meta-field>................................................................................................ 499
19.469.11 <text:modification-date>....................................................................................499
19.469.12 <text:modification-time>....................................................................................499
19.469.13 <text:print-date>................................................................................................ 499
19.469.14 <text:print-time>................................................................................................ 500
19.469.15 <text:table-formula>.......................................................................................... 500
19.469.16 <text:time>......................................................................................................... 500
19.469.17 <text:user-defined>........................................................................................... 500
19.469.18 <text:user-field-get>.......................................................................................... 500
19.469.19 <text:user-field-input>.......................................................................................501
19.469.20 <text:variable-get>............................................................................................ 501
19.469.21 <text:variable-input>.......................................................................................... 501
19.469.22 <text:variable-set>............................................................................................. 501
19.470 style:default-outline-level............................................................................................ 501
19.471 style:display................................................................................................................ 502
19.472 style:display-name...................................................................................................... 502
19.473 style:distance.............................................................................................................. 502
19.474 style:distance-before-sep........................................................................................... 503
19.475 style:distance-after-sep.............................................................................................. 503
19.476 style:family.................................................................................................................. 503
19.477 style:filter-name.......................................................................................................... 504
19.478 style:font-adornments................................................................................................. 504
19.479 style:font-charset........................................................................................................ 504
19.480 style:font-family-generic............................................................................................. 504

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 46 of 104

19.481 style:font-pitch............................................................................................................ 505
19.482 style:height................................................................................................................. 505
19.483 style:leader-char......................................................................................................... 505
19.484 style:leader-color........................................................................................................ 505
19.485 style:leader-style........................................................................................................ 506
19.486 style:leader-text.......................................................................................................... 506
19.487 style:leader-text-style................................................................................................. 507
19.488 style:leader-type......................................................................................................... 507
19.489 style:leader-width....................................................................................................... 507
19.490 style:legend-expansion............................................................................................... 508
19.491 style:legend-expansion-aspect-ratio...........................................................................508
19.492 style:length................................................................................................................. 508
19.493 style:line-style............................................................................................................. 508
19.494 style:lines.................................................................................................................... 509
19.495 style:list-level.............................................................................................................. 509
19.496 style:list-style-name.................................................................................................... 509
19.497 style:master-page-name............................................................................................. 509
19.498 style:name.................................................................................................................. 510
19.498.1 General............................................................................................................... 510
19.498.2 <number:boolean-style>, <number:currency-style>, <number:date-style>,<number:number-style>, <number:percentage-style>, <number:text-style>, <number:timestyle>, <style:master-page>, <style:page-layout>, <style:presentation-page-layout>,<style:style>, <text:list-style>, <text:outline-style>.............................................................510
19.498.3 <style:font-face>.................................................................................................. 511
19.499 style:next-style-name.................................................................................................. 511
19.499.1 General................................................................................................................ 511
19.499.2 <style:master-page>............................................................................................ 511
19.499.3 <style:style>......................................................................................................... 511
19.500 style:num-format......................................................................................................... 511
19.501 style:num-letter-sync.................................................................................................. 512
19.502 style:num-prefix.......................................................................................................... 512
19.503 style:num-suffix........................................................................................................... 513
19.504 style:page-layout-name.............................................................................................. 513
19.505 style:page-usage........................................................................................................ 513
19.506 style:parent-style-name.............................................................................................. 514
19.507 style:percentage-data-style-name..............................................................................514
19.508 style:position............................................................................................................... 514
19.508.1 General............................................................................................................... 514

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 47 of 104

19.508.2 <style:background-image>..................................................................................514
19.508.3 <style:tab-stop>................................................................................................... 515
19.508.4 <text:index-entry-tab-stop>.................................................................................515
19.509 style:rel-height............................................................................................................ 515
19.510 style:rel-width............................................................................................................. 516
19.510.1 General............................................................................................................... 516
19.510.2 <draw:frame>...................................................................................................... 516
19.510.3 <style:column>.................................................................................................... 516
19.510.4 <style:footnote-sep>............................................................................................ 516
19.511 style:repeat................................................................................................................. 517
19.512 style:rfc-language-tag................................................................................................. 517
19.513 style:style.................................................................................................................... 517
19.514 style:style-name.......................................................................................................... 518
19.515 style:type.................................................................................................................... 518
19.515.1 General............................................................................................................... 518
19.515.2 <text:index-entry-tab-stop>.................................................................................518
19.515.3 <style:tab-stop>................................................................................................... 518
19.516 style:vertical-align....................................................................................................... 519
19.517 style:volatile................................................................................................................ 519
19.518 style:width................................................................................................................... 519
19.518.1 General............................................................................................................... 519
19.518.2 <style:column-sep>............................................................................................. 519
19.518.3 <style:footnote-sep>............................................................................................ 520
19.519 svg:accent-height....................................................................................................... 520
19.520 svg:alphabetic............................................................................................................ 520
19.521 svg:ascent.................................................................................................................. 520
19.522 svg:bbox..................................................................................................................... 520
19.523 svg:cap-height............................................................................................................ 520
19.524 svg:cx......................................................................................................................... 521
19.524.1 <draw:area-circle>.............................................................................................. 521
19.524.2 <draw:circle>....................................................................................................... 521
19.524.3 <draw:ellipse>..................................................................................................... 521
19.524.4 <svg:radialGradient>........................................................................................... 521
19.525 svg:cy......................................................................................................................... 521
19.525.1 <draw:area-circle>.............................................................................................. 521
19.525.2 <draw:circle>....................................................................................................... 521
19.525.3 <draw:ellipse>..................................................................................................... 522

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 48 of 104

19.525.4 <svg:radialGradient>........................................................................................... 522
19.526 svg:d........................................................................................................................... 522
19.527 svg:descent................................................................................................................ 522
19.528 svg:font-family............................................................................................................ 522
19.529 svg:font-size............................................................................................................... 522
19.530 svg:font-stretch........................................................................................................... 523
19.531 svg:font-style.............................................................................................................. 523
19.532 svg:font-variant........................................................................................................... 523
19.533 svg:font-weight........................................................................................................... 523
19.534 svg:fx.......................................................................................................................... 523
19.535 svg:fy.......................................................................................................................... 523
19.536 svg:gradientTransform................................................................................................ 524
19.537 svg:gradientUnits........................................................................................................ 524
19.538 svg:hanging................................................................................................................ 524
19.539 svg:height................................................................................................................... 524
19.539.1 <chart:chart>....................................................................................................... 524
19.539.2 <chart:plot-area>................................................................................................. 524
19.539.3 <dr3d:scene>...................................................................................................... 525
19.539.4 <draw:area-polygon>.......................................................................................... 525
19.539.5 <draw:area-rectangle>........................................................................................ 525
19.539.6 <draw:contour-polygon>, <draw:contour-path>..................................................525
19.539.7 <draw:fill-image>................................................................................................. 525
19.539.8 <draw:caption>, <draw:custom-shape>, <draw:circle>, <draw:control>,<draw:ellipse>, <draw:frame>, <draw:rect>, <draw:page-thumbnail>, <draw:path>,<draw:polygon>, <draw:polyline>, <draw:regular-polygon>...............................................525
19.539.9 <office:annotation>.............................................................................................. 526
19.539.10 <presentation:placeholder>...............................................................................526
19.540 svg:ideographic.......................................................................................................... 526
19.541 svg:mathematical........................................................................................................ 526
19.542 svg:name.................................................................................................................... 526
19.543 svg:offset.................................................................................................................... 527
19.544 svg:origin.................................................................................................................... 527
19.545 svg:overline-position................................................................................................... 527
19.546 svg:overline-thickness................................................................................................ 527
19.547 svg:panose-1.............................................................................................................. 527
19.548 svg:path...................................................................................................................... 527
19.549 svg:r............................................................................................................................ 528
19.549.1 <draw:area-circle>.............................................................................................. 528
OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 49 of 104

19.549.2 <draw:circle>....................................................................................................... 528
19.549.3 <svg:radialGradient>........................................................................................... 528
19.550 svg:rx.......................................................................................................................... 528
19.551 svg:ry.......................................................................................................................... 529
19.552 svg:slope.................................................................................................................... 529
19.553 svg:spreadMethod...................................................................................................... 529
19.554 svg:stemh................................................................................................................... 529
19.555 svg:stemv.................................................................................................................... 529
19.556 svg:stop-color............................................................................................................. 529
19.557 svg:stop-opacity.......................................................................................................... 530
19.558 svg:strikethrough-position.......................................................................................... 530
19.559 svg:strikethrough-thickness........................................................................................ 530
19.560 svg:string.................................................................................................................... 530
19.561 svg:type...................................................................................................................... 530
19.562 svg:underline-position................................................................................................ 530
19.563 svg:underline-thickness.............................................................................................. 531
19.564 svg:unicode-range...................................................................................................... 531
19.565 svg:units-per-em......................................................................................................... 531
19.566 svg:v-alphabetic......................................................................................................... 531
19.567 svg:v-hanging............................................................................................................. 531
19.568 svg:v-ideographic....................................................................................................... 531
19.569 svg:v-mathematical..................................................................................................... 532
19.570 svg:viewBox................................................................................................................ 532
19.571 svg:width..................................................................................................................... 532
19.571.1 <chart:chart>....................................................................................................... 532
19.571.2 <chart:floor>........................................................................................................ 532
19.571.3 <chart:plot-area>................................................................................................. 533
19.571.4 <chart:wall>......................................................................................................... 533
19.571.5 <dr3d:scene>...................................................................................................... 533
19.571.6 <draw:area-polygon>.......................................................................................... 533
19.571.7 <draw:area-rectangle>........................................................................................ 533
19.571.8 <draw:contour-polygon>, <draw:contour-path>..................................................533
19.571.9 <draw:fill-image>................................................................................................. 533
19.571.10 <draw:caption>, <draw:custom-shape>, <draw:circle>, <draw:control>,<draw:ellipse>, <draw:frame>, <draw:rect>, <draw:page-thumbnail>, <draw:path>,<draw:polygon>, <draw:polyline>, <draw:regular-polygon>...............................................534
19.571.11 <office:annotation>............................................................................................ 534
19.571.12 <presentation:placeholder>...............................................................................534
OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 50 of 104

19.572 svg:widths................................................................................................................... 534
19.573 svg:x........................................................................................................................... 535
19.573.1 <chart:data-label>, <chart:equation>, <chart:footer>, <chart:legend>, <chart:plotarea>, <chart:subtitle>, <chart:title>..................................................................................535
19.573.2 <draw:area-polygon>.......................................................................................... 535
19.573.3 <draw:area-rectangle>........................................................................................ 535
19.573.4 <dr3d:scene>...................................................................................................... 535
19.573.5 <draw:caption>, <draw:custom-shape>, <draw:circle>, <draw:control>,<draw:ellipse>, <draw:frame>, <draw:rect>, <draw:page-thumbnail>, <draw:path>,<draw:polygon>, <draw:polyline>, <draw:regular-polygon>...............................................535
19.573.6 <draw:glue-point>............................................................................................... 536
19.573.7 <office:annotation>.............................................................................................. 536
19.573.8 <presentation:placeholder>.................................................................................536
19.574 svg:x1......................................................................................................................... 536
19.574.1 <draw:connector>, <draw:line> and <draw:measure>........................................536
19.574.2 <svg:linearGradient>........................................................................................... 536
19.575 svg:x2 ........................................................................................................................ 537
19.575.1 <draw:connector>, <draw:line> and <draw:measure>........................................537
19.575.2 <svg:linearGradient>........................................................................................... 537
19.576 svg:x-height................................................................................................................ 537
19.577 svg:y........................................................................................................................... 537
19.577.1 <chart:data-label>, <chart:equation>, <chart:footer>, <chart:legend>, <chart:plotarea>, <chart:subtitle>, <chart:title>..................................................................................537
19.577.2 <draw:area-polygon>.......................................................................................... 538
19.577.3 <draw:area-rectangle>........................................................................................ 538
19.577.4 <dr3d:scene>...................................................................................................... 538
19.577.5 <draw:caption>, <draw:custom-shape>, <draw:circle>, <draw:control>,<draw:ellipse>, <draw:frame>, <draw:g>, <draw:rect>, <draw:page-thumbnail>,<draw:path>, <draw:polygon>, <draw:polyline>, <draw:regular-polygon>.........................538
19.577.6 <draw:glue-point>............................................................................................... 538
19.577.7 <office:annotation>.............................................................................................. 539
19.577.8 <presentation:placeholder>.................................................................................539
19.578 svg:y1......................................................................................................................... 539
19.578.1 <draw:connector>, <draw:line> and <draw:measure>........................................539
19.578.2 <svg:linearGradient>........................................................................................... 539
19.579 svg:y2......................................................................................................................... 539
19.579.1 <draw:connector>, <draw:line> and <draw:measure>........................................539
19.579.2 <svg:linearGradient>........................................................................................... 540
19.580 table:acceptance-state............................................................................................... 540

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 51 of 104

19.581 table:algorithm............................................................................................................ 540
19.582 table:add-empty-lines................................................................................................. 540
19.583 table:allow-empty-cell................................................................................................. 541
19.584 table:application-data................................................................................................. 541
19.585 table:automatic-find-labels......................................................................................... 541
19.586 table:base-cell-address.............................................................................................. 542
19.587 table:bind-styles-to-content........................................................................................ 542
19.588 table:border-color....................................................................................................... 542
19.589 table:buttons............................................................................................................... 542
19.590 table:case-sensitive.................................................................................................... 543
19.591 table:cell-address....................................................................................................... 543
19.592 table:cell-range........................................................................................................... 543
19.593 table:cell-range-address............................................................................................. 543
19.593.1 General............................................................................................................... 543
19.593.2 <chart:categories>.............................................................................................. 544
19.593.3 <chart:domain> - bubble.....................................................................................544
19.593.4 <chart:domain>- scatter......................................................................................544
19.593.5 <chart:domain> - surface....................................................................................544
19.593.6 <chart:plot-area> (deprecated)...........................................................................544
19.593.7 <table:highlighted-range>...................................................................................545
19.593.8 <table:named-range>.......................................................................................... 545
19.593.9 <table:source-cell-range>...................................................................................545
19.594 table:column............................................................................................................... 545
19.595 table:comment............................................................................................................ 546
19.596 table:condition............................................................................................................ 546
19.597 table:condition-source................................................................................................ 547
19.598 table:condition-source-range-address........................................................................548
19.599 table:contains-error.................................................................................................... 548
19.600 table:contains-header................................................................................................. 548
19.601 table:content-validation-name....................................................................................548
19.602 table:copy-back.......................................................................................................... 549
19.603 table:copy-formulas.................................................................................................... 549
19.604 table:copy-styles......................................................................................................... 549
19.605 table:count.................................................................................................................. 550
19.606 table:country............................................................................................................... 550
19.607 table:data-field............................................................................................................ 550
19.608 table:data-cell-range-address.....................................................................................550

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 52 of 104

19.609 table:database-name.................................................................................................. 550
19.610 table:database-table-name......................................................................................... 551
19.611 table:data-type............................................................................................................ 551
19.611.1 General................................................................................................................ 551
19.611.2 <table:filter-condition>......................................................................................... 551
19.611.3 <table:sort-by>..................................................................................................... 551
19.611.4 <table:sort-groups>............................................................................................. 552
19.612 table:date-end............................................................................................................ 552
19.613 table:date-start........................................................................................................... 552
19.614 table:date-value.......................................................................................................... 553
19.615 table:default-cell-style-name......................................................................................553
19.616 table:direction............................................................................................................. 553
19.617 table:display............................................................................................................... 553
19.618 table:display-border.................................................................................................... 554
19.619 table:display-duplicates.............................................................................................. 554
19.620 table:display-filter-buttons.......................................................................................... 555
19.621 table:display-list.......................................................................................................... 555
19.622 table:display-member-mode.......................................................................................555
19.623 table:drill-down-on-double-click..................................................................................556
19.624 table:embedded-number-behavior.............................................................................556
19.625 table:enabled.............................................................................................................. 557
19.626 table:end..................................................................................................................... 557
19.627 table:end-cell-address................................................................................................ 558
19.628 table:end-column........................................................................................................ 558
19.629 table:end-position....................................................................................................... 558
19.630 table:end-row.............................................................................................................. 558
19.631 table:end-table............................................................................................................ 559
19.632 table:end-x ................................................................................................................. 559
19.633 table:end-y.................................................................................................................. 559
19.634 table:execute.............................................................................................................. 559
19.635 table:expression......................................................................................................... 560
19.636 table:field-name.......................................................................................................... 560
19.637 table:field-number....................................................................................................... 560
19.638 table:filter-name.......................................................................................................... 561
19.639 table:filter-options....................................................................................................... 561
19.640 table:first-row-end-column (deprecated).....................................................................561
19.641 table:first-row-start-column (deprecated)....................................................................561

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 53 of 104

19.642 table:formula............................................................................................................... 562
19.643 table:function.............................................................................................................. 563
19.643.1 General............................................................................................................... 563
19.643.2 <table:consolidation>.......................................................................................... 563
19.643.3 <table:data-pilot-field>........................................................................................ 563
19.643.4 <table:data-pilot-subtotal>..................................................................................564
19.643.5 <table:subtotal-field>........................................................................................... 564
19.644 table:grand-total......................................................................................................... 564
19.645 table:group-by-field-number.......................................................................................565
19.646 table:grouped-by........................................................................................................ 565
19.647 table:has-persistent-data............................................................................................ 565
19.648 table:id........................................................................................................................ 566
19.649 table:identify-categories............................................................................................. 566
19.650 table:ignore-empty-rows............................................................................................. 566
19.651 table:index.................................................................................................................. 566
19.652 table:is-active............................................................................................................. 567
19.653 table:is-data-layout-field............................................................................................. 567
19.654 table:is-selection......................................................................................................... 567
19.655 table:is-sub-table........................................................................................................ 567
19.656 table:label-cell-range-address....................................................................................568
19.657 table:language............................................................................................................ 568
19.658 table:last-column-spanned......................................................................................... 568
19.659 table:last-row-end-column (deprecated).....................................................................568
19.660 table:last-row-spanned............................................................................................... 569
19.661 table:last-row-start-column (deprecated)....................................................................569
19.662 table:layout-mode....................................................................................................... 569
19.663 table:link-to-source-data............................................................................................. 570
19.664 table:marked-invalid................................................................................................... 570
19.665 table:matrix-covered................................................................................................... 570
19.666 table:maximum-difference........................................................................................... 571
19.667 table:member-count.................................................................................................... 571
19.668 table:member-name.................................................................................................... 571
19.669 table:member-type...................................................................................................... 571
19.670 table:message-type.................................................................................................... 572
19.671 table:mode.................................................................................................................. 572
19.672 table:multi-deletion-spanned......................................................................................572
19.673 table:name.................................................................................................................. 573

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 54 of 104

19.673.1 General............................................................................................................... 573
19.673.2 <table:cell-range-source>...................................................................................573
19.673.3 <table:content-validation>...................................................................................573
19.673.4 <table:data-pilot-group>......................................................................................573
19.673.5 <table:data-pilot-group-member>........................................................................573
19.673.6 <table:data-pilot-member>..................................................................................573
19.673.7 <table:data-pilot-table>.......................................................................................574
19.673.8 <table:database-range>......................................................................................574
19.673.9 <table:named-expression>..................................................................................574
19.673.10 <table:named-range>........................................................................................ 574
19.673.11 <table:operation>.............................................................................................. 574
19.673.12 <table:source-service>......................................................................................575
19.673.13 <table:table>..................................................................................................... 575
19.673.14 <table:table-template>......................................................................................575
19.674 table:null-year............................................................................................................. 575
19.675 table:number-columns-repeated.................................................................................575
19.675.1 General............................................................................................................... 575
19.675.2 <table:covered-table-cell>...................................................................................576
19.675.3 <table:table-cell>................................................................................................. 576
19.675.4 <table:table-column>........................................................................................... 576
19.676 table:number-columns-spanned.................................................................................576
19.677 table:number-rows-repeated......................................................................................577
19.678 table:number-rows-spanned.......................................................................................577
19.679 table:number-matrix-columns-spanned......................................................................577
19.680 table:number-matrix-rows-spanned............................................................................577
19.681 table:object-name....................................................................................................... 578
19.682 table:on-update-keep-size.......................................................................................... 578
19.683 table:on-update-keep-styles.......................................................................................578
19.684 table:operator............................................................................................................. 578
19.685 table:order.................................................................................................................. 579
19.686 table:orientation.......................................................................................................... 580
19.686.1 General............................................................................................................... 580
19.686.2 <table:data-pilot-field>........................................................................................ 580
19.686.3 <table:database-range>......................................................................................580
19.686.4 <table:label-range>............................................................................................. 581
19.687 table:page-breaks-on-group-change..........................................................................581
19.688 table:paragraph-style-name........................................................................................ 581

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 55 of 104

19.689 table:parse-sql-statement........................................................................................... 582
19.690 table:password........................................................................................................... 582
19.691 table:position.............................................................................................................. 582
19.692 table:precision-as-shown............................................................................................ 582
19.693 table:print.................................................................................................................... 583
19.694 table:print-ranges....................................................................................................... 583
19.695 table:protect................................................................................................................ 583
19.696 table:protected............................................................................................................ 584
19.696.1 General............................................................................................................... 584
19.696.2 <table:covered-table-cell> ..................................................................................584
19.696.3 <table:scenario>.................................................................................................. 584
19.696.4 <table:table>....................................................................................................... 584
19.696.5 <table:table-cell> ................................................................................................ 585
19.697 table:protection-key.................................................................................................... 585
19.698 table:protection-key-digest-algorithm.........................................................................585
19.699 table:query-name........................................................................................................ 586
19.700 table:range-usable-as................................................................................................. 586
19.701 table:refresh-delay...................................................................................................... 586
19.702 table:rejecting-change-id............................................................................................ 586
19.703 table:rfc-language-tag................................................................................................ 587
19.704 table:row..................................................................................................................... 587
19.705 table:scenario-ranges................................................................................................. 587
19.706 table:script.................................................................................................................. 587
19.707 table:search-criteria-must-apply-to-whole-cell............................................................588
19.708 table:selected-page.................................................................................................... 588
19.709 table:show-details....................................................................................................... 588
19.710 table:show-empty........................................................................................................ 589
19.711 table:show-filter-button............................................................................................... 589
19.712 table:sort-mode........................................................................................................... 589
19.713 table:source-cell-range-addresses.............................................................................589
19.714 table:source-field-name.............................................................................................. 590
19.715 table:source-name...................................................................................................... 590
19.716 table:sql-statement..................................................................................................... 590
19.717 table:start.................................................................................................................... 590
19.718 table:start-column....................................................................................................... 591
19.719 table:start-position...................................................................................................... 591
19.720 table:start-row............................................................................................................. 591

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 56 of 104

19.721 table:start-table........................................................................................................... 591
19.722 table:status................................................................................................................. 591
19.723 table:step.................................................................................................................... 592
19.724 table:steps.................................................................................................................. 592
19.725 table:structure-protected............................................................................................ 592
19.726 table:style-name......................................................................................................... 592
19.726.1 General............................................................................................................... 592
19.726.2 <table:background>............................................................................................ 593
19.726.3 <table:body>....................................................................................................... 593
19.726.4 <table:covered-table-cell>...................................................................................593
19.726.5 <table:even-columns>......................................................................................... 593
19.726.6 <table:even-rows>............................................................................................... 593
19.726.7 <table:first-column>............................................................................................. 593
19.726.8 <table:first-row>.................................................................................................. 594
19.726.9 <table:last-column>............................................................................................. 594
19.726.10 <table:last-row>................................................................................................. 594
19.726.11 <table:odd-columns>......................................................................................... 594
19.726.12 <table:odd-rows>............................................................................................... 594
19.726.13 <table:table-cell>............................................................................................... 594
19.726.14 <table:table-column>......................................................................................... 595
19.726.15 <table:table-row>.............................................................................................. 595
19.726.16 <table:table>..................................................................................................... 595
19.727 table:table................................................................................................................... 595
19.728 table:table-background............................................................................................... 595
19.729 table:table-name......................................................................................................... 596
19.730 table:target-cell-address............................................................................................. 596
19.731 table:target-range-address......................................................................................... 596
19.731.1 General............................................................................................................... 596
19.731.2 <table:data-pilot-table>.......................................................................................596
19.731.3 <table:database-range>......................................................................................597
19.731.4 <table:filter>........................................................................................................ 597
19.731.5 <table:sort>......................................................................................................... 597
19.732 table:template-name................................................................................................... 597
19.733 table:title..................................................................................................................... 597
19.734 table:track-changes.................................................................................................... 597
19.735 table:type.................................................................................................................... 598
19.735.1 General............................................................................................................... 598

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 57 of 104

19.735.2 <table:data-pilot-field-reference>........................................................................598
19.735.3 <table:deletion> .................................................................................................. 599
19.735.4 <table:insertion>.................................................................................................. 599
19.736 table:use-banding-columns-styles..............................................................................599
19.737 table:use-banding-rows-styles....................................................................................600
19.738 table:use-first-column-styles.......................................................................................600
19.739 table:use-first-row-styles............................................................................................ 600
19.740 table:use-last-column-styles.......................................................................................601
19.741 table:use-last-row-styles............................................................................................. 601
19.742 table:use-labels.......................................................................................................... 601
19.743 table:use-regular-expressions....................................................................................602
19.744 table:use-wildcards..................................................................................................... 602
19.745 table:used-hierarchy................................................................................................... 603
19.746 table:user-name.......................................................................................................... 603
19.747 table:value.................................................................................................................. 603
19.747.1 <table:filter-condition>......................................................................................... 603
19.747.2 <table:filter-set-item>.......................................................................................... 603
19.748 table:value-type.......................................................................................................... 604
19.749 table:visibility.............................................................................................................. 604
19.750 text:active................................................................................................................... 604
19.751 text:address................................................................................................................ 604
19.752 text:alphabetical-separators.......................................................................................605
19.753 text:anchor-page-number........................................................................................... 605
19.754 text:anchor-type.......................................................................................................... 605
19.755 text:annote.................................................................................................................. 606
19.756 text:author................................................................................................................... 607
19.757 text:bibliography-data-field......................................................................................... 607
19.758 text:bibliography-type................................................................................................. 608
19.759 text:booktitle............................................................................................................... 609
19.760 text:bullet-char............................................................................................................ 609
19.761 text:bullet-relative-size................................................................................................ 610
19.762 text:capitalize-entries.................................................................................................. 610
19.763 text:c........................................................................................................................... 611
19.764 text:caption-sequence-format.....................................................................................611
19.765 text:caption-sequence-name.......................................................................................611
19.766 text:change-id............................................................................................................. 611
19.767 text:chapter................................................................................................................. 612

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 58 of 104

19.768 text:citation-body-style-name......................................................................................612
19.769 text:citation-style-name............................................................................................... 612
19.770 text:class-names......................................................................................................... 612
19.770.1 General............................................................................................................... 612
19.770.2 <text:h>............................................................................................................... 612
19.770.3 <text:p>............................................................................................................... 613
19.770.4 <text:span>.......................................................................................................... 613
19.771 text:column-name....................................................................................................... 613
19.772 text:combine-entries................................................................................................... 613
19.773 text:combine-entries-with-dash...................................................................................613
19.774 text:combine-entries-with-pp......................................................................................614
19.775 text:comma-separated................................................................................................ 614
19.776 text:cond-style-name.................................................................................................. 614
19.777 text:condition.............................................................................................................. 615
19.777.1 General............................................................................................................... 615
19.777.2 <text:conditional-text>......................................................................................... 615
19.777.3 <text:database-next>........................................................................................... 615
19.777.4 <text:database-row-select>.................................................................................615
19.777.5 <text:hidden-paragraph>.....................................................................................616
19.777.6 <text:hidden-text>................................................................................................ 616
19.777.7 <text:section>...................................................................................................... 616
19.778 text:connection-name................................................................................................. 616
19.779 text:consecutive-numbering........................................................................................ 616
19.780 text:continue-list......................................................................................................... 617
19.781 text:continue-numbering............................................................................................. 617
19.782 text:copy-outline-levels............................................................................................... 617
19.783 text:count-empty-lines................................................................................................ 617
19.784 text:count-in-text-boxes.............................................................................................. 618
19.785 text:current-value........................................................................................................ 618
19.786 text:custom1............................................................................................................... 618
19.787 text:custom2............................................................................................................... 618
19.788 text:custom3............................................................................................................... 619
19.789 text:custom4............................................................................................................... 619
19.790 text:custom5............................................................................................................... 619
19.791 text:database-name.................................................................................................... 619
19.792 text:date-adjust........................................................................................................... 619
19.793 text:date-value............................................................................................................ 620

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 59 of 104

19.794 text:default-style-name............................................................................................... 620
19.795 text:description........................................................................................................... 620
19.796 text:display.................................................................................................................. 620
19.796.1 General............................................................................................................... 620
19.796.2 <text:chapter>..................................................................................................... 620
19.796.3 <text:expression>................................................................................................ 621
19.796.4 <text:file-name>................................................................................................... 621
19.796.5 <text:index-entry-chapter>..................................................................................621
19.796.6 <text:section>...................................................................................................... 622
19.796.7 <text:table-formula>............................................................................................ 622
19.796.8 <text:template-name>.......................................................................................... 623
19.796.9 <text:user-field-get>............................................................................................ 623
19.796.10 <text:variable-get>............................................................................................ 623
19.796.11 <text:variable-input>.......................................................................................... 624
19.796.12 <text:variable-set>............................................................................................. 624
19.797 text:display-levels....................................................................................................... 624
19.798 text:display-outline-level............................................................................................. 624
19.799 text:duration................................................................................................................ 625
19.800 text:edition.................................................................................................................. 625
19.801 text:editor.................................................................................................................... 625
19.802 text:filter-name............................................................................................................ 625
19.803 text:fixed..................................................................................................................... 625
19.804 text:footnotes-position................................................................................................ 626
19.805 text:formula................................................................................................................. 626
19.806 text:global (deprecated).............................................................................................. 626
19.807 text:howpublished....................................................................................................... 627
19.808 text:increment............................................................................................................. 627
19.809 text:id.......................................................................................................................... 627
19.809.1 General............................................................................................................... 627
19.809.2 <draw:text-box>................................................................................................... 627
19.809.3 <text:alphabetical-index-mark-end> ...................................................................628
19.809.4 <text:alphabetical-index-mark-start>...................................................................628
19.809.5 <text:changed-region>........................................................................................ 628
19.809.6 <text:h>............................................................................................................... 628
19.809.7 <text:note>.......................................................................................................... 629
19.809.8 <text:p>............................................................................................................... 629
19.809.9 <text:toc-mark-end>............................................................................................ 629

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 60 of 104

19.809.10 <text:toc-mark-start>......................................................................................... 630
19.809.11 <text:user-index-mark-end>...............................................................................630
19.809.12 <text:user-index-mark-start>.............................................................................630
19.810 text:identifier............................................................................................................... 630
19.811 text:index-name.......................................................................................................... 630
19.812 text:index-scope......................................................................................................... 631
19.813 text:ignore-case.......................................................................................................... 631
19.814 text:institution............................................................................................................. 631
19.815 text:is-hidden.............................................................................................................. 632
19.816 text:is-list-header........................................................................................................ 632
19.817 text:isbn...................................................................................................................... 632
19.818 text:issn...................................................................................................................... 632
19.819 text:journal.................................................................................................................. 632
19.820 text:key....................................................................................................................... 633
19.821 text:key1..................................................................................................................... 634
19.822 text:key2..................................................................................................................... 634
19.823 text:key1-phonetic...................................................................................................... 634
19.824 text:key2-phonetic...................................................................................................... 635
19.825 text:kind...................................................................................................................... 635
19.826 text:label..................................................................................................................... 635
19.827 text:label-followed-by.................................................................................................. 635
19.828 text:level..................................................................................................................... 636
19.829 text:list-id.................................................................................................................... 636
19.830 text:list-tab-stop-position............................................................................................ 636
19.831 text:main-entry............................................................................................................ 637
19.832 text:main-entry-style-name......................................................................................... 637
19.833 text:master-page-name............................................................................................... 637
19.834 text:month................................................................................................................... 638
19.835 text:name.................................................................................................................... 638
19.835.1 General............................................................................................................... 638
19.835.2 <text:alphabetical-index>....................................................................................638
19.835.3 <text:bibliography>.............................................................................................. 638
19.835.4 <text:bookmark>.................................................................................................. 638
19.835.5 <text:bookmark-end>........................................................................................... 638
19.835.6 <text:bookmark-start>.......................................................................................... 639
19.835.7 <text:execute-macro>.......................................................................................... 639
19.835.8 <text:illustration-index>.......................................................................................639

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 61 of 104

19.835.9 <text:index-title>.................................................................................................. 639
19.835.10 <text:object-index>............................................................................................ 639
19.835.11 <text:reference-mark>.......................................................................................639
19.835.12 <text:reference-mark-end>................................................................................640
19.835.13 <text:reference-mark-start>...............................................................................640
19.835.14 <text:section>.................................................................................................... 640
19.835.15 <text:sequence>................................................................................................ 640
19.835.16 <text:sequence-decl>........................................................................................ 640
19.835.17 <text:table-of-content>......................................................................................640
19.835.18 <text:table-index>.............................................................................................. 641
19.835.19 <text:user-defined>........................................................................................... 641
19.835.20 <text:user-field-decl>......................................................................................... 641
19.835.21 <text:user-field-get>.......................................................................................... 641
19.835.22 <text:user-field-input>.......................................................................................641
19.835.23 <text:user-index>............................................................................................... 641
19.835.24 <text:variable-set>............................................................................................. 642
19.835.25 <text:variable-decl> .......................................................................................... 642
19.835.26 <text:variable-get>............................................................................................ 642
19.835.27 <text:variable-input>.......................................................................................... 642
19.836 text:note...................................................................................................................... 642
19.837 text:note-class............................................................................................................ 642
19.838 text:number................................................................................................................. 643
19.839 text:number-lines........................................................................................................ 643
19.840 text:number-position................................................................................................... 643
19.841 text:numbered-entries................................................................................................. 644
19.842 text:offset.................................................................................................................... 644
19.843 text:organizations....................................................................................................... 644
19.844 text:outline-level......................................................................................................... 644
19.844.1 General............................................................................................................... 644
19.844.2 <text:alphabetical-index-entry-template>............................................................644
19.844.3 <text:chapter>..................................................................................................... 645
19.844.4 <text:h>............................................................................................................... 645
19.844.5 <text:index-entry-chapter>..................................................................................645
19.844.6 <text:index-source-styles>..................................................................................645
19.844.7 <text:user-index-mark>........................................................................................ 645
19.844.8 <text:table-of-content-entry-template>................................................................646
19.844.9 <text:table-of-content-source> ...........................................................................646

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 62 of 104

19.844.10 <text:toc-mark>.................................................................................................. 646
19.844.11 <text:toc-mark-start> ......................................................................................... 646
19.844.12 <text:user-index-entry-template>......................................................................646
19.844.13 <text:user-index-mark-start>.............................................................................647
19.845 text:page-adjust.......................................................................................................... 647
19.845.1 General............................................................................................................... 647
19.845.2 <text:page-number>............................................................................................ 647
19.845.3 <text:page-variable-set>.....................................................................................647
19.846 text:pages................................................................................................................... 647
19.847 text:placeholder-type.................................................................................................. 647
19.848 text:prefix.................................................................................................................... 648
19.849 text:protected.............................................................................................................. 648
19.850 text:protection-key...................................................................................................... 648
19.851 text:protection-key-digest-algorithm...........................................................................649
19.852 text:publisher.............................................................................................................. 649
19.853 text:ref-name............................................................................................................... 649
19.853.1 General............................................................................................................... 649
19.853.2 <text:bookmark-ref>............................................................................................ 649
19.853.3 <text:note-ref>..................................................................................................... 650
19.853.4 <text:reference-ref>............................................................................................. 650
19.853.5 <text:sequence>.................................................................................................. 650
19.853.6 <text:sequence-ref>............................................................................................ 650
19.854 text:reference-format.................................................................................................. 650
19.855 text:relative-tab-stop-position.....................................................................................652
19.856 text:report-type........................................................................................................... 652
19.857 text:restart-numbering................................................................................................ 652
19.858 text:restart-on-page.................................................................................................... 653
19.859 text:row-number.......................................................................................................... 653
19.860 text:school.................................................................................................................. 653
19.861 text:section-name....................................................................................................... 653
19.862 text:series................................................................................................................... 654
19.863 text:select-page.......................................................................................................... 654
19.863.1 General............................................................................................................... 654
19.863.2 <text:page-continuation>.....................................................................................654
19.863.3 <text:page-number>............................................................................................ 654
19.864 text:separation-character............................................................................................ 655
19.865 text:sort-algorithm....................................................................................................... 655

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 63 of 104

19.866 text:sort-ascending..................................................................................................... 655
19.867 text:sort-by-position.................................................................................................... 655
19.868 text:start-value............................................................................................................ 656
19.868.1 General............................................................................................................... 656
19.868.2 <text:h>............................................................................................................... 656
19.868.3 <text:list-item>..................................................................................................... 656
19.868.4 <text:list-level-style-number>..............................................................................656
19.868.5 <text:notes-configuration>...................................................................................656
19.868.6 <text:numbered-paragraph>................................................................................657
19.868.7 <text:outline-level-style>.....................................................................................657
19.869 text:start-numbering-at............................................................................................... 657
19.870 text:string-value-phonetic........................................................................................... 657
19.871 text:string-value.......................................................................................................... 657
19.871.1 General............................................................................................................... 657
19.871.2 <text:alphabetical-index-mark>...........................................................................658
19.871.3 <text:hidden-text>................................................................................................ 658
19.871.4 <text:page-continuation>.....................................................................................658
19.871.5 <text:toc-mark>.................................................................................................... 658
19.871.6 <text:user-index-mark>........................................................................................ 658
19.872 text:string-value-if-false.............................................................................................. 658
19.873 text:string-value-if-true................................................................................................ 659
19.874 text:style-name........................................................................................................... 659
19.874.1 General............................................................................................................... 659
19.874.2 <text:a>............................................................................................................... 659
19.874.3 <text:alphabetical-index>....................................................................................659
19.874.4 <text:alphabetical-index-entry-template>............................................................659
19.874.5 <text:bibliography>.............................................................................................. 659
19.874.6 <text:bibliography-entry-template>......................................................................660
19.874.7 <text:h>............................................................................................................... 660
19.874.8 <text:illustration-index>.......................................................................................660
19.874.9 <text:illustration-index-entry-template>...............................................................660
19.874.10 <text:index-entry-bibliography>.........................................................................660
19.874.11 <text:index-entry-chapter>.................................................................................661
19.874.12 <text:index-entry-link-end>................................................................................661
19.874.13 <text:index-entry-link-start>...............................................................................661
19.874.14 <text:index-entry-page-number>.......................................................................661
19.874.15 <text:index-entry-span>.....................................................................................661

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 64 of 104

19.874.16 <text:index-entry-tab-stop>...............................................................................661
19.874.17 <text:index-entry-text>.......................................................................................662
19.874.18 <text:index-source-style>..................................................................................662
19.874.19 <text:index-title>................................................................................................ 662
19.874.20 <text:index-title-template>.................................................................................662
19.874.21 <text:linenumbering-configuration>...................................................................662
19.874.22 <text:list>........................................................................................................... 662
19.874.23 <text:list-level-style-number>............................................................................663
19.874.24 <text:list-level-style-bullet>................................................................................663
19.874.25 <text:numbered-paragraph>..............................................................................663
19.874.26 <text:object-index>............................................................................................ 663
19.874.27 <text:object-index-entry-template>....................................................................664
19.874.28 <text:outline-level-style>...................................................................................664
19.874.29 <text:p>............................................................................................................. 664
19.874.30 <text:ruby>........................................................................................................ 664
19.874.31 <text:ruby-text>................................................................................................. 664
19.874.32 <text:section>.................................................................................................... 665
19.874.33 <text:span>........................................................................................................ 665
19.874.34 <text:table-index-entry-template>......................................................................665
19.874.35 <text:table-of-content>......................................................................................665
19.874.36 <text:table-of-content-entry-template>..............................................................665
19.874.37 <text:table-index>.............................................................................................. 665
19.874.38 <text:user-index>............................................................................................... 666
19.874.39 <text:user-index-entry-template>......................................................................666
19.875 text:style-override....................................................................................................... 666
19.876 text:suffix..................................................................................................................... 666
19.877 text:tab-ref.................................................................................................................. 666
19.878 text:table-name........................................................................................................... 667
19.879 text:table-type............................................................................................................. 667
19.880 text:time-adjust........................................................................................................... 667
19.881 text:time-value............................................................................................................ 667
19.882 text:title....................................................................................................................... 667
19.883 text:track-changes...................................................................................................... 668
19.884 text:url......................................................................................................................... 668
19.885 text:use-caption.......................................................................................................... 668
19.886 text:use-chart-objects................................................................................................. 668
19.887 text:use-draw-objects.................................................................................................. 669

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 65 of 104

19.888 text:use-floating-frames.............................................................................................. 669
19.889 text:use-graphics........................................................................................................ 669
19.890 text:use-index-marks.................................................................................................. 670
19.891 text:use-index-source-styles.......................................................................................670
19.892 text:use-keys-as-entries............................................................................................. 670
19.893 text:use-math-objects................................................................................................. 671
19.894 text:use-objects........................................................................................................... 671
19.895 text:use-other-objects................................................................................................. 671
19.896 text:use-outline-level.................................................................................................. 672
19.897 text:use-soft-page-breaks........................................................................................... 672
19.898 text:use-spreadsheet-objects......................................................................................673
19.899 text:use-tables............................................................................................................ 673
19.900 text:value.................................................................................................................... 674
19.901 text:visited-style-name................................................................................................ 674
19.902 text:volume................................................................................................................. 674
19.903 text:year...................................................................................................................... 674
19.904 xforms:bind................................................................................................................. 674
19.905 xhtml:about................................................................................................................. 675
19.906 xhtml:content.............................................................................................................. 675
19.907 xhtml:datatype............................................................................................................ 675
19.908 xhtml:property............................................................................................................. 676
19.909 xlink:actuate................................................................................................................ 676
19.910 xlink:href..................................................................................................................... 677
19.910.1 General............................................................................................................... 677
19.910.2 <anim:audio>....................................................................................................... 677
19.910.3 <chart:chart>....................................................................................................... 677
19.910.4 <chart:symbol-image>......................................................................................... 677
19.910.5 <db:component>................................................................................................. 677
19.910.6 <db:connection-resource>..................................................................................678
19.910.7 <db:file-based-database>...................................................................................678
19.910.8 <draw:a>............................................................................................................. 678
19.910.9 <draw:applet>...................................................................................................... 678
19.910.10 <draw:area-circle>............................................................................................ 678
19.910.11 <draw:area-polygon>......................................................................................... 678
19.910.12 <draw:area-rectangle>......................................................................................679
19.910.13 <draw:fill-image>............................................................................................... 679
19.910.14 <draw:floating-frame>.......................................................................................679

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 66 of 104

19.910.15 <draw:image>.................................................................................................... 679
19.910.16 <draw:object>.................................................................................................... 679
19.910.17 <draw:object-ole>.............................................................................................. 679
19.910.18 <draw:plugin>.................................................................................................... 680
19.910.19 <form:button>.................................................................................................... 680
19.910.20 <form:connection-resource>.............................................................................680
19.910.21 <form:image>.................................................................................................... 680
19.910.22 <form:form>....................................................................................................... 680
19.910.23 <meta:auto-reload>........................................................................................... 680
19.910.24 <meta:template>................................................................................................ 680
19.910.25 <presentation:event-listener>............................................................................681
19.910.26 <presentation:sound>.......................................................................................681
19.910.27 <script:event-listener>.......................................................................................681
19.910.28 <style:background-image>................................................................................681
19.910.29 <svg:definition-src>........................................................................................... 681
19.910.30 <svg:font-face-uri>............................................................................................ 681
19.910.31 <table:cell-range-source>.................................................................................682
19.910.32 <table:table-source>......................................................................................... 682
19.910.33 <text:a>............................................................................................................. 682
19.910.34 <text:alphabetical-index-auto-mark-file>...........................................................682
19.910.35 <text:list-level-style-image>...............................................................................682
19.910.36 <text:script>....................................................................................................... 682
19.910.37 <text:section-source>........................................................................................ 683
19.911 xlink:show................................................................................................................... 683
19.912 xlink:title...................................................................................................................... 683
19.913 xlink:type..................................................................................................................... 684
19.914 xml:id.......................................................................................................................... 684
20 Formatting Attributes.............................................................................................................. 686
20.1 General........................................................................................................................... 686
20.2 chart:angle-offset............................................................................................................ 686
20.3 chart:auto-position.......................................................................................................... 686
20.4 chart:auto-size................................................................................................................ 686
20.5 chart:axis-label-position.................................................................................................. 687
20.6 chart:axis-position.......................................................................................................... 687
20.7 chart:connect-bars.......................................................................................................... 688
20.8 chart:data-label-number................................................................................................. 688
20.9 chart:data-label-symbol.................................................................................................. 689

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 67 of 104

20.10 chart:data-label-text...................................................................................................... 689
20.11 chart:deep..................................................................................................................... 689
20.12 chart:display-label........................................................................................................ 690
20.13 chart:error-category...................................................................................................... 690
20.14 chart:error-lower-indicator............................................................................................ 691
20.15 chart:error-lower-limit................................................................................................... 691
20.16 chart:error-lower-range................................................................................................. 691
20.17 chart:error-margin......................................................................................................... 691
20.18 chart:error-percentage.................................................................................................. 692
20.19 chart:error-upper-indicator............................................................................................ 692
20.20 chart:error-upper-limit................................................................................................... 692
20.21 chart:error-upper-range................................................................................................ 692
20.22 chart:gap-width............................................................................................................. 693
20.23 chart:group-bars-per-axis............................................................................................. 693
20.24 chart:hole-size.............................................................................................................. 693
20.25 chart:include-hidden-cells............................................................................................ 694
20.26 chart:interpolation......................................................................................................... 694
20.27 chart:interval-major....................................................................................................... 696
20.28 chart:interval-minor-divisor........................................................................................... 696
20.29 chart:japanese-candle-stick.......................................................................................... 697
20.30 chart:label-arrangement............................................................................................... 697
20.31 chart:label-position....................................................................................................... 697
20.32 chart:label-position-negative........................................................................................ 698
20.33 chart:lines (deprecated)................................................................................................ 699
20.34 chart:link-data-style-to-source......................................................................................699
20.35 chart:logarithmic........................................................................................................... 700
20.36 chart:maximum............................................................................................................. 700
20.37 chart:mean-value.......................................................................................................... 700
20.38 chart:minimum.............................................................................................................. 701
20.39 chart:origin.................................................................................................................... 701
20.40 chart:overlap................................................................................................................. 701
20.41 chart:pie-offset.............................................................................................................. 702
20.42 chart:percentage........................................................................................................... 702
20.43 chart:regression-type.................................................................................................... 702
20.44 chart:reverse-direction.................................................................................................. 703
20.45 chart:right-angled-axes................................................................................................. 703
20.46 chart:scale-text............................................................................................................. 704

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 68 of 104

20.47 chart:series-source (deprecated).................................................................................704
20.48 chart:sort-by-x-values................................................................................................... 704
20.49 chart:solid-type............................................................................................................. 705
20.50 chart:spline-order......................................................................................................... 705
20.51 chart:spline-resolution.................................................................................................. 705
20.52 chart:stacked................................................................................................................ 706
20.53 chart:symbol-height...................................................................................................... 706
20.54 chart:symbol-name....................................................................................................... 706
20.55 chart:symbol-type......................................................................................................... 706
20.56 chart:symbol-width........................................................................................................ 707
20.57 chart:text-overlap.......................................................................................................... 707
20.58 chart:three-dimensional................................................................................................ 707
20.59 chart:tick-marks-major-inner......................................................................................... 708
20.60 chart:tick-marks-major-outer......................................................................................... 708
20.61 chart:tick-marks-minor-inner......................................................................................... 709
20.62 chart:tick-marks-minor-outer......................................................................................... 709
20.63 chart:tick-mark-position................................................................................................ 709
20.64 chart:treat-empty-cells.................................................................................................. 710
20.65 chart:vertical................................................................................................................. 710
20.66 chart:visible................................................................................................................... 711
20.67 dr3d:ambient-color........................................................................................................ 711
20.68 dr3d:back-scale............................................................................................................ 711
20.69 dr3d:backface-culling.................................................................................................... 711
20.70 dr3d:close-back............................................................................................................ 712
20.71 dr3d:close-front............................................................................................................ 712
20.72 dr3d:depth.................................................................................................................... 712
20.73 dr3d:diffuse-color.......................................................................................................... 712
20.74 dr3d:edge-rounding...................................................................................................... 712
20.75 dr3d:edge-rounding-mode............................................................................................ 713
20.76 dr3d:emissive-color...................................................................................................... 713
20.77 dr3d:end-angle............................................................................................................. 713
20.78 dr3d:horizontal-segments............................................................................................. 714
20.79 dr3d:lighting-mode........................................................................................................ 714
20.80 dr3d:normals-direction.................................................................................................. 714
20.81 dr3d:normals-kind......................................................................................................... 714
20.82 dr3d:shadow................................................................................................................. 715
20.83 dr3d:shininess.............................................................................................................. 715

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 69 of 104

20.84 dr3d:specular-color....................................................................................................... 715
20.85 dr3d:texture-filter.......................................................................................................... 715
20.86 dr3d:texture-kind........................................................................................................... 716
20.87 dr3d:texture-mode........................................................................................................ 716
20.88 dr3d:texture-generation-mode-x...................................................................................716
20.89 dr3d:texture-generation-mode-y...................................................................................717
20.90 dr3d:vertical-segments................................................................................................. 717
20.91 draw:auto-grow-height.................................................................................................. 717
20.92 draw:auto-grow-width................................................................................................... 718
20.93 draw:background-size.................................................................................................. 718
20.94 draw:blue...................................................................................................................... 718
20.95 draw:caption-angle....................................................................................................... 719
20.96 draw:caption-angle-type............................................................................................... 719
20.97 draw:caption-escape.................................................................................................... 719
20.98 draw:caption-escape-direction.....................................................................................719
20.99 draw:caption-fit-line-length........................................................................................... 720
20.100 draw:caption-gap........................................................................................................ 720
20.101 draw:caption-line-length............................................................................................. 720
20.102 draw:caption-type....................................................................................................... 720
20.103 draw:color-inversion................................................................................................... 721
20.104 draw:color-mode......................................................................................................... 721
20.105 draw:contrast.............................................................................................................. 721
20.106 draw:decimal-places................................................................................................... 722
20.107 draw:draw-aspect....................................................................................................... 722
20.108 draw:end-guide........................................................................................................... 722
20.109 draw:end-line-spacing-horizontal...............................................................................722
20.110 draw:end-line-spacing-vertical....................................................................................723
20.111 draw:fill........................................................................................................................ 723
20.112 draw:fill-color.............................................................................................................. 723
20.113 draw:fill-gradient-name............................................................................................... 723
20.114 draw:fill-hatch-name................................................................................................... 724
20.115 draw:fill-hatch-solid..................................................................................................... 724
20.116 draw:fill-image-height.................................................................................................. 724
20.117 draw:fill-image-name................................................................................................... 724
20.118 draw:fill-image-ref-point.............................................................................................. 725
20.119 draw:fill-image-ref-point-x........................................................................................... 725
20.120 draw:fill-image-ref-point-y........................................................................................... 725

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 70 of 104

20.121 draw:fill-image-width................................................................................................... 726
20.122 draw:fit-to-contour....................................................................................................... 726
20.123 draw:fit-to-size............................................................................................................ 726
20.124 draw:frame-display-border.......................................................................................... 727
20.125 draw:frame-margin-horizontal.....................................................................................727
20.126 draw:frame-display-scrollbar......................................................................................727
20.127 draw:frame-margin-vertical......................................................................................... 727
20.128 draw:gamma............................................................................................................... 728
20.129 draw:green.................................................................................................................. 728
20.130 draw:gradient-step-count............................................................................................ 728
20.131 draw:guide-distance................................................................................................... 728
20.132 draw:guide-overhang.................................................................................................. 729
20.133 draw:image-opacity.................................................................................................... 729
20.134 draw:line-distance...................................................................................................... 729
20.135 draw:luminance.......................................................................................................... 729
20.136 draw:marker-end......................................................................................................... 729
20.137 draw:marker-end-center............................................................................................. 729
20.138 draw:marker-end-width............................................................................................... 730
20.139 draw:marker-start........................................................................................................ 730
20.140 draw:marker-start-center............................................................................................ 730
20.141 draw:marker-start-width.............................................................................................. 730
20.142 draw:measure-align.................................................................................................... 731
20.143 draw:measure-vertical-align.......................................................................................731
20.144 draw:ole-draw-aspect................................................................................................. 731
20.145 draw:opacity............................................................................................................... 732
20.146 draw:opacity-name..................................................................................................... 732
20.147 draw:parallel............................................................................................................... 732
20.148 draw:placing............................................................................................................... 732
20.149 draw:red...................................................................................................................... 733
20.150 draw:secondary-fill-color............................................................................................ 733
20.151 draw:shadow............................................................................................................... 733
20.152 draw:shadow-color..................................................................................................... 733
20.153 draw:shadow-offset-x.................................................................................................. 734
20.154 draw:shadow-offset-y.................................................................................................. 734
20.155 draw:shadow-opacity.................................................................................................. 734
20.156 draw:show-unit........................................................................................................... 734
20.157 draw:start-guide.......................................................................................................... 734

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 71 of 104

20.158 draw:start-line-spacing-horizontal..............................................................................735
20.159 draw:start-line-spacing-vertical...................................................................................735
20.160 draw:stroke................................................................................................................. 735
20.161 draw:stroke-dash........................................................................................................ 735
20.162 draw:stroke-dash-names............................................................................................ 736
20.163 draw:stroke-linejoin..................................................................................................... 736
20.164 svg:stroke-linecap...................................................................................................... 736
20.165 draw:symbol-color...................................................................................................... 737
20.166 draw:textarea-horizontal-align....................................................................................737
20.167 draw:textarea-vertical-align........................................................................................ 737
20.168 draw:tile-repeat-offset................................................................................................. 737
20.169 draw:visible-area-height............................................................................................. 738
20.170 draw:visible-area-left.................................................................................................. 738
20.171 draw:visible-area-top.................................................................................................. 738
20.172 draw:visible-area-width............................................................................................... 739
20.173 draw:unit..................................................................................................................... 739
20.174 draw:wrap-influence-on-position................................................................................740
20.175 fo:background-color.................................................................................................... 741
20.176 fo Border Properties................................................................................................... 742
20.176.1 General............................................................................................................... 742
20.176.2 fo:border.............................................................................................................. 742
20.176.3 fo:border-bottom.................................................................................................. 742
20.176.4 fo:border-left........................................................................................................ 742
20.176.5 fo:border-right...................................................................................................... 742
20.176.6 fo:border-top........................................................................................................ 743
20.177 fo:break-after.............................................................................................................. 743
20.178 fo:break-before........................................................................................................... 743
20.179 fo:clip.......................................................................................................................... 743
20.180 fo:color........................................................................................................................ 744
20.181 fo:country.................................................................................................................... 744
20.182 fo:font-family............................................................................................................... 744
20.183 fo:font-size.................................................................................................................. 744
20.184 fo:font-style................................................................................................................. 745
20.185 fo:font-variant............................................................................................................. 745
20.186 fo:font-weight.............................................................................................................. 745
20.187 fo:height...................................................................................................................... 746
20.188 fo:hyphenate............................................................................................................... 746

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 72 of 104

20.189 fo:hyphenation-keep................................................................................................... 746
20.190 fo:hyphenation-ladder-count.......................................................................................746
20.191 fo:hyphenation-push-char-count.................................................................................747
20.192 fo:hyphenation-remain-char-count..............................................................................747
20.193 fo:keep-together......................................................................................................... 747
20.194 fo:keep-with-next........................................................................................................ 747
20.195 fo:language................................................................................................................. 747
20.196 fo:letter-spacing.......................................................................................................... 748
20.197 fo:line-height............................................................................................................... 748
20.198 fo:margin..................................................................................................................... 748
20.199 fo:margin-bottom......................................................................................................... 749
20.200 fo:margin-left............................................................................................................... 749
20.201 fo:margin-right............................................................................................................ 749
20.202 fo:margin-top.............................................................................................................. 750
20.203 fo:max-height.............................................................................................................. 750
20.204 fo:max-width............................................................................................................... 750
20.205 fo:min-height............................................................................................................... 750
20.205.1 <style:graphic-properties>...................................................................................750
20.205.2 <style:header-footer-properties>.........................................................................751
20.206 fo:min-width................................................................................................................ 751
20.207 fo:orphans................................................................................................................... 751
20.208 fo:page-height............................................................................................................ 751
20.209 fo:page-width.............................................................................................................. 751
20.210 fo:padding................................................................................................................... 751
20.211 fo:padding-bottom....................................................................................................... 752
20.212 fo:padding-left............................................................................................................. 752
20.213 fo:padding-right.......................................................................................................... 752
20.214 fo:padding-top............................................................................................................ 752
20.215 fo:script....................................................................................................................... 753
20.216 fo:text-align................................................................................................................. 753
20.216.1 <style:paragraph-properties>..............................................................................753
20.216.2 <style:list-level-properties>.................................................................................753
20.217 fo:text-align-last.......................................................................................................... 754
20.218 fo:text-indent............................................................................................................... 754
20.219 fo:text-shadow............................................................................................................ 754
20.220 fo:text-transform.......................................................................................................... 755
20.221 fo:widows.................................................................................................................... 755

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 73 of 104

20.222 fo:width....................................................................................................................... 755
20.223 fo:wrap-option............................................................................................................. 755
20.224 presentation:background-objects-visible....................................................................756
20.225 presentation:background-visible.................................................................................756
20.226 presentation:display-date-time...................................................................................756
20.227 presentation:display-footer......................................................................................... 757
20.228 presentation:display-header.......................................................................................757
20.229 presentation:display-page-number.............................................................................757
20.230 presentation:duration.................................................................................................. 758
20.231 presentation:transition-speed.....................................................................................758
20.232 presentation:transition-style.......................................................................................758
20.233 presentation:transition-type........................................................................................ 761
20.234 presentation:visibility.................................................................................................. 762
20.235 smil:direction.............................................................................................................. 762
20.236 smil:fadeColor............................................................................................................. 762
20.237 smil:subtype................................................................................................................ 762
20.238 smil:type..................................................................................................................... 763
20.239 style:auto-text-indent.................................................................................................. 763
20.240 style:background-transparency..................................................................................763
20.241 style:border-line-width................................................................................................ 763
20.242 style:border-line-width-bottom....................................................................................764
20.243 style:border-line-width-left.......................................................................................... 764
20.244 style:border-line-width-right........................................................................................ 765
20.245 style:border-line-width-top.......................................................................................... 765
20.246 style:cell-protect......................................................................................................... 765
20.247 style:column-width...................................................................................................... 766
20.248 style:country-asian..................................................................................................... 766
20.249 style:country-complex................................................................................................. 766
20.250 style:decimal-places................................................................................................... 766
20.251 style:diagonal-bl-tr...................................................................................................... 767
20.252 style:diagonal-bl-tr-widths........................................................................................... 767
20.253 style:diagonal-tl-br...................................................................................................... 767
20.254 style:diagonal-tl-br-widths........................................................................................... 767
20.255 style:direction............................................................................................................. 767
20.256 style:dynamic-spacing................................................................................................ 768
20.257 style:editable.............................................................................................................. 768
20.258 style:first-page-number............................................................................................... 768

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 74 of 104

20.259 style:flow-with-text...................................................................................................... 769
20.260 style:font-charset........................................................................................................ 770
20.261 style:font-charset-asian.............................................................................................. 770
20.262 style:font-charset-complex.......................................................................................... 771
20.263 style:font-family-asian................................................................................................. 771
20.264 style:font-family-complex............................................................................................ 771
20.265 style:font-family-generic............................................................................................. 772
20.266 style:font-family-generic-asian....................................................................................772
20.267 style:font-family-generic-complex...............................................................................773
20.268 style:font-independent-line-spacing...........................................................................773
20.269 style:font-name........................................................................................................... 774
20.270 style:font-name-asian................................................................................................. 774
20.271 style:font-name-complex............................................................................................. 774
20.272 style:font-pitch............................................................................................................ 774
20.273 style:font-pitch-asian.................................................................................................. 775
20.274 style:font-pitch-complex.............................................................................................. 775
20.275 style:font-relief............................................................................................................ 775
20.276 style:font-size-asian.................................................................................................... 776
20.277 style:font-size-complex............................................................................................... 776
20.278 style:font-size-rel........................................................................................................ 776
20.279 style:font-size-rel-asian.............................................................................................. 777
20.280 style:font-size-rel-complex.......................................................................................... 777
20.281 style:font-style-asian................................................................................................... 777
20.282 style:font-style-complex.............................................................................................. 778
20.283 style:font-style-name.................................................................................................. 778
20.284 style:font-style-name-asian......................................................................................... 778
20.285 style:font-style-name-complex....................................................................................779
20.286 style:font-weight-asian................................................................................................ 779
20.287 style:font-weight-complex........................................................................................... 779
20.288 style:footnote-max-height........................................................................................... 779
20.289 style:glyph-orientation-vertical....................................................................................780
20.290 style:horizontal-pos.................................................................................................... 780
20.291 style:horizontal-rel...................................................................................................... 782
20.292 style:join-border.......................................................................................................... 782
20.293 style:justify-single-word.............................................................................................. 783
20.294 style:language-asian.................................................................................................. 784
20.295 style:language-complex.............................................................................................. 784

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 75 of 104

20.296 style:layout-grid-base-height......................................................................................784
20.297 style:layout-grid-base-width........................................................................................ 784
20.298 style:layout-grid-color................................................................................................. 785
20.299 style:layout-grid-display.............................................................................................. 785
20.300 style:layout-grid-lines................................................................................................. 785
20.301 style:layout-grid-mode................................................................................................ 785
20.302 style:layout-grid-print.................................................................................................. 786
20.303 style:layout-grid-ruby-below.......................................................................................786
20.304 style:layout-grid-ruby-height.......................................................................................786
20.305 style:layout-grid-snap-to............................................................................................. 786
20.306 style:layout-grid-standard-mode.................................................................................787
20.307 style:line-break........................................................................................................... 787
20.308 style:letter-kerning...................................................................................................... 787
20.309 style:line-height-at-least............................................................................................. 788
20.310 style:line-spacing........................................................................................................ 788
20.311 style:may-break-between-rows...................................................................................788
20.312 style:min-row-height................................................................................................... 788
20.313 style:mirror.................................................................................................................. 789
20.314 style:num-format......................................................................................................... 789
20.315 style:num-letter-sync.................................................................................................. 790
20.316 style:num-prefix.......................................................................................................... 790
20.317 style:num-suffix........................................................................................................... 790
20.318 style:number-wrapped-paragraphs.............................................................................791
20.319 style:overflow-behavior............................................................................................... 791
20.320 style:page-number...................................................................................................... 791
20.321 style:paper-tray-name................................................................................................. 792
20.322 style:print.................................................................................................................... 792
20.323 style:print-content....................................................................................................... 793
20.323.1 General............................................................................................................... 793
20.323.2 <style:graphic-properties>...................................................................................793
20.323.3 <style:table-cell-properties>................................................................................793
20.324 style:print-page-order................................................................................................. 793
20.325 style:print-orientation.................................................................................................. 793
20.326 style:protect................................................................................................................ 794
20.326.1 General............................................................................................................... 794
20.326.2 <style:graphic-properties>...................................................................................794
20.326.3 <style:section-properties>...................................................................................794

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 76 of 104

20.327 style:punctuation-wrap................................................................................................ 795
20.328 style:register-true........................................................................................................ 795
20.329 style:register-truth-ref-style-name..............................................................................795
20.330 style:rel-column-width................................................................................................. 795
20.331 style:rel-height............................................................................................................ 796
20.332 style:rel-width............................................................................................................. 796
20.332.1 <style:graphic-properties>...................................................................................796
20.332.2 <style:table-properties>.......................................................................................797
20.333 style:repeat................................................................................................................. 797
20.334 style:repeat-content.................................................................................................... 797
20.335 style:rfc-language-tag................................................................................................. 797
20.336 style:rfc-language-tag-asian.......................................................................................798
20.337 style:rfc-language-tag-complex..................................................................................798
20.338 style:rotation-align...................................................................................................... 799
20.339 style:rotation-angle..................................................................................................... 799
20.340 style:row-height.......................................................................................................... 799
20.341 style:ruby-align........................................................................................................... 800
20.342 style:ruby-position...................................................................................................... 800
20.343 style:run-through........................................................................................................ 800
20.344 style:scale-to.............................................................................................................. 801
20.345 style:scale-to-pages................................................................................................... 801
20.346 style:script-asian......................................................................................................... 801
20.347 style:script-complex.................................................................................................... 801
20.348 style:script-type.......................................................................................................... 802
20.349 style:shadow............................................................................................................... 803
20.350 style:shrink-to-fit......................................................................................................... 803
20.351 style:snap-to-layout-grid............................................................................................. 803
20.352 style:tab-stop-distance............................................................................................... 804
20.353 style:table-centering................................................................................................... 804
20.354 style:text-align-source................................................................................................ 804
20.355 style:text-autospace.................................................................................................... 805
20.356 style:text-blinking........................................................................................................ 805
20.357 style:text-combine....................................................................................................... 805
20.358 style:text-combine-start-char......................................................................................806
20.359 style:text-combine-end-char.......................................................................................806
20.360 style:text-emphasize................................................................................................... 806
20.361 style:text-line-through-color........................................................................................ 806

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 77 of 104

20.362 style:text-line-through-mode.......................................................................................807
20.363 style:text-line-through-style........................................................................................ 807
20.364 style:text-line-through-text.......................................................................................... 808
20.365 style:text-line-through-text-style.................................................................................808
20.366 style:text-line-through-type......................................................................................... 808
20.367 style:text-line-through-width.......................................................................................809
20.368 style:text-outline......................................................................................................... 809
20.369 style:text-overline-color.............................................................................................. 809
20.370 style:text-overline-mode............................................................................................. 810
20.371 style:text-overline-style............................................................................................... 810
20.372 style:text-overline-type................................................................................................ 811
20.373 style:text-overline-width.............................................................................................. 811
20.374 style:text-position........................................................................................................ 812
20.375 style:text-rotation-angle.............................................................................................. 812
20.376 style:text-rotation-scale.............................................................................................. 812
20.377 style:text-scale............................................................................................................ 812
20.378 style:text-underline-color............................................................................................ 813
20.379 style:text-underline-mode........................................................................................... 813
20.380 style:text-underline-style............................................................................................. 813
20.381 style:text-underline-type............................................................................................. 814
20.382 style:text-underline-width............................................................................................ 814
20.383 style:use-optimal-column-width..................................................................................815
20.384 style:use-optimal-row-height.......................................................................................815
20.385 style:use-window-font-color........................................................................................ 815
20.386 style:vertical-align....................................................................................................... 816
20.386.1 <style:paragraph-properties>..............................................................................816
20.386.2 <style:table-cell-properties>................................................................................816
20.387 style:vertical-pos......................................................................................................... 816
20.388 style:vertical-rel.......................................................................................................... 817
20.389 style:width................................................................................................................... 818
20.390 style:wrap................................................................................................................... 818
20.391 style:wrap-contour...................................................................................................... 819
20.392 style:wrap-contour-mode............................................................................................ 819
20.393 style:wrap-dynamic-threshold.....................................................................................819
20.394 style:writing-mode....................................................................................................... 820
20.394.1 General............................................................................................................... 820
20.394.2 <style:graphic-properties>...................................................................................820

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 78 of 104

20.394.3 <style:page-layout-properties>............................................................................820
20.394.4 <style:paragraph-properties>..............................................................................820
20.394.5 <style:section-properties>...................................................................................820
20.394.6 <style:table-cell-properties>................................................................................821
20.394.7 <style:table-properties>.......................................................................................821
20.395 style:writing-mode-automatic......................................................................................821
20.396 svg:fill-rule.................................................................................................................. 821
20.397 svg:height................................................................................................................... 822
20.397.1 <style:graphic-properties>...................................................................................822
20.397.2 <style:header-footer-properties>.........................................................................822
20.398 svg:stroke-color.......................................................................................................... 822
20.399 svg:stroke-opacity....................................................................................................... 822
20.400 svg:stroke-width.......................................................................................................... 822
20.401 svg:x........................................................................................................................... 823
20.402 svg:y........................................................................................................................... 823
20.402.1 <style:graphic-properties>...................................................................................823
20.402.2 <style:list-level-properties>.................................................................................823
20.403 svg:width..................................................................................................................... 823
20.404 table:align................................................................................................................... 823
20.405 table:border-model..................................................................................................... 824
20.406 table:display............................................................................................................... 824
20.407 text:anchor-page-number........................................................................................... 824
20.408 text:anchor-type.......................................................................................................... 825
20.409 text:animation............................................................................................................. 826
20.410 text:animation-delay................................................................................................... 826
20.411 text:animation-direction............................................................................................... 826
20.412 text:animation-repeat.................................................................................................. 827
20.413 text:animation-start-inside.......................................................................................... 827
20.414 text:animation-steps................................................................................................... 827
20.415 text:animation-stop-inside........................................................................................... 827
20.416 text:condition.............................................................................................................. 828
20.417 text:display.................................................................................................................. 828
20.418 text:dont-balance-text-columns...................................................................................828
20.419 text:line-break............................................................................................................. 828
20.420 text:line-number.......................................................................................................... 829
20.421 text:list-level-position-and-space-mode......................................................................829
20.422 text:min-label-distance................................................................................................ 829

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 79 of 104

20.423 text:min-label-width..................................................................................................... 830
20.424 text:number-lines........................................................................................................ 830
20.425 text:space-before........................................................................................................ 830
Appendix A. OpenDocument Relax NG Schema.......................................................................832
Appendix B. OpenDocument Metadata Manifest Ontology........................................................833
Appendix C. MIME Types and File Name Extensions (Non Normative)....................................834
Appendix D. Accessibility Guidelines (Non Normative).............................................................836
D.1. Title, Description and Caption of Graphical Elements.........................................................836
D.1.1. Guidance for authors........................................................................................................ 836
D.1.2. Authoring tool responsibility for presenting and prompting for the <svg:title> and<svg:desc> elements.................................................................................................................. 836
D.2. Hyperlink Titles.................................................................................................................... 837
D.3. Tables in Presentations....................................................................................................... 837
D.4. Further Guidelines.............................................................................................................. 837
Appendix E. Bidirectional (BiDi) Scripts,Numeric Digits Presentation and Calendars (NonNormative).................................................................................................................................. 838
E.1. Paragraph and Layout Direction.......................................................................................... 838
E.2. Numeric Digits Presentation and Calendars.......................................................................839
Appendix F. Recommended Usage of SMIL..............................................................................840
F.1. Slide Animation.................................................................................................................... 840
F.2. Main Sequence.................................................................................................................... 840
F.3. Interactive Sequence........................................................................................................... 841
Appendix G. Changes From Previous Specification Versions (Non Normative)........................842
G.1. Changes from “Open Document Format for Office Applications (OpenDocument) v1.1”....842

Table of Contents Part 2
1 Introduction................................................................................................................................ 19
1.1 Introduction......................................................................................................................... 19
1.2 Terminology........................................................................................................................ 19
1.3 Purpose.............................................................................................................................. 19
1.4 Normative References........................................................................................................ 19
1.5 Non-Normative References................................................................................................ 20
2 Expressions and Evaluators...................................................................................................... 21
2.1 Introduction......................................................................................................................... 21
2.2 OpenDocument Formula Expression..................................................................................21
2.3 Evaluators........................................................................................................................... 21
2.3.1 OpenDocument Formula Evaluator.............................................................................21

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 80 of 104

2.3.2 OpenDocument Formula Small Group Evaluator........................................................21
2.3.3 OpenDocument Formula Medium Group Evaluator....................................................222.3.4 OpenDocument Formula Large Group Evaluator........................................................23
2.4 Variances (Implementation-defined, Unspecified, and Behavioral Changes).....................24
3 Formula Processing Model........................................................................................................ 25
3.1 General............................................................................................................................... 25
3.2 Expression Evaluation........................................................................................................ 25
3.2.1 General....................................................................................................................... 25
3.2.2 Expression Calculation ............................................................................................... 25
3.2.3 Operator and Function Evaluation..............................................................................25
3.3 Non-Scalar Evaluation (aka 'Array expressions')...............................................................26
3.4 Host-Defined Behaviors...................................................................................................... 28
3.5 When recalculation occurs................................................................................................. 29
3.6 Numerical Models............................................................................................................... 29
3.7 Basic Limits........................................................................................................................ 29
4 Types......................................................................................................................................... 31
4.1 General............................................................................................................................... 31
4.2 Text (String)........................................................................................................................ 31
4.3 Number............................................................................................................................... 31
4.3.1 General....................................................................................................................... 31
4.3.2 Time............................................................................................................................. 32
4.3.3 Date............................................................................................................................. 32
4.3.4 DateTime..................................................................................................................... 32
4.3.5 Percentage.................................................................................................................. 32
4.3.6 Currency...................................................................................................................... 32
4.3.7 Logical (Number)......................................................................................................... 32
4.4 Complex Number................................................................................................................ 33
4.5 Logical (Boolean)............................................................................................................... 33
4.6 Error.................................................................................................................................... 33
4.7 Empty Cell.......................................................................................................................... 34
4.8 Reference........................................................................................................................... 34
4.9 ReferenceList..................................................................................................................... 34
4.10 Array................................................................................................................................. 34
4.11 Pseudotypes..................................................................................................................... 34
4.11.1 General...................................................................................................................... 34
4.11.2 Scalar........................................................................................................................ 35
4.11.3 DateParam................................................................................................................. 35

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 81 of 104

4.11.4 TimeParam................................................................................................................ 35
4.11.5 Integer....................................................................................................................... 35
4.11.6 TextOrNumber.......................................................................................................... 35
4.11.7 Basis.......................................................................................................................... 35
4.11.8 Criterion..................................................................................................................... 37
4.11.9 Database................................................................................................................... 38
4.11.10 Field......................................................................................................................... 38
4.11.11 Criteria..................................................................................................................... 38
4.11.12 Sequences (NumberSequence, NumberSequenceList, DateSequence,
LogicalSequence, and ComplexSequence).........................................................................38
4.11.13 Any........................................................................................................................... 39
5 Expression Syntax..................................................................................................................... 40
5.1 General............................................................................................................................... 40
5.2 Basic Expressions.............................................................................................................. 40
5.3 Constant Numbers.............................................................................................................. 41
5.4 Constant Strings................................................................................................................. 41
5.5 Operators............................................................................................................................ 41
5.6 Functions and Function Parameters...................................................................................42
5.7 Nonstandard Function Names............................................................................................ 43
5.8 References......................................................................................................................... 43
5.9 Reference List.................................................................................................................... 44
5.10 Quoted Label.................................................................................................................... 45
5.10.1 General..................................................................................................................... 45
5.10.2 Lookup of Defined Labels......................................................................................... 45
5.10.3 Automatic Lookup of Labels......................................................................................45
5.10.4 Implicit Intersection................................................................................................... 46
5.10.5 Automatic Range....................................................................................................... 46
5.10.6 Automatic Intersection............................................................................................... 47
5.11 Named Expressions.......................................................................................................... 47
5.12 Constant Errors................................................................................................................ 48
5.13 Inline Arrays...................................................................................................................... 49
5.14 Whitespace....................................................................................................................... 49
6 Standard Operators and Functions............................................................................................ 50
6.1 General............................................................................................................................... 50
6.2 Common Template for Functions and Operators................................................................50
6.3 Implicit Conversion Operators............................................................................................ 51
6.3.1 General....................................................................................................................... 51

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 82 of 104

6.3.2 Conversion to Scalar................................................................................................... 51
6.3.3 Implied intersection..................................................................................................... 51
6.3.4 Force to array context (ForceArray)............................................................................51
6.3.5 Conversion to Number................................................................................................ 52
6.3.6 Conversion to Integer.................................................................................................. 52
6.3.7 Conversion to NumberSequence................................................................................52
6.3.8 Conversion to NumberSequenceList...........................................................................53
6.3.9 Conversion to DateSequence.....................................................................................53
6.3.10 Conversion to Complex Number...............................................................................53
6.3.11 Conversion to ComplexSequence.............................................................................53
6.3.12 Conversion to Logical................................................................................................ 53
6.3.13 Conversion to LogicalSequence...............................................................................54
6.3.14 Conversion to Text..................................................................................................... 54
6.3.15 Conversion to DateParam......................................................................................... 54
6.3.16 Conversion to TimeParam......................................................................................... 54
6.4 Standard Operators............................................................................................................ 55
6.4.1 General....................................................................................................................... 55
6.4.2 Infix Operator "+"......................................................................................................... 55
6.4.3 Infix Operator "-".......................................................................................................... 55
6.4.4 Infix Operator "*".......................................................................................................... 55
6.4.5 Infix Operator "/".......................................................................................................... 56
6.4.6 Infix Operator "^"......................................................................................................... 56
6.4.7 Infix Operator "="......................................................................................................... 56
6.4.8 Infix Operator "<>"....................................................................................................... 56
6.4.9 Infix Operator Ordered Comparison ("<", "<=", ">", ">=")............................................57
6.4.10 Infix Operator "&"....................................................................................................... 57
6.4.11 Infix Operator Reference Range (":").........................................................................57
6.4.12 Infix Operator Reference Intersection ("!")................................................................58
6.4.13 Infix Operator Reference Concatenation ("~") (aka Union).......................................58
6.4.14 Postfix Operator "%".................................................................................................. 59
6.4.15 Prefix Operator "+".................................................................................................... 59
6.4.16 Prefix Operator "-"..................................................................................................... 59
6.5 Matrix Functions................................................................................................................. 60
6.5.1 General....................................................................................................................... 60
6.5.2 MDETERM.................................................................................................................. 60
6.5.3 MINVERSE.................................................................................................................. 60
6.5.4 MMULT........................................................................................................................ 61

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 83 of 104

6.5.5 MUNIT......................................................................................................................... 61
6.5.6 TRANSPOSE.............................................................................................................. 61
6.6 Bit operation functions........................................................................................................ 62
6.6.1 General....................................................................................................................... 62
6.6.2 BITAND....................................................................................................................... 62
6.6.3 BITLSHIFT.................................................................................................................. 62
6.6.4 BITOR......................................................................................................................... 62
6.6.5 BITRSHIFT.................................................................................................................. 63
6.6.6 BITXOR....................................................................................................................... 63
6.7 Byte-position text functions................................................................................................. 63
6.7.1 General....................................................................................................................... 63
6.7.2 FINDB.......................................................................................................................... 63
6.7.3 LEFTB......................................................................................................................... 64
6.7.4 LENB........................................................................................................................... 64
6.7.5 MIDB........................................................................................................................... 64
6.7.6 REPLACEB................................................................................................................. 64
6.7.7 RIGHTB....................................................................................................................... 65
6.7.8 SEARCHB................................................................................................................... 65
6.8 Complex Number Functions............................................................................................... 65
6.8.1 General....................................................................................................................... 65
6.8.2 COMPLEX................................................................................................................... 65
6.8.3 IMABS......................................................................................................................... 65
6.8.4 IMAGINARY................................................................................................................ 66
6.8.5 IMARGUMENT............................................................................................................ 66
6.8.6 IMCONJUGATE........................................................................................................... 66
6.8.7 IMCOS......................................................................................................................... 66
6.8.8 IMCOSH ..................................................................................................................... 66
6.8.9 IMCOT......................................................................................................................... 67
6.8.10 IMCSC....................................................................................................................... 67
6.8.11 IMCSCH..................................................................................................................... 67
6.8.12 IMDIV........................................................................................................................ 67
6.8.13 IMEXP....................................................................................................................... 68
6.8.14 IMLN.......................................................................................................................... 68
6.8.15 IMLOG10................................................................................................................... 68
6.8.16 IMLOG2..................................................................................................................... 68
6.8.17 IMPOWER................................................................................................................. 69
6.8.18 IMPRODUCT............................................................................................................. 69

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 84 of 104

6.8.19 IMREAL..................................................................................................................... 69
6.8.20 IMSIN........................................................................................................................ 69
6.8.21 IMSINH...................................................................................................................... 70
6.8.22 IMSEC....................................................................................................................... 70
6.8.23 IMSECH.................................................................................................................... 70
6.8.24 IMSQRT.................................................................................................................... 70
6.8.25 IMSUB....................................................................................................................... 71
6.8.26 IMSUM...................................................................................................................... 71
6.8.27 IMTAN....................................................................................................................... 71
6.9 Database Functions............................................................................................................ 71
6.9.1 General....................................................................................................................... 71
6.9.2 DAVERAGE................................................................................................................. 72
6.9.3 DCOUNT..................................................................................................................... 72
6.9.4 DCOUNTA................................................................................................................... 72
6.9.5 DGET.......................................................................................................................... 72
6.9.6 DMAX.......................................................................................................................... 73
6.9.7 DMIN........................................................................................................................... 73
6.9.8 DPRODUCT................................................................................................................ 73
6.9.9 DSTDEV...................................................................................................................... 73
6.9.10 DSTDEVP................................................................................................................. 74
6.9.11 DSUM........................................................................................................................ 74
6.9.12 DVAR......................................................................................................................... 74
6.9.13 DVARP...................................................................................................................... 74
6.10 Date and Time Functions.................................................................................................. 75
6.10.1 General..................................................................................................................... 75
6.10.2 DATE......................................................................................................................... 75
6.10.3 DATEDIF................................................................................................................... 75
6.10.4 DATEVALUE.............................................................................................................. 76
6.10.5 DAY........................................................................................................................... 76
6.10.6 DAYS......................................................................................................................... 76
6.10.7 DAYS360................................................................................................................... 76
6.10.8 EDATE....................................................................................................................... 77
6.10.9 EOMONTH................................................................................................................ 78
6.10.10 HOUR...................................................................................................................... 78
6.10.11 ISOWEEKNUM........................................................................................................ 78
6.10.12 MINUTE................................................................................................................... 78
6.10.13 MONTH................................................................................................................... 79

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 85 of 104

6.10.14 NETWORKDAYS.................................................................................................... 79
6.10.15 NOW....................................................................................................................... 79
6.10.16 SECOND................................................................................................................. 80
6.10.17 TIME........................................................................................................................ 80
6.10.18 TIMEVALUE............................................................................................................ 80
6.10.19 TODAY.................................................................................................................... 81
6.10.20 WEEKDAY............................................................................................................... 81
6.10.21 WEEKNUM.............................................................................................................. 82
6.10.22 WORKDAY.............................................................................................................. 82
6.10.23 YEAR....................................................................................................................... 82
6.10.24 YEARFRAC............................................................................................................. 83
6.11 External Access Functions................................................................................................ 83
6.11.1 General...................................................................................................................... 83
6.11.2 DDE........................................................................................................................... 83
6.11.3 HYPERLINK.............................................................................................................. 84
6.12 Financial Functions.......................................................................................................... 84
6.12.1 General..................................................................................................................... 84
6.12.2 ACCRINT................................................................................................................... 84
6.12.3 ACCRINTM................................................................................................................ 85
6.12.4 AMORLINC................................................................................................................ 86
6.12.5 COUPDAYBS............................................................................................................ 86
6.12.6 COUPDAYS............................................................................................................... 87
6.12.7 COUPDAYSNC......................................................................................................... 88
6.12.8 COUPNCD................................................................................................................ 88
6.12.9 COUPNUM................................................................................................................ 89
6.12.10 COUPPCD.............................................................................................................. 89
6.12.11 CUMIPMT................................................................................................................ 90
6.12.12 CUMPRINC............................................................................................................. 90
6.12.13 DB........................................................................................................................... 91
6.12.14 DDB......................................................................................................................... 92
6.12.15 DISC........................................................................................................................ 93
6.12.16 DOLLARDE............................................................................................................. 94
6.12.17 DOLLARFR............................................................................................................. 94
6.12.18 DURATION.............................................................................................................. 94
6.12.19 EFFECT.................................................................................................................. 95
6.12.20 FV............................................................................................................................ 95
6.12.21 FVSCHEDULE........................................................................................................ 96

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 86 of 104

6.12.22 INTRATE................................................................................................................. 96
6.12.23 IPMT........................................................................................................................ 96
6.12.24 IRR.......................................................................................................................... 97
6.12.25 ISPMT..................................................................................................................... 97
6.12.26 MDURATION........................................................................................................... 98
6.12.27 MIRR....................................................................................................................... 98
6.12.28 NOMINAL................................................................................................................ 99
6.12.29 NPER...................................................................................................................... 99
6.12.30 NPV....................................................................................................................... 100
6.12.31 ODDFPRICE......................................................................................................... 100
6.12.32 ODDFYIELD.......................................................................................................... 101
6.12.33 ODDLPRICE......................................................................................................... 101
6.12.34 ODDLYIELD.......................................................................................................... 102
6.12.35 PDURATION.......................................................................................................... 102
6.12.36 PMT....................................................................................................................... 103
6.12.37 PPMT.................................................................................................................... 103
6.12.38 PRICE................................................................................................................... 104
6.12.39 PRICEDISC........................................................................................................... 104
6.12.40 PRICEMAT............................................................................................................ 105
6.12.41 PV.......................................................................................................................... 105
6.12.42 RATE..................................................................................................................... 106
6.12.43 RECEIVED............................................................................................................ 107
6.12.44 RRI........................................................................................................................ 107
6.12.45 SLN....................................................................................................................... 107
6.12.46 SYD....................................................................................................................... 108
6.12.47 TBILLEQ................................................................................................................ 108
6.12.48 TBILLPRICE.......................................................................................................... 109
6.12.49 TBILLYIELD........................................................................................................... 109
6.12.50 VDB....................................................................................................................... 109
6.12.51 XIRR...................................................................................................................... 110
6.12.52 XNPV..................................................................................................................... 111
6.12.53 YIELD..................................................................................................................... 111
6.12.54 YIELDDISC............................................................................................................ 112
6.12.55 YIELDMAT............................................................................................................. 112
6.13 Information Functions..................................................................................................... 113
6.13.1 General.................................................................................................................... 113
6.13.2 AREAS..................................................................................................................... 113

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 87 of 104

6.13.3 CELL........................................................................................................................ 113
6.13.4 COLUMN................................................................................................................. 115
6.13.5 COLUMNS............................................................................................................... 115
6.13.6 COUNT.................................................................................................................... 116
6.13.7 COUNTA.................................................................................................................. 116
6.13.8 COUNTBLANK........................................................................................................ 116
6.13.9 COUNTIF................................................................................................................. 117
6.13.10 COUNTIFS............................................................................................................ 117
6.13.11 ERROR.TYPE........................................................................................................ 117
6.13.12 FORMULA............................................................................................................. 118
6.13.13 INFO...................................................................................................................... 118
6.13.14 ISBLANK................................................................................................................ 119
6.13.15 ISERR.................................................................................................................... 119
6.13.16 ISERROR.............................................................................................................. 119
6.13.17 ISEVEN................................................................................................................. 120
6.13.18 ISFORMULA......................................................................................................... 120
6.13.19 ISLOGICAL........................................................................................................... 120
6.13.20 ISNA...................................................................................................................... 120
6.13.21 ISNONTEXT.......................................................................................................... 121
6.13.22 ISNUMBER............................................................................................................ 121
6.13.23 ISODD................................................................................................................... 121
6.13.24 ISREF.................................................................................................................... 122
6.13.25 ISTEXT.................................................................................................................. 122
6.13.26 N............................................................................................................................ 122
6.13.27 NA......................................................................................................................... 122
6.13.28 NUMBERVALUE.................................................................................................... 123
6.13.29 ROW..................................................................................................................... 123
6.13.30 ROWS................................................................................................................... 123
6.13.31 SHEET.................................................................................................................. 124
6.13.32 SHEETS................................................................................................................ 124
6.13.33 TYPE..................................................................................................................... 124
6.13.34 VALUE................................................................................................................... 125
6.14 Lookup Functions........................................................................................................... 127
6.14.1 General................................................................................................................... 127
6.14.2 ADDRESS............................................................................................................... 127
6.14.3 CHOOSE................................................................................................................. 127
6.14.4 GETPIVOTDATA..................................................................................................... 128

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 88 of 104

6.14.5 HLOOKUP............................................................................................................... 128
6.14.6 INDEX..................................................................................................................... 129
6.14.7 INDIRECT............................................................................................................... 130
6.14.8 LOOKUP................................................................................................................. 130
6.14.9 MATCH.................................................................................................................... 131
6.14.10 MULTIPLE.OPERATIONS.....................................................................................132
6.14.11 OFFSET................................................................................................................ 133
6.14.12 VLOOKUP............................................................................................................. 134
6.15 Logical Functions........................................................................................................... 134
6.15.1 General................................................................................................................... 134
6.15.2 AND......................................................................................................................... 135
6.15.3 FALSE..................................................................................................................... 135
6.15.4 IF............................................................................................................................. 135
6.15.5 IFERROR................................................................................................................ 135
6.15.6 IFNA........................................................................................................................ 136
6.15.7 NOT......................................................................................................................... 136
6.15.8 OR........................................................................................................................... 136
6.15.9 TRUE....................................................................................................................... 137
6.15.10 XOR....................................................................................................................... 137
6.16 Mathematical Functions.................................................................................................. 137
6.16.1 General................................................................................................................... 137
6.16.2 ABS......................................................................................................................... 137
6.16.3 ACOS...................................................................................................................... 138
6.16.4 ACOSH.................................................................................................................... 138
6.16.5 ACOT....................................................................................................................... 138
6.16.6 ACOTH.................................................................................................................... 138
6.16.7 ASIN........................................................................................................................ 139
6.16.8 ASINH...................................................................................................................... 139
6.16.9 ATAN........................................................................................................................ 139
6.16.10 ATAN2.................................................................................................................... 140
6.16.11 ATANH................................................................................................................... 140
6.16.12 BESSELI............................................................................................................... 140
6.16.13 BESSELJ............................................................................................................... 140
6.16.14 BESSELK.............................................................................................................. 141
6.16.15 BESSELY.............................................................................................................. 141
6.16.16 COMBIN................................................................................................................ 141
6.16.17 COMBINA.............................................................................................................. 142

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 89 of 104

6.16.18 CONVERT............................................................................................................. 142
6.16.19 COS....................................................................................................................... 150
6.16.20 COSH.................................................................................................................... 150
6.16.21 COT....................................................................................................................... 151
6.16.22 COTH.................................................................................................................... 151
6.16.23 CSC....................................................................................................................... 151
6.16.24 CSCH.................................................................................................................... 152
6.16.25 DEGREES............................................................................................................. 152
6.16.26 DELTA................................................................................................................... 152
6.16.27 ERF....................................................................................................................... 152
6.16.28 ERFC..................................................................................................................... 153
6.16.29 EUROCONVERT................................................................................................... 153
6.16.30 EVEN..................................................................................................................... 154
6.16.31 EXP....................................................................................................................... 155
6.16.32 FACT..................................................................................................................... 155
6.16.33 FACTDOUBLE...................................................................................................... 155
6.16.34 GAMMA................................................................................................................. 155
6.16.35 GAMMALN............................................................................................................ 156
6.16.36 GCD...................................................................................................................... 156
6.16.37 GESTEP................................................................................................................ 156
6.16.38 LCM....................................................................................................................... 157
6.16.39 LN.......................................................................................................................... 157
6.16.40 LOG....................................................................................................................... 157
6.16.41 LOG10................................................................................................................... 157
6.16.42 MOD...................................................................................................................... 158
6.16.43 MULTINOMIAL...................................................................................................... 158
6.16.44 ODD...................................................................................................................... 158
6.16.45 PI........................................................................................................................... 158
6.16.46 POWER................................................................................................................. 159
6.16.47 PRODUCT............................................................................................................. 159
6.16.48 QUOTIENT............................................................................................................ 159
6.16.49 RADIANS.............................................................................................................. 159
6.16.50 RAND.................................................................................................................... 160
6.16.51 RANDBETWEEN.................................................................................................. 160
6.16.52 SEC....................................................................................................................... 160
6.16.53 SERIESSUM......................................................................................................... 160
6.16.54 SIGN...................................................................................................................... 161

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 90 of 104

6.16.55 SIN........................................................................................................................ 161
6.16.56 SINH...................................................................................................................... 161
6.16.57 SECH.................................................................................................................... 162
6.16.58 SQRT.................................................................................................................... 162
6.16.59 SQRTPI................................................................................................................. 162
6.16.60 SUBTOTAL............................................................................................................ 163
6.16.61 SUM...................................................................................................................... 163
6.16.62 SUMIF................................................................................................................... 164
6.16.63 SUMIFS................................................................................................................. 164
6.16.64 SUMPRODUCT..................................................................................................... 164
6.16.65 SUMSQ................................................................................................................. 165
6.16.66 SUMX2MY2........................................................................................................... 165
6.16.67 SUMX2PY2........................................................................................................... 165
6.16.68 SUMXMY2............................................................................................................. 165
6.16.69 TAN....................................................................................................................... 166
6.16.70 TANH..................................................................................................................... 166
6.17 Rounding Functions....................................................................................................... 166
6.17.1 CEILING.................................................................................................................. 166
6.17.2 INT.......................................................................................................................... 167
6.17.3 FLOOR.................................................................................................................... 167
6.17.4 MROUND................................................................................................................ 167
6.17.5 ROUND................................................................................................................... 168
6.17.6 ROUNDDOWN........................................................................................................ 168
6.17.7 ROUNDUP.............................................................................................................. 168
6.17.8 TRUNC.................................................................................................................... 169
6.18 Statistical Functions....................................................................................................... 169
6.18.1 General................................................................................................................... 169
6.18.2 AVEDEV.................................................................................................................. 169
6.18.3 AVERAGE................................................................................................................ 169
6.18.4 AVERAGEA............................................................................................................. 170
6.18.5 AVERAGEIF............................................................................................................ 170
6.18.6 AVERAGEIFS.......................................................................................................... 170
6.18.7 BETADIST............................................................................................................... 171
6.18.8 BETAINV................................................................................................................. 171
6.18.9 BINOM.DIST.RANGE.............................................................................................. 172
6.18.10 BINOMDIST.......................................................................................................... 172
6.18.11 LEGACY.CHIDIST................................................................................................. 172

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 91 of 104

6.18.12 CHISQDIST........................................................................................................... 173
6.18.13 LEGACY.CHIINV................................................................................................... 173
6.18.14 CHISQINV............................................................................................................. 174
6.18.15 LEGACY.CHITEST................................................................................................ 174
6.18.16 CONFIDENCE....................................................................................................... 175
6.18.17 CORREL............................................................................................................... 175
6.18.18 COVAR.................................................................................................................. 175
6.18.19 CRITBINOM.......................................................................................................... 176
6.18.20 DEVSQ.................................................................................................................. 176
6.18.21 EXPONDIST.......................................................................................................... 176
6.18.22 FDIST.................................................................................................................... 177
6.18.23 LEGACY.FDIST..................................................................................................... 177
6.18.24 FINV...................................................................................................................... 178
6.18.25 LEGACY.FINV....................................................................................................... 178
6.18.26 FISHER................................................................................................................. 178
6.18.27 FISHERINV........................................................................................................... 179
6.18.28 FORECAST........................................................................................................... 179
6.18.29 FREQUENCY........................................................................................................ 179
6.18.30 FTEST................................................................................................................... 180
6.18.31 GAMMADIST......................................................................................................... 180
6.18.32 GAMMAINV........................................................................................................... 180
6.18.33 GAUSS.................................................................................................................. 181
6.18.34 GEOMEAN............................................................................................................ 181
6.18.35 GROWTH.............................................................................................................. 181
6.18.36 HARMEAN............................................................................................................. 182
6.18.37 HYPGEOMDIST.................................................................................................... 182
6.18.38 INTERCEPT.......................................................................................................... 183
6.18.39 KURT..................................................................................................................... 183
6.18.40 LARGE.................................................................................................................. 184
6.18.41 LINEST.................................................................................................................. 184
6.18.42 LOGEST................................................................................................................ 186
6.18.43 LOGINV................................................................................................................. 189
6.18.44 LOGNORMDIST.................................................................................................... 189
6.18.45 MAX....................................................................................................................... 190
6.18.46 MAXA.................................................................................................................... 190
6.18.47 MEDIAN................................................................................................................ 190
6.18.48 MIN........................................................................................................................ 191

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 92 of 104

6.18.49 MINA..................................................................................................................... 191
6.18.50 MODE.................................................................................................................... 191
6.18.51 NEGBINOMDIST................................................................................................... 192
6.18.52 NORMDIST........................................................................................................... 192
6.18.53 NORMINV............................................................................................................. 193
6.18.54 LEGACY.NORMSDIST.......................................................................................... 193
6.18.55 LEGACY.NORMSINV............................................................................................ 193
6.18.56 PEARSON............................................................................................................. 194
6.18.57 PERCENTILE........................................................................................................ 194
6.18.58 PERCENTRANK................................................................................................... 195
6.18.59 PERMUT............................................................................................................... 196
6.18.60 PERMUTATIONA................................................................................................... 196
6.18.61 PHI........................................................................................................................ 196
6.18.62 POISSON.............................................................................................................. 197
6.18.63 PROB.................................................................................................................... 197
6.18.64 QUARTILE............................................................................................................ 198
6.18.65 RANK.................................................................................................................... 198
6.18.66 RSQ....................................................................................................................... 199
6.18.67 SKEW.................................................................................................................... 200
6.18.68 SKEWP................................................................................................................. 200
6.18.69 SLOPE.................................................................................................................. 200
6.18.70 SMALL................................................................................................................... 201
6.18.71 STANDARDIZE..................................................................................................... 201
6.18.72 STDEV.................................................................................................................. 201
6.18.73 STDEVA................................................................................................................ 202
6.18.74 STDEVP................................................................................................................ 202
6.18.75 STDEVPA.............................................................................................................. 203
6.18.76 STEYX................................................................................................................... 203
6.18.77 LEGACY.TDIST..................................................................................................... 204
6.18.78 TINV...................................................................................................................... 204
6.18.79 TREND.................................................................................................................. 204
6.18.80 TRIMMEAN........................................................................................................... 205
6.18.81 TTEST................................................................................................................... 206
6.18.82 VAR....................................................................................................................... 208
6.18.83 VARA..................................................................................................................... 208
6.18.84 VARP..................................................................................................................... 208
6.18.85 VARPA................................................................................................................... 209

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 93 of 104

6.18.86 WEIBULL.............................................................................................................. 209
6.18.87 ZTEST................................................................................................................... 210
6.19 Number Representation Conversion Functions..............................................................210
6.19.1 General................................................................................................................... 210
6.19.2 ARABIC.................................................................................................................... 211
6.19.3 BASE....................................................................................................................... 211
6.19.4 BIN2DEC................................................................................................................. 211
6.19.5 BIN2HEX................................................................................................................. 212
6.19.6 BIN2OCT................................................................................................................. 212
6.19.7 DEC2BIN................................................................................................................. 213
6.19.8 DEC2HEX............................................................................................................... 213
6.19.9 DEC2OCT............................................................................................................... 214
6.19.10 DECIMAL.............................................................................................................. 214
6.19.11 HEX2BIN............................................................................................................... 214
6.19.12 HEX2DEC............................................................................................................. 215
6.19.13 HEX2OCT............................................................................................................. 215
6.19.14 OCT2BIN............................................................................................................... 216
6.19.15 OCT2DEC............................................................................................................. 216
6.19.16 OCT2HEX............................................................................................................. 216
6.19.17 ROMAN................................................................................................................. 217
6.20 Text Functions................................................................................................................ 218
6.20.1 General................................................................................................................... 218
6.20.2 ASC......................................................................................................................... 218
6.20.3 CHAR...................................................................................................................... 220
6.20.4 CLEAN.................................................................................................................... 221
6.20.5 CODE...................................................................................................................... 221
6.20.6 CONCATENATE...................................................................................................... 221
6.20.7 DOLLAR.................................................................................................................. 221
6.20.8 EXACT.................................................................................................................... 222
6.20.9 FIND........................................................................................................................ 222
6.20.10 FIXED.................................................................................................................... 222
6.20.11 JIS......................................................................................................................... 222
6.20.12 LEFT..................................................................................................................... 225
6.20.13 LEN....................................................................................................................... 225
6.20.14 LOWER................................................................................................................. 225
6.20.15 MID........................................................................................................................ 226
6.20.16 PROPER............................................................................................................... 226

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 94 of 104

6.20.17 REPLACE.............................................................................................................. 226
6.20.18 REPT..................................................................................................................... 227
6.20.19 RIGHT................................................................................................................... 227
6.20.20 SEARCH............................................................................................................... 227
6.20.21 SUBSTITUTE........................................................................................................ 228
6.20.22 T............................................................................................................................ 228
6.20.23 TEXT..................................................................................................................... 228
6.20.24 TRIM...................................................................................................................... 228
6.20.25 UNICHAR.............................................................................................................. 229
6.20.26 UNICODE.............................................................................................................. 229
6.20.27 UPPER.................................................................................................................. 229
7 Other Capabilities.................................................................................................................... 231
7.1 General............................................................................................................................. 231
7.2 Inline constant arrays....................................................................................................... 231
7.3 Inline non-constant arrays................................................................................................ 231
7.4 Year 1583......................................................................................................................... 231
8 Non-portable Features............................................................................................................. 232
8.1 General............................................................................................................................. 232
8.2 Distinct Logical................................................................................................................. 232

Table of Contents Part 3
1 Introduction.................................................................................................................................. 7
1.1 Introduction........................................................................................................................... 7
1.2 Terminology.......................................................................................................................... 7
1.3 Normative References.......................................................................................................... 7
1.4 Non Normative References.................................................................................................. 8
1.5 Namespaces......................................................................................................................... 82 Packages, Package Consumers and Package Producers.........................................................10
2.1 Introduction......................................................................................................................... 10
2.2 Packages............................................................................................................................ 10
2.2.1 OpenDocument Package............................................................................................ 10
2.2.2 OpenDocument Extended Package.............................................................................11
2.3 Producers........................................................................................................................... 11
2.3.1 OpenDocument Package Producer.............................................................................112.3.2 OpenDocument Package Extended Producer.............................................................11
2.4 OpenDocument Package Consumer..................................................................................11

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 95 of 104

3 Packages................................................................................................................................... 12
3.1 General............................................................................................................................... 12
3.2 Manifest.............................................................................................................................. 12
3.3 MIME Media Type............................................................................................................... 12
3.4 Encryption........................................................................................................................... 13
3.4.1 General....................................................................................................................... 13
3.4.2 Encryption Process..................................................................................................... 13
3.5 Digital Signatures............................................................................................................... 14
3.6 Metadata............................................................................................................................. 14
3.7 Usage of IRIs Within Packages.......................................................................................... 14
3.8 Preview Image.................................................................................................................... 16
4 Manifest File.............................................................................................................................. 17
4.1 Introduction......................................................................................................................... 17
4.2 <manifest:manifest>........................................................................................................... 17
4.3 <manifest:file-entry>........................................................................................................... 17
4.4 <manifest:encryption-data>................................................................................................ 17
4.5 <manifest:algorithm>.......................................................................................................... 18
4.6 <manifest:start-key-generation>......................................................................................... 18
4.7 <manifest:key-derivation>.................................................................................................. 18
4.8 Manifest Attributes.............................................................................................................. 19
4.8.1 manifest:algorithm-name............................................................................................. 19
4.8.2 manifest:checksum...................................................................................................... 19
4.8.3 manifest:checksum-type.............................................................................................. 19
4.8.4 manifest:full-path......................................................................................................... 20
4.8.5 manifest:initialisation-vector........................................................................................ 20
4.8.6 manifest:start-key-generation-name............................................................................21
4.8.7 manifest:key-size......................................................................................................... 21
4.8.8 manifest:iteration-count............................................................................................... 22
4.8.9 manifest:key-derivation-name.....................................................................................224.8.10 manifest:media-type.................................................................................................. 22
4.8.11 manifest:preferred-view-mode...................................................................................23
4.8.12 manifest:salt.............................................................................................................. 23
4.8.13 manifest:size............................................................................................................. 23
4.8.14 manifest:version........................................................................................................ 24
5 Digital Signatures File................................................................................................................ 25
5.1 Introduction......................................................................................................................... 25
5.2 <dsig:document-signatures>.............................................................................................. 25

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 96 of 104

5.3 <ds:Signature>................................................................................................................... 25
5.4 Digital Signatures Attributes............................................................................................... 27
5.4.1 dsig:version................................................................................................................. 27
6 Metadata Manifest Files............................................................................................................. 28
6.1 General............................................................................................................................... 28
6.2 pkg:Document..................................................................................................................... 28
6.3 pkg:File............................................................................................................................... 28
6.4 pkg:MetadataFile................................................................................................................ 28
6.5 pkg:Element........................................................................................................................ 28
6.6 pkg:hasPart........................................................................................................................ 28
6.7 pkg:mimeType.................................................................................................................... 29
7 Datatypes................................................................................................................................... 30
7.1 Introduction......................................................................................................................... 30
7.2 W3C Schema Datatypes.................................................................................................... 30
7.3 Other Datatypes................................................................................................................. 30
7.3.1 namespacedToken...................................................................................................... 30
Appendix A. Schemas................................................................................................................... 31
A.1. OpenDocument Manifest Schema......................................................................................... 31
A.2. OpenDocument Digital Signature Schema............................................................................31
Appendix B. OpenDocument Metadata Manifest Ontology...........................................................32
Appendix C. Zip File Structure (Non normative)...........................................................................33
Appendix D. Changes From “Open Document Format for Office Applications (OpenDocument)
v1.1” (Non Normative)................................................................................................................... 34

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 97 of 104

1 Introduction
1.1 ScopeThis standard specifies the characteristics of an XML-based application-independent andplatform-independent digital document file format, as well as the characteristics of software
applications which read, write and process such documents. This standard is applicable todocument authoring, editing, viewing, exchange and archiving, including text documents,
spreadsheets, presentation graphics, drawings, charts and similar documents commonly used bypersonal productivity software applications.
This standard has three parts.
Part 1 defines an XML schema for office documents. Office documents includes text documents,
spreadsheets, charts and graphical documents like drawings or presentations, but is not
restricted to these kinds of documents.
Part 2 defines a formula language for OpenDocument documents.
Part 3 defines the package format for OpenDocument documents.
This standard, for illustrative purposes, describes functionality using terminology common indesktop computing environments that contain a display terminal, keyboard and mouse, attached
to a computer hosting an operating system with a graphical user interface which includes userinterface controls such as input controls, command buttons, selection boxes, etc.
However, this standard is not limited to such environments. The standard also supports the useof alternative computing environments, other form factors, non-GUI consumers and producers,
and the use of assistive technologies, using analogous user interface operations.

1.2 Terminology
All text is normative unless otherwise labeled.
Within the normative text of this specification, the terms "shall", "shall not", "should", "shouldnot", "may" and “need not” are to be interpreted as described in Annex H of [ISO/IEC Directives].
implementation-defined behavior: behavior that depends on the implementation and that each
implementation shall document.
implementation-dependent behavior: behavior that depends on the implementation. The
implementation is not required to document which behavior occurs.
Note:: Usually, the range of possible behaviors is delineated by the Standard.
undefined behavior: behavior for which the Standard imposes no requirements. Undefined
behavior may also be expected when the standard omits the description of any explicit definitionof behavior.

1.3 Normative References

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 98 of 104

[ISO/IEC Directives] ISO/IEC Directives, Part 2 (Fifth Edition) Rules for the structure anddrafting of International Standards, International Organization for Standardization andInternational Electrotechnical Commission, 2004.
The individual parts of the OpenDocument specification each defines its own set of normativereferences.

1.4 Non Normative References[ODF11]OASIS Standard, Open Document Format for Office Applications(OpenDocument) v1.1, February 2007, http://docs.oasisopen.org/office/v1.1/OS/OpenDocument-v1.1.pdf.
The individual parts of the OpenDocument specification each contains further non normativereferences.

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 99 of 104

2 Conformance
The OpenDocument specification defines conformance for documents, consumers, producers,
packages, package consumer, package producers, formula expressions and formula evaluators,
with multiple conformance classes.
(C1) A conforming OpenDocument Document shall meet the requirements defined in part 1
section 2.2.1 and chapters 3 to 20 for OpenDocument documents..
(C2) A conforming OpenDocument extended Document shall meet the requirements defined inpart 1 section 2.2.2 and chapters 3 to 20 for OpenDocument extended documents.
(C3) A conforming OpenDocument Text Document shall meet the requirements defined in part 1
section 2.2.3 and chapters 3 to 20 for OpenDocument Text documents.
(C4) A conforming OpenDocument Spreadsheet Document shall meet the requirements definedin part 1 section 2.2.4 and chapters 3 to 20 for OpenDocument Spreadsheet documents.
(C5) A conforming OpenDocument Drawing Document shall meet the requirements defined inpart 1 section 2.2.5 and chapters 3 to 20 for OpenDocument Drawing documents.
(C6) A conforming OpenDocument Presentation Document shall meet the requirements definedin part 1 section 2.2.6 and chapters 3 to 20 for OpenDocument Presentation documents.
(C7) A conforming OpenDocument Chart Document shall meet the requirements defined in part1 section 2.2.7 and chapters 3 to 20 for OpenDocument Chart documents.
(C8) A conforming OpenDocument Image Document shall meet the requirements defined in part1 section 2.2.8 and chapters 3 to 20 for OpenDocument Image documents.
(C9) A conforming OpenDocument Formula Document shall meet the requirements defined inpart 1 section 2.2.9 and chapters 3 to 20 for OpenDocument Formula documents.
(C10) A conforming OpenDocument Database Front End Document shall meet the requirements
defined in part 1 section 2.2.10 and chapters 3 to 20 for OpenDocument Database Front End
documents.
(C11) A Conforming OpenDocument Producer shall meet the requirements defined in part 1
section 2.3.1 and chapters 3 to 20 for OpenDocument producers.
(C12) A Conforming OpenDocument Extended Producer shall meet the requirements defined inpart 1 section 2.3.2 and chapters 3 to 20 for OpenDocument extended producers.
(C13) A Conforming OpenDocument Consumer shall meet the requirements defined in part 1
section 2.4 and chapters 3 to 20 for OpenDocument consumers.
(C14) A conforming OpenDocument Formula Expression shall meet the requirements defined inpart 2 section 2.2 and chapters 3 to 8 for OpenDocument formula expressions.
(C15) A Conforming OpenDocument Formula Evaluator shall meet the requirements defined inpart 2 section 2.3.1 and chapters 3 to 8 for OpenDocument formula evaluators.
(C16) A Conforming OpenDocument Formula Small Group Evaluator shall meet therequirements defined in part 2 section 2.3.2 and chapters 3 to 8 for OpenDocument formula
small group evaluators.

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 100 of 104

(C17) A Conforming OpenDocument Formula Medium Group Evaluator shall meet therequirements defined in part 2 section 2.3.3 and chapters 3 to 8 for OpenDocument formulamedium group evaluators.
(C18) A Conforming OpenDocument Formula Large Group Evaluator shall meet therequirements defined in part 2 section 2.3.4 and chapters 3 to 8 for OpenDocument formula large
group evaluators.
(C19) A conforming OpenDocument Package shall meet the requirements defined in part 3
section 2.2.1 and chapters 3 to 7 for OpenDocument packages.
(C20) A conforming OpenDocument Extended Package shall meet the requirements defined inpart 3 section 2.2.2 and chapters 3 to 7 for OpenDocument extended packages.
(C21) A Conforming OpenDocument Package Producer shall meet the requirements defined inpart 3 section 2.3.1 and chapters 3 to 7 for OpenDocument package producers.
(C22) A Conforming OpenDocument Package Extended Producer shall meet the requirements
defined in part 3 section 2.3.2 and chapters 3 to 7 for OpenDocument package extended
producers.
(C23) A Conforming OpenDocument Package Consumer shall meet the requirements defined inpart 3 section 2.4 and chapters 3 to 7 for OpenDocument package consumers.

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 101 of 104

Appendix A. Changes From Previous
Specification Versions (Non Normative)
A.1. Changes from “Open Document Format for Office
Applications (OpenDocument) v1.1”
The OpenDocument specification has been divided into three parts and has been restructured. A
more detailed list of changes is included in parts 1 and 3. Part 2 contains content that is new in
OpenDocument v1.2.

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 102 of 104

Appendix B. Acknowledgments (Non Normative)
The following individuals have participated in the creation of this specification and are gratefully
acknowledged:
Participants:
Chieko Asakawa, IBM
Waldo Bastian, Intel Corporation
Thorsten Behrens, Novell
Nathaniel Borenstein, IBM
Michael Brauer, Oracle Corporation
Pete Brunet, IBM
Manuel Cano
Suresh Chande, Nokia Corporation
Robin Cover, OASISPierre Ducroquet
Jerome Dumonteil, Ars Aperta
Patrick Durusau
Cherie Ekholm, Microsoft Corporation
Ezer Farhi
David Faure
Jean Gouarne, Ars Aperta
Andreas J. Guelzow
Bettina Haberer, Sun Microsystems
Dennis E. Hamilton
Bart Hanssens, Fedict
Donald Harbison, IBM
Mingfei Jia, IBM
Bob JolliffePeter Junge
Kazmer Koleszar, MultiRacio Ltd.
Peter Korn, Oracle Corporation
Jirka Kosek
Robin LaFontaine
Marcus Lange, Sun Microsystems
David LeBlanc, Microsoft
Fong Lin, Novell
Jun Ma, Beijing Redflag Chinese 2000 Software Co., Ltd.
Yue Ma, IBM
John Madden, Duke University
Doug Mahugh, Microsoft Corporation
Ben Martin, KDE e.V.
James Mason, ISO/IEC JTC1/SC34
Tristan Mitchell
Duane Nickull, Adobe Systems
Michael PacielloGanesh Paramasivam, KDE e.V.
Eric Patterson, Microsoft Corporation
David Pawson
Steven Pemberton, Stichting Centrum voor Wiskunde & Informatica
Stephen Peront, Microsoft Corporation
Asokan Ramanathan, IBM
Eike Rathke, Oracle Corporation

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 103 of 104

Florian Reuter, Novell
Janina Sajka
Svante Schubert, Oracle Corporation
Charles Schulz, Ars Aperta
Richard Schwerdtfeger, IBM
Douglas Schepers
Wei Guo Shi, IBM
Michael Stahl, Oracle Corporation
Yan Shi, Beijing Sursen International Information Technology Co., Ltd.
Jomar Silva, OpenDocument Format AllianceFrank Stecher, Sun Microsystems
Hironobu Takagi, IBM
Malte Timmermann, Oracle Corporation
John Tolbert, The Boeing Company
Elias Torres, IBM
Warren Turkal, Google Inc.
Jos van den Oever, KDE e.V.
Alex Wang, Beijing Sursen International Information Technology Co., Ltd.
Robert Weir, IBM
Oliver-Rainer Wittmann, Oracle Corporation
David A. Wheeler
Cheng XiuZhi, Beijing Redflag Chinese 2000 Software Co., Ltd.
Panrong Yin, IBM
Kohei Yoshida, Novell
Helen Yue, IBM
Jin YouBing, Beijing Redflag Chinese 2000 Software Co., Ltd.
Thorsten Zachmann, Nokia Corporation
Thomas Zander, Nokia Corporation
Pine Zhang, UOML Alliance

OpenDocument-v1.2-csd06
Copyright © OASIS® 2010. All Rights Reserved.

Standards Track Work Product2 December 2010
Page 104 of 104