OASIS Open Document Format for Office Applications (OpenDocument) Version 1.2

This specification consists of this document as well as the following documents, schemas and ontologies:

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#

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 is suitable for office documents, including text documents, spreadsheets, charts and graphical documents like drawings or presentations, but is not restricted to these kinds of documents.

This document was last revised or approved by the OASIS Open Document Format for Office Applications (OpenDocument) TC on the above date. The level of approval is also listed above. Check the "Latest version" location noted above for possible later revisions of this document.

Technical Committee members should send comments on this specification to the Technical Committee’s email list. Others should send comments to the Technical Committee by using the “Send A Comment” button on the Technical Committee’s web page at http://www.oasis-open.org/committees/office/.

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 to the Intellectual Property Rights section of the Technical Committee web page (http://www.oasis-open.org/committees/office/ipr.php).

When referencing this specification the following citation format should be used:

All capitalized terms in the following text have the meanings assigned to them in the OASIS Intellectual 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 the above 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 to translate 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 OASIS DISCLAIMS 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 FITNESS FOR A PARTICULAR PURPOSE.

OASIS requests that any OASIS Party or any other party that believes it has patent claims that would 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 to grant 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 of ownership of any patent claims that would necessarily be infringed by implementations of this specification by a patent holder that is not willing to provide a license to such patent claims in a manner consistent with the IPR Mode of the OASIS Technical Committee that produced this specification. OASIS may include such claims on its website, but disclaims any obligation to do so.

OASIS takes no position regarding the validity or scope of any intellectual property or other rights that might be claimed to pertain to the implementation or use of the technology described in 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 of claims of rights made available for publication and any assurances of licenses to be made available, or the result of an attempt made to obtain a general license or permission for the use of 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 no representation that any information or list of intellectual property rights will at any time be complete, 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 the organization and its official outputs. OASIS welcomes reference to, and implementation and use of, specifications, while reserving the right to enforce its marks against misleading uses. Please see http://www.oasis-open.org/who/trademark.php for above guidance.

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 88

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 89

2.3.1 OpenDocument Producer 89

2.3.2 OpenDocument Extended Producer 89

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

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

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

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

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 139

7.4.1 General 139

7.4.2 <text:variable-decls> 140

7.4.3 <text:variable-decl> 140

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> 142

7.4.11 <text:sequence-decls> 143

7.4.12 <text:sequence-decl> 143

7.4.13 <text:sequence> 143

7.4.14 <text:expression> 144

7.4.15 <text:text-input> 144

7.5 Metadata Fields 144

7.5.1 General 144

7.5.2 <text:initial-creator> 144

7.5.3 <text:creation-date> 145

7.5.4 <text:creation-time> 145

7.5.5 <text:description> 145

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> 146

7.5.10 <text:title> 147

7.5.11 <text:subject> 147

7.5.12 <text:keywords> 147

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> 148

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> 149

7.5.18.4 <text:word-count> 150

7.5.18.5 <text:character-count> 150

7.5.18.6 <text:table-count> 150

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 152

7.6.1 General 152

7.6.2 <form:connection-resource> 153

7.6.3 <text:database-display> 153

7.6.4 <text:database-next> 153

7.6.5 <text:database-row-select> 154

7.6.6 <text:database-row-number> 154

7.6.7 <text:database-name> 154

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

7.7.1.3 <text:page-variable-get> 155

7.7.2 <text:placeholder> 155

7.7.3 <text:conditional-text> 156

7.7.4 <text:hidden-text> 156

7.7.5 <text:reference-ref> 156

7.7.6 <text:bookmark-ref> 157

7.7.7 <text:note-ref> 157

7.7.8 <text:sequence-ref> 157

7.7.9 <text:script> 158

7.7.10 <text:execute-macro> 158

7.7.11 <text:hidden-paragraph> 158

7.7.12 <text:dde-connection> 159

7.7.13 <text:measure> 159

7.7.14 <text:table-formula> (deprecated) 159

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> 163

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

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> 171

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> 174

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

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> 187

9.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

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> 197

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> 198

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> 203

9.9.15 <table:target-range-address> 203

9.9.16 <table:change-track-table-cell> 204

9.9.17 <table:cell-content-change> 204

9.9.18 <table:cell-address> 204

9.9.19 <table:previous> 204

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

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> 210

10.3.8 <draw:circle> 211

10.3.9 <draw:ellipse> 211

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> 216

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 219

10.4.6.1 General 219

10.4.6.2 <draw:object> 220

10.4.6.3 <draw:object-ole> 220

10.4.7 <draw:applet> 220

10.4.8 <draw:plugin> 221

10.4.9 <draw:param> 221

10.4.10 <draw:floating-frame> 221

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

10.4.12 <draw:a> 222

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 224

10.5.1 General 224

10.5.2 <dr3d:scene> 225

10.5.3 <dr3d:light> 225

10.5.4 <dr3d:cube> 225

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 228

10.8.1 <presentation:animations> 228

10.8.2 <presentation:sound> 229

10.8.3 <presentation:show-shape> 229

10.8.4 <presentation:show-text> 229

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> 230

10.8.9 <presentation:animation-group> 231

10.9 SMIL Presentation Animations 231

10.9.1 General 231

10.9.2 <presentation:event-listener> 231

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

10.9.3.5 <presentation:date-time> 233

10.9.3.6 <presentation:date-time-decl> 233

10.9.3.7 <presentation:settings> 233

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

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> 248

12.26 <db:queries> 249

12.27 <db:query-collection> 249

12.28 <db:query> 249

12.29 <db:order-statement> 249

12.30 <db:filter-statement> 250

12.31 <db:update-table> 250

12.32 <db:table-representations> 250

12.33 <db:table-representation> 250

12.34 <db:columns> 251

12.35 <db:column> 251

12.36 <db:schema-definition> 251

12.37 <db:table-definitions> 251

12.38 <db:table-definition> 252

12.39 <db:column-definitions> 252

12.40 <db:column-definition> 252

12.41 <db:keys> 252

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> 253

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> 258

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

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

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> 286

16.19.8 <table:odd-rows> 287

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 289

16.27.1 General 289

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> 290

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> 292

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> 293

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> 294

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> 295

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> 296

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> 299

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> 301

16.34 <text:outline-style> 302

16.35 <text:outline-level-style> 302

16.36 Table Styles 302

16.36.1 Table Styles 302

16.36.2 Table Column Styles 302

16.36.3 Table Row Styles 302

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 303

16.40.1 <draw:gradient> 303

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> 305

16.40.8 <draw:marker> 306

16.40.9 <draw:stroke-dash> 306

16.41 <style:presentation-page-layout> 307

16.42 <presentation:placeholder> 307

16.43 Chart Styles 307

17 Formatting Elements 308

17.1 General 308

17.2 <style:page-layout-properties> 308

17.3 <style:background-image> 308

17.4 <style:footnote-sep> 309

17.5 <style:header-footer-properties> 309

17.6 <style:paragraph-properties> 310

17.7 <style:tab-stops> 310

17.8 <style:tab-stop> 310

17.9 <style:drop-cap> 311

17.10 <style:ruby-properties> 311

17.11 <style:section-properties> 311

17.12 <style:columns> 311

17.13 <style:column> 312

17.14 <style:column-sep> 312

17.15 <style:table-properties> 312

17.16 <style:table-column-properties> 313

17.17 <style:table-row-properties> 313

17.18 <style:table-cell-properties> 313

17.19 <style:list-level-properties> 314

17.20 <style:list-level-label-alignment> 314

17.21 <style:graphic-properties> 314

17.22 <style:chart-properties> 316

17.23 <chart:symbol-image> 317

17.24 <chart:label-separator> 317

17.25 <style:drawing-page-properties> 317

18 Datatypes 319

18.1 Introduction 319

18.2 W3C Schema Datatypes 319

18.3 Other Datatypes 320

18.3.1 angle 320

18.3.2 anyIRI 320

18.3.3 boolean 320

18.3.4 cellAddress 320

18.3.5 cellRangeAddress 320

18.3.6 cellRangeAddressList 320

18.3.7 character 320

18.3.8 clipShape 320

18.3.9 color 320

18.3.10 coordinate 321

18.3.11 countryCode 321

18.3.12 CURIE 321

18.3.13 CURIEs 321

18.3.14 dateOrDateTime 321

18.3.15 distance 321

18.3.16 language 321

18.3.17 languageCode 321

18.3.18 length 321

18.3.19 namespacedToken 322

18.3.20 nonNegativeLength 322

18.3.21 nonNegativePixelLength 322

18.3.26 positiveLength 322

18.3.27 relativeLength 322

18.3.28 safeCURIE 322

18.3.29 scriptCode 322

18.3.30 signedZeroToHundredPercent 323

18.3.31 styleName 323

18.3.32 styleNameRef 323

18.3.33 styleNameRefs 323

18.3.34 targetFrameName 323

18.3.35 textEncoding 323

18.3.36 timeOrDateTime 323

18.3.37 URIorSafeCURIE 323

18.3.38 valueType 323

18.3.39 variableName 323

18.3.40 vector3D 323

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 329

19.15.1 <chart:chart>, <chart:series> 329

19.15.2 <chart:grid> 336

19.16 chart:column-mapping (deprecated) 336

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 338

19.23 chart:legend-position 339

19.24 chart:name 339

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 340

19.29 config:name 341

19.30 config:type 341

19.31 db:additional-column-statement 341

19.32 db:append-table-alias-name 342

19.33 db:apply-command 342

19.34 db:as-template 342

19.35 db:base-dn 342

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 343

19.40 db:data-source-setting-name 344

19.41 db:data-source-setting-type 344

19.42 db:data-type 344

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 345

19.48 db:description 346

19.49 db:enable-sql92-check 346

19.50 db:encoding 346

19.51 db:escape-processing 346

19.52 db:extension 347

19.53 db:field 347

19.54 db:hostname 347

19.55 db:ignore-driver-privileges 347

19.56 db:is-ascending 348

19.57 db:is-autoincrement 348

19.58 db:is-clustered 348

19.59 db:is-empty-allowed 348

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 349

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 350

19.68 db:max-row-count 351

19.69 db:media-type 351

19.70 db:name 351

19.70.1 General 351

19.70.2 <db:column> 351

19.70.3 <db:column-definition> 351

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> 352

19.70.10 <db:query> 352

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 353

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 354

19.77 db:schema-name 354

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> 355

19.80.3 <db:query> 355

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 356

19.85.3 <db:server-database> 357

19.85.4 <db:table-definition> 357

19.86 db:type-name 358

19.87 db:update-rule 358

19.88 db:use-catalog 358

19.89 db:use-system-user 359

19.90 db:user-name 359

19.91 db:visible 359

19.92 dr3d:ambient-color 359

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 360

19.98 dr3d:focal-length 360

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 361

19.101 dr3d:min-edge 362

19.102 dr3d:projection 362

19.103 dr3d:shade-mode 362

19.104 dr3d:shadow-slant 362

19.105 dr3d:size 363

19.106 dr3d:specular 363

19.107 dr3d:transform 363

19.108 dr3d:vpn 363

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 365

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

19.120 draw:class-names 366

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 367

19.124 draw:concentric-gradient-fill-allowed 368

19.125 draw:control 368

19.126 draw:copy-of 368

19.127 draw:corner-radius 368

19.128 draw:corners 369

19.129 draw:cx 369

19.130 draw:cy 369

19.131 draw:data 369

19.132 draw:display 369

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> 370

19.133.5 <draw:marker> 370

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 371

19.134.1 General 371

19.134.2 <draw:hatch> 371

19.134.3 <draw:stroke-dash> 372

19.135 draw:dots1 372

19.136 draw:dots1-length 372

19.137 draw:dots2 372

19.138 draw:dots2-length 372

19.139 draw:end 373

19.140 draw:end-angle 373

19.141 draw:end-color 373

19.142 draw:end-glue-point 373

19.143 draw:end-intensity 373

19.144 draw:end-shape 374

19.145 draw:enhanced-path 374

19.146 draw:engine 376

19.147 draw:escape-direction 376

19.148 draw:extrusion 377

19.149 draw:extrusion-allowed 377

19.150 draw:extrusion-brightness 377

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 378

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 379

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 381

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 382

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 385

19.175 draw:glue-points 386

19.176 draw:handle-mirror-horizontal 386

19.177 draw:handle-mirror-vertical 387

19.178 draw:handle-polar 387

19.179 draw:handle-position 387

19.180 draw:handle-radius-range-maximum 389

19.181 draw:handle-radius-range-minimum 389

19.182 draw:handle-range-x-maximum 389

19.183 draw:handle-range-x-minimum 389

19.184 draw:handle-range-y-maximum 389

19.185 draw:handle-range-y-minimum 390

19.186 draw:handle-switched 390

19.187 draw:id 390

19.187.1 General 390

19.187.2 <draw:glue-point> 390

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 391

19.189 draw:layer 392

19.190 draw:line-skew 392

19.191 draw:mime-type 392

19.192 draw:mirror-horizontal 392

19.193 draw:mirror-vertical 393

19.194 draw:master-page-name 393

19.195 draw:may-script 393

19.196 draw:modifiers 393

19.197 draw:name 394

19.197.1 General 394

19.197.2 <draw:caption> 394

19.197.3 <draw:circle> 394

19.197.4 <draw:connector> 394

19.197.5 <draw:control> 394

19.197.6 <draw:custom-shape> 395

19.197.7 <draw:ellipse> 395

19.197.8 <draw:equation> 395

19.197.9 <draw:fill-image> 395

19.197.10 <draw:frame> 395

19.197.11 <draw:g> 395

19.197.12 <draw:gradient> 396

19.197.13 <draw:hatch> 396

19.197.14 <draw:layer> 396

19.197.15 <draw:line> 396

19.197.16 <draw:marker> 396

19.197.17 <draw:measure> 396

19.197.18 <draw:opacity> 397

19.197.19 <draw:page> 397

19.197.20 <draw:page-thumbnail> 397

19.197.21 <draw:param> 397

19.197.22 <draw:path> 397

19.197.23 <draw:polygon> 397

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> 398

19.197.28 <office:annotation> (deprecated) 398

19.197.29 <svg:linearGradient> 398

19.197.30 <svg:radialGradient> 399

19.198 draw:nav-order 399

19.199 draw:nohref 399

19.200 draw:notify-on-update-of-ranges 399

19.201 draw:object 400

19.202 draw:opacity 400

19.203 draw:page-number 400

19.204 draw:path-stretchpoint-x 400

19.205 draw:path-stretchpoint-y 401

19.206 draw:points 401

19.207 draw:protected 401

19.208 draw:recreate-on-edit 402

19.209 draw:rotation 402

19.210 draw:shape-id 402

19.211 draw:sharpness 402

19.212 draw:start 403

19.213 draw:start-angle 403

19.214 draw:start-color 403

19.215 draw:start-glue-point 403

19.216 draw:start-intensity 403

19.217 draw:start-shape 404

19.218 draw:style 404

19.218.1 General 404

19.218.2 <draw:gradient> 404

19.218.3 <draw:hatch> 405

19.218.4 <draw:opacity> 405

19.218.5 <draw:stroke-dash> 405

19.219 draw:style-name 406

19.219.1 General 406

19.219.2 <dr3d:cube> 406

19.219.3 <dr3d:extrude> 406

19.219.4 <dr3d:rotate> 406

19.219.5 <dr3d:scene> 406

19.219.6 <dr3d:sphere> 406

19.219.7 <draw:caption> 407

19.219.8 <draw:circle> 407

19.219.9 <draw:connector> 407

19.219.10 <draw:control> 407

19.219.11 <draw:custom-shape> 407

19.219.12 <draw:ellipse> 407

19.219.13 <draw:frame> 408

19.219.14 <draw:g> 408

19.219.15 <draw:line> 408

19.219.16 <draw:measure> 408

19.219.17 <draw:page> 408

19.219.18 <draw:page-thumbnail> 409

19.219.19 <draw:path> 409

19.219.20 <draw:polygon> 409

19.219.21 <draw:polyline> 409

19.219.22 <draw:rect> 409

19.219.23 <draw:regular-polygon> 409

19.219.24 <office:annotation> 410

19.219.25 <presentation:notes> 410

19.219.26 <style:handout-master> 410

19.219.27 <style:master-page> 410

19.220 draw:text-areas 410

19.221 draw:text-path 411

19.222 draw:text-path-allowed 412

19.223 draw:text-path-mode 412

19.224 draw:text-path-same-letter-heights 412

19.225 draw:text-path-scale 413

19.226 draw:text-rotate-angle 413

19.227 draw:text-style-name 413

19.228 draw:transform 413

19.229 draw:type 414

19.229.1 General 414

19.229.2 <draw:connector> 414

19.229.3 <draw:enhanced-geometry> 415

19.230 draw:value 415

19.231 draw:z-index 415

19.232 fo:column-count 415

19.233 fo:column-gap 416

19.234 fo:country 416

19.234.1 <text:alphabetical-index-source> 416

19.234.2 <text:bibliography-configuration> 416

19.235 fo:end-indent 416

19.236 fo:language 417

19.236.1 General 417

19.236.2 <text:alphabetical-index-source> 417

19.236.3 <text:bibliography-configuration> 417

19.237 fo:margin-left 417

19.238 fo:max-height 417

19.239 fo:max-width 418

19.240 fo:min-height 418

19.241 fo:min-width 418

19.242 fo:script 419

19.242.1 General 419

19.242.2 <text:alphabetical-index-source> 419

19.242.3 <text:bibliography-configuration> 419

19.243 fo:space-after 419

19.244 fo:space-before 420

19.245 fo:start-indent 420

19.246 fo:text-indent 420

19.247 form:allow-deletes 420

19.248 form:allow-inserts 421

19.249 form:allow-updates 421

19.250 form:apply-design-mode 421

19.251 form:apply-filter 421

19.252 form:auto-complete 422

19.253 form:automatic-focus 422

19.254 form:bound-column 422

19.255 form:button-type 423

19.256 form:command 423

19.257 form:command-type 423

19.258 form:control-implementation 424

19.259 form:convert-empty-to-null 424

19.260 form:current-selected 424

19.261 form:current-state 425

19.262 form:current-value 425

19.263 form:data-field 425

19.264 form:datasource 426

19.265 form:default-button 426

19.266 form:delay-for-repeat 427

19.267 form:detail-fields 427

19.268 form:disabled 427

19.269 form:dropdown 427

19.270 form:echo-char 428

19.271 form:enctype 428

19.272 form:escape-processing 428

19.273 form:filter 429

19.274 form:focus-on-click 429

19.275 form:for 429

19.276 form:id (deprecated) 429

19.277 form:ignore-result 430

19.278 form:image-align 430

19.279 form:image-data 430

19.280 form:image-position 431

19.281 form:is-tristate 431

19.282 form:label 431

19.283 form:linked-cell 432

19.284 form:list-linkage-type 432

19.285 form:list-source 432

19.286 form:list-source-type 433

19.287 form:master-fields 434

19.288 form:max-length 434

19.289 form:max-value 434

19.289.1 General 434

19.289.2 <form:date> 434

19.289.3 <form:formatted-text> 435

19.289.4 <form:number> and <form:value-range> 435

19.289.5 <form:time> 435

19.290 form:min-value 435

19.290.1 General 435

19.290.2 <form:date> 435

19.290.3 <form:formatted-text> 435

19.290.4 <form:number> and <form:value-range> 435

19.290.5 <form:time> 436

19.291 form:method 436

19.292 form:multi-line 436

19.293 form:multiple 436

19.294 form:name 437

19.295 form:navigation-mode 437

19.296 form:order 437

19.297 form:orientation 438

19.298 form:page-step-size 438

19.299 form:printable 438

19.300 form:property-name 438

19.301 form:readonly 439

19.302 form:repeat 439

19.303 form:selected 439

19.304 form:size 440

19.305 form:source-cell-range 440

19.306 form:spin-button 440

19.307 form:state 440

19.308 form:step-size 441

19.309 form:tab-cycle 441

19.310 form:tab-index 441

19.311 form:tab-stop 442

19.312 form:text-style-name 442

19.313 form:title 443

19.314 form:toggle 443

19.315 form:validation 443

19.316 form:value 444

19.316.1 General 444

19.316.2 <form:button> 444

19.316.3 <form:date> 444

19.316.4 <form:number> and <form:value-range> 444

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> 444

19.316.6 <form:time> 444

19.317 form:visual-effect 445

19.318 form:xforms-list-source 445

19.319 form:xforms-submission 445

19.320 grddl:transformation 445

19.321 meta:cell-count 446

19.322 meta:character-count 446

19.323 meta:date 446

19.324 meta:delay 446

19.325 meta:draw-count 446

19.326 meta:frame-count 447

19.327 meta:image-count 447

19.328 meta:name 447

19.329 meta:non-whitespace-character-count 447

19.330 meta:object-count 447

19.331 meta:ole-object-count 448

19.332 meta:page-count 448

19.333 meta:paragraph-count 448

19.334 meta:row-count 448

19.335 meta:sentence-count 448

19.336 meta:syllable-count 449

19.337 meta:table-count 449

19.338 meta:value-type 449

19.339 meta:word-count 449

19.340 number:automatic-order 450

19.341 number:calendar 450

19.342 number:country 451

19.343 number:decimal-places 451

19.343.1 General 451

19.343.2 <number:number> 451

19.343.3 <number:seconds> 451

19.343.4 <number:scientific-number> 451

19.344 number:decimal-replacement 452

19.345 number:denominator-value 452

19.346 number:display-factor 452

19.347 number:format-source 452

19.348 number:grouping 453

19.349 number:language 453

19.350 number:min-denominator-digits 453

19.351 number:min-exponent-digits 454

19.352 number:min-integer-digits 454

19.353 number:min-numerator-digits 454

19.354 number:position 454

19.355 number:possessive-form 455

19.356 number:rfc-language-tag 455

19.357 number:script 455

19.358 number:style 456

19.358.1 General 456

19.358.2 <number:day> 456

19.358.3 <number:day-of-week> 456

19.358.4 <number:era> 456

19.358.5 <number:hours> 456

19.358.6 <number:minutes> 457

19.358.7 <number:month> 457

19.358.8 <number:quarter> 457

19.358.9 <number:seconds> 457

19.358.10 <number:year> 458

19.359 number:textual 458

19.360 number:title 458

19.361 number:transliteration-country 458

19.362 number:transliteration-format 459

19.363 number:transliteration-language 459

19.364 number:transliteration-style 459

19.365 number:truncate-on-overflow 460

19.366 office:automatic-update 460

19.367 office:boolean-value 460

19.368 office:conversion-mode 461

19.369 office:currency 461

19.370 office:date-value 462

19.371 office:dde-application 462

19.372 office:dde-item 462

19.373 office:dde-topic 462

19.374 office:display 462

19.375 office:mimetype 463

19.376 office:name 463

19.376.1 General 463

19.376.2 <draw:a> 463

19.376.3 <draw:area-circle> 463

19.376.4 <draw:area-rectangle> 463

19.376.5 <draw:area-polygon> 464

19.376.6 <office:annotation> 464

19.376.7 <office:annotation-end> 464

19.376.8 <office:dde-source> 464

19.376.9 <text:a> 464

19.376.10 <text:dde-connection-decl> 465

19.377 office:process-content (deprecated) 465

19.378 office:server-map 465

19.379 office:string-value 465

19.380 office:target-frame 466

19.381 office:target-frame-name 466

19.382 office:time-value 467

19.383 office:title 467

19.384 office:value 467

19.385 office:value-type 468

19.386 office:version 469

19.387 presentation:action 469

19.388 presentation:animations 470

19.389 presentation:class 470

19.390 presentation:class-names 471

19.391 presentation:delay 471

19.392 presentation:direction 472

19.393 presentation:endless 473

19.394 presentation:effect 473

19.395 presentation:force-manual 474

19.396 presentation:full-screen 474

19.397 presentation:group-id 475

19.398 presentation:master-element 475

19.399 presentation:mouse-as-pen 475

19.400 presentation:mouse-visible 476

19.401 presentation:name 476

19.402 presentation:node-type 476

19.403 presentation:object 477

19.404 presentation:pages 477

19.405 presentation:path-id 477

19.406 presentation:pause 477

19.407 presentation:placeholder 478

19.408 presentation:play-full 478

19.409 presentation:presentation-page-layout-name 478

19.410 presentation:preset-class 478

19.411 presentation:preset-id 479

19.412 presentation:preset-sub-type 479

19.413 presentation:show 479

19.414 presentation:show-end-of-presentation-slide 479

19.415 presentation:show-logo 480

19.416 presentation:source 480

19.417 presentation:speed 480

19.418 presentation:start-scale 481

19.419 presentation:start-page 481

19.420 presentation:start-with-navigator 481

19.421 presentation:stay-on-top 482

19.422 presentation:style-name 482

19.423 presentation:transition-on-click 482

19.424 presentation:use-date-time-name 483

19.425 presentation:use-footer-name 483

19.426 presentation:use-header-name 483

19.427 presentation:user-transformed 483

19.428 presentation:verb 484

19.429 script:event-name 484

19.430 script:language 485

19.431 script:macro-name 485

19.432 smil:accelerate 485

19.433 smil:accumulate 485

19.434 smil:additive 486

19.435 smil:attributeName 486

19.436 smil:autoReverse 487

19.437 smil:begin 487

19.438 smil:by 487

19.439 smil:calcMode 487

19.440 smil:decelerate 488

19.441 smil:direction 488

19.442 smil:dur 488

19.443 smil:end 488

19.444 smil:endsync 489

19.445 smil:fadeColor 489

19.446 smil:fill 489

19.447 smil:fillDefault 489

19.448 smil:from 489

19.449 smil:keySplines 490

19.450 smil:keyTimes 490

19.451 smil:mode 490

19.452 smil:repeatCount 490

19.453 smil:repeatDur 490

19.454 smil:restart 491

19.455 smil:restartDefault 491

19.456 smil:subtype 491

19.457 smil:targetElement 491

19.458 smil:to 492

19.459 smil:type 492

19.460 smil:values 492

19.461 style:adjustment 492

19.462 style:apply-style-name 493

19.463 style:auto-update 493

19.464 style:base-cell-address 493

19.465 style:char 494

19.466 style:class 494

19.467 style:color 494

19.468 style:condition 494

19.469 style:data-style-name 496

19.469.1 General 496

19.469.2 <presentation:date-time-decl> 496

19.469.3 <style:style> 496

19.469.4 <text:creation-date> 496

19.469.5 <text:creation-time> 496

19.469.6 <text:database-display> 496

19.469.7 <text:date> 497

19.469.8 <text:editing-duration> 497

19.469.9 <text:expression> 497

19.469.10 <text:meta-field> 497

19.469.11 <text:modification-date> 497

19.469.12 <text:modification-time> 497

19.469.13 <text:print-date> 498

19.469.14 <text:print-time> 498

19.469.15 <text:table-formula> 498

19.469.16 <text:time> 498

19.469.17 <text:user-defined> 498

19.469.18 <text:user-field-get> 499

19.469.19 <text:user-field-input> 499

19.469.20 <text:variable-get> 499

19.469.21 <text:variable-input> 499

19.469.22 <text:variable-set> 499

19.470 style:default-outline-level 500

19.471 style:display 500

19.472 style:display-name 500

19.473 style:distance 501

19.474 style:distance-before-sep 501

19.475 style:distance-after-sep 501

19.476 style:family 501

19.477 style:filter-name 502

19.478 style:font-adornments 502

19.479 style:font-charset 502

19.480 style:font-family-generic 503

19.481 style:font-pitch 503

19.482 style:height 503

19.483 style:leader-char 503

19.484 style:leader-color 504

19.485 style:leader-style 504

19.486 style:leader-text 504

19.487 style:leader-text-style 505

19.488 style:leader-type 505

19.489 style:leader-width 505

19.490 style:legend-expansion 506

19.491 style:legend-expansion-aspect-ratio 506

19.492 style:length 506

19.493 style:line-style 507

19.494 style:lines 507

19.495 style:list-level 507

19.496 style:list-style-name 507

19.497 style:master-page-name 508

19.498 style:name 508

19.498.1 General 508

19.498.2 <number:boolean-style>, <number:currency-style>, <number:date-style>, <number:number-style>, <number:percentage-style>, <number:text-style>, <number:time-style>, <style:master-page>, <style:page-layout>, <style:presentation-page-layout>, <style:style>, <text:list-style>, <text:outline-style> 508

19.498.3 <style:font-face> 509

19.499 style:next-style-name 509

19.499.1 General 509

19.499.2 <style:master-page> 509

19.499.3 <style:style> 509

19.500 style:num-format 510

19.501 style:num-letter-sync 510

19.502 style:num-prefix 511

19.503 style:num-suffix 511

19.504 style:page-layout-name 511

19.505 style:page-usage 511

19.506 style:parent-style-name 512

19.507 style:percentage-data-style-name 512

19.508 style:position 512

19.508.1 General 512

19.508.2 <style:background-image> 512

19.508.3 <style:tab-stop> 513

19.508.4 <text:index-entry-tab-stop> 513

19.509 style:rel-height 513

19.510 style:rel-width 514

19.510.1 General 514

19.510.2 <draw:frame> 514

19.510.3 <style:column> 514

19.510.4 <style:footnote-sep> 515

19.511 style:repeat 515

19.512 style:rfc-language-tag 515

19.513 style:style 515

19.514 style:style-name 516

19.515 style:type 516

19.515.1 General 516

19.515.2 <text:index-entry-tab-stop> 516

19.515.3 <style:tab-stop> 516

19.516 style:vertical-align 517

19.517 style:volatile 517

19.518 style:width 517

19.518.1 General 517

19.518.2 <style:column-sep> 518

19.518.3 <style:footnote-sep> 518

19.519 svg:accent-height 518

19.520 svg:alphabetic 518

19.521 svg:ascent 518

19.522 svg:bbox 518

19.523 svg:cap-height 518

19.524 svg:cx 519

19.524.1 <draw:area-circle> 519

19.524.2 <draw:circle> 519

19.524.3 <draw:ellipse> 519

19.524.4 <svg:radialGradient> 519

19.525 svg:cy 519

19.525.1 <draw:area-circle> 519

19.525.2 <draw:circle> 520

19.525.3 <draw:ellipse> 520

19.525.4 <svg:radialGradient> 520

19.526 svg:d 520

19.527 svg:descent 520

19.528 svg:font-family 520

19.529 svg:font-size 521

19.530 svg:font-stretch 521

19.531 svg:font-style 521

19.532 svg:font-variant 521

19.533 svg:font-weight 521

19.534 svg:fx 521

19.535 svg:fy 522

19.536 svg:gradientTransform 522

19.537 svg:gradientUnits 522

19.538 svg:hanging 522

19.539 svg:height 522

19.539.1 <chart:chart> 522

19.539.2 <chart:plot-area> 523

19.539.3 <dr3d:scene> 523

19.539.4 <draw:area-polygon> 523

19.539.5 <draw:area-rectangle> 523

19.539.6 <draw:contour-polygon>, <draw:contour-path> 523

19.539.7 <draw:fill-image> 523

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> 524

19.539.9 <office:annotation> 524

19.539.10 <presentation:placeholder> 524

19.540 svg:ideographic 524

19.541 svg:mathematical 524

19.542 svg:name 525

19.543 svg:offset 525

19.544 svg:origin 525

19.545 svg:overline-position 525

19.546 svg:overline-thickness 525

19.547 svg:panose-1 525

19.548 svg:path 526

19.549 svg:r 526

19.549.1 <draw:area-circle> 526

19.549.2 <draw:circle> 526

19.549.3 <svg:radialGradient> 526

19.550 svg:rx 526

19.551 svg:ry 527

19.552 svg:slope 527

19.553 svg:spreadMethod 527

19.554 svg:stemh 527

19.555 svg:stemv 528

19.556 svg:stop-color 528

19.557 svg:stop-opacity 528

19.558 svg:strikethrough-position 528

19.559 svg:strikethrough-thickness 528

19.560 svg:string 528

19.561 svg:type 529

19.562 svg:underline-position 529

19.563 svg:underline-thickness 529

19.564 svg:unicode-range 529

19.565 svg:units-per-em 529

19.566 svg:v-alphabetic 529

19.567 svg:v-hanging 530

19.568 svg:v-ideographic 530

19.569 svg:v-mathematical 530

19.570 svg:viewBox 530

19.571 svg:width 530

19.571.1 <chart:chart> 530

19.571.2 <chart:floor> 531

19.571.3 <chart:plot-area> 531

19.571.4 <chart:wall> 531

19.571.5 <dr3d:scene> 531

19.571.6 <draw:area-polygon> 531

19.571.7 <draw:area-rectangle> 531

19.571.8 <draw:contour-polygon>, <draw:contour-path> 532

19.571.9 <draw:fill-image> 532

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> 532

19.571.11 <office:annotation> 532

19.571.12 <presentation:placeholder> 532

19.572 svg:widths 533

19.573 svg:x 533

19.573.1 <chart:data-label>, <chart:equation>, <chart:footer>, <chart:legend>, <chart:plot-area>, <chart:subtitle>, <chart:title> 533

19.573.2 <draw:area-polygon> 533

19.573.3 <draw:area-rectangle> 533

19.573.4 <dr3d:scene> 533

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> 534

19.573.6 <draw:glue-point> 534

19.573.7 <office:annotation> 534

19.573.8 <presentation:placeholder> 534

19.574 svg:x1 534

19.574.1 <draw:connector>, <draw:line> and <draw:measure> 534

19.574.2 <svg:linearGradient> 535

19.575 svg:x2 535

19.575.1 <draw:connector>, <draw:line> and <draw:measure> 535

19.575.2 <svg:linearGradient> 535

19.576 svg:x-height 535

19.577 svg:y 536

19.577.1 <chart:data-label>, <chart:equation>, <chart:footer>, <chart:legend>, <chart:plot-area>, <chart:subtitle>, <chart:title> 536

19.577.2 <draw:area-polygon> 536

19.577.3 <draw:area-rectangle> 536

19.577.4 <dr3d:scene> 536

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> 536

19.577.6 <draw:glue-point> 537

19.577.7 <office:annotation> 537

19.577.8 <presentation:placeholder> 537

19.578 svg:y1 537

19.578.1 <draw:connector>, <draw:line> and <draw:measure> 537

19.578.2 <svg:linearGradient> 537

19.579 svg:y2 538

19.579.1 <draw:connector>, <draw:line> and <draw:measure> 538

19.579.2 <svg:linearGradient> 538

19.580 table:acceptance-state 538

19.581 table:algorithm 539

19.582 table:add-empty-lines 539

19.583 table:allow-empty-cell 539

19.584 table:application-data 539

19.585 table:automatic-find-labels 540

19.586 table:base-cell-address 540

19.587 table:bind-styles-to-content 540

19.588 table:border-color 541

19.589 table:buttons 541

19.590 table:case-sensitive 541

19.591 table:cell-address 541

19.592 table:cell-range 542

19.593 table:cell-range-address 542

19.593.1 General 542

19.593.2 <chart:categories> 542

19.593.3 <chart:domain> - bubble 542

19.593.4 <chart:domain>- scatter 542

19.593.5 <chart:domain> - surface 543

19.593.6 <chart:plot-area> (deprecated) 543

19.593.7 <table:highlighted-range> 543

19.593.8 <table:named-range> 543

19.593.9 <table:source-cell-range> 544

19.594 table:column 544

19.595 table:comment 544

19.596 table:condition 544

19.597 table:condition-source 546

19.598 table:condition-source-range-address 546

19.599 table:contains-error 546

19.600 table:contains-header 546

19.601 table:content-validation-name 547

19.602 table:copy-back 547

19.603 table:copy-formulas 547

19.604 table:copy-styles 548

19.605 table:count 548

19.606 table:country 548

19.607 table:data-field 548

19.608 table:data-cell-range-address 548

19.609 table:database-name 549

19.610 table:database-table-name 549

19.611 table:data-type 549

19.611.1 General 549

19.611.2 <table:filter-condition> 549

19.611.3 <table:sort-by> 549

19.611.4 <table:sort-groups> 550

19.612 table:date-end 550

19.613 table:date-start 551

19.614 table:date-value 551

19.615 table:default-cell-style-name 551

19.616 table:direction 551

19.617 table:display 552

19.618 table:display-border 552

19.619 table:display-duplicates 552

19.620 table:display-filter-buttons 553

19.621 table:display-list 553

19.622 table:display-member-mode 553

19.623 table:drill-down-on-double-click 554

19.624 table:embedded-number-behavior 554

19.625 table:enabled 555

19.626 table:end 556

19.627 table:end-cell-address 556

19.628 table:end-column 556

19.629 table:end-position 556

19.630 table:end-row 557

19.631 table:end-table 557

19.632 table:end-x 557

19.633 table:end-y 557

19.634 table:execute 557

19.635 table:expression 558

19.636 table:field-name 558

19.637 table:field-number 558

19.638 table:filter-name 559

19.639 table:filter-options 559

19.640 table:first-row-end-column (deprecated) 559

19.641 table:first-row-start-column (deprecated) 559

19.642 table:formula 560

19.643 table:function 561

19.643.1 General 561

19.643.2 <table:consolidation> 561

19.643.3 <table:data-pilot-field> 561

19.643.4 <table:data-pilot-subtotal> 562

19.643.5 <table:subtotal-field> 562

19.644 table:grand-total 562

19.645 table:group-by-field-number 563

19.646 table:grouped-by 563

19.647 table:has-persistent-data 563

19.648 table:id 564

19.649 table:identify-categories 564

19.650 table:ignore-empty-rows 564

19.651 table:index 565

19.652 table:is-active 565

19.653 table:is-data-layout-field 565

19.654 table:is-selection 565

19.655 table:is-sub-table 566

19.656 table:label-cell-range-address 566

19.657 table:language 566

19.658 table:last-column-spanned 566

19.659 table:last-row-end-column (deprecated) 567

19.660 table:last-row-spanned 567

19.661 table:last-row-start-column (deprecated) 567

19.662 table:layout-mode 567

19.663 table:link-to-source-data 568

19.664 table:marked-invalid 568

19.665 table:matrix-covered 568

19.666 table:maximum-difference 569

19.667 table:member-count 569

19.668 table:member-name 569

19.669 table:member-type 569

19.670 table:message-type 570

19.671 table:mode 570

19.672 table:multi-deletion-spanned 570

19.673 table:name 571

19.673.1 General 571

19.673.2 <table:cell-range-source> 571

19.673.3 <table:content-validation> 571

19.673.4 <table:data-pilot-group> 571

19.673.5 <table:data-pilot-group-member> 571

19.673.6 <table:data-pilot-member> 571

19.673.7 <table:data-pilot-table> 572

19.673.8 <table:database-range> 572

19.673.9 <table:named-expression> 572

19.673.10 <table:named-range> 572

19.673.11 <table:operation> 572

19.673.12 <table:source-service> 573

19.673.13 <table:table> 573

19.673.14 <table:table-template> 573

19.674 table:null-year 573

19.675 table:number-columns-repeated 574

19.675.1 General 574

19.675.2 <table:covered-table-cell> 574

19.675.3 <table:table-cell> 574

19.675.4 <table:table-column> 574

19.676 table:number-columns-spanned 575

19.677 table:number-rows-repeated 575

19.678 table:number-rows-spanned 575

19.679 table:number-matrix-columns-spanned 575

19.680 table:number-matrix-rows-spanned 576

19.681 table:object-name 576

19.682 table:on-update-keep-size 576

19.683 table:on-update-keep-styles 576

19.684 table:operator 577

19.685 table:order 578

19.686 table:orientation 578

19.686.1 General 578

19.686.2 <table:data-pilot-field> 578

19.686.3 <table:database-range> 579

19.686.4 <table:label-range> 579

19.687 table:page-breaks-on-group-change 579

19.688 table:paragraph-style-name 579

19.689 table:parse-sql-statement 580

19.690 table:password 580

19.691 table:position 580

19.692 table:precision-as-shown 581

19.693 table:print 581

19.694 table:print-ranges 581

19.695 table:protect (deprecated) 581

19.696 table:protected 582

19.696.1 General 582

19.696.2 <table:covered-table-cell> 582

19.696.3 <table:scenario> 582

19.696.4 <table:table> 583

19.696.5 <table:table-cell> 583

19.697 table:protection-key 583

19.698 table:protection-key-digest-algorithm 583

19.699 table:query-name 584

19.700 table:range-usable-as 584

19.701 table:refresh-delay 584

19.702 table:rejecting-change-id 585

19.703 table:rfc-language-tag 585

19.704 table:row 585

19.705 table:scenario-ranges 586

19.706 table:script 586

19.707 table:search-criteria-must-apply-to-whole-cell 586

19.708 table:selected-page 586

19.709 table:show-details 587

19.710 table:show-empty 587

19.711 table:show-filter-button 587

19.712 table:sort-mode 588

19.713 table:source-cell-range-addresses 588

19.714 table:source-field-name 588

19.715 table:source-name 588

19.716 table:sql-statement 589

19.717 table:start 589

19.718 table:start-column 589

19.719 table:start-position 589

19.720 table:start-row 589

19.721 table:start-table 590

19.722 table:status 590

19.723 table:step 590

19.724 table:steps 590

19.725 table:structure-protected 590

19.726 table:style-name 591

19.726.1 General 591

19.726.2 <table:background> 591

19.726.3 <table:body> 591

19.726.4 <table:covered-table-cell> 591

19.726.5 <table:even-columns> 592

19.726.6 <table:even-rows> 592

19.726.7 <table:first-column> 592

19.726.8 <table:first-row> 592

19.726.9 <table:last-column> 592

19.726.10 <table:last-row> 592

19.726.11 <table:odd-columns> 593

19.726.12 <table:odd-rows> 593

19.726.13 <table:table-cell> 593

19.726.14 <table:table-column> 593

19.726.15 <table:table-row> 593

19.726.16 <table:table> 593

19.727 table:table 594

19.728 table:table-background 594

19.729 table:table-name 594

19.730 table:target-cell-address 594

19.731 table:target-range-address 595

19.731.1 General 595

19.731.2 <table:data-pilot-table> 595

19.731.3 <table:database-range> 595

19.731.4 <table:filter> 595

19.731.5 <table:sort> 595

19.732 table:template-name 595

19.733 table:title 596

19.734 table:track-changes 596

19.735 table:type 596

19.735.1 General 596

19.735.2 <table:data-pilot-field-reference> 596

19.735.3 <table:deletion> 597

19.735.4 <table:insertion> 597

19.736 table:use-banding-columns-styles 598

19.737 table:use-banding-rows-styles 598

19.738 table:use-first-column-styles 598

19.739 table:use-first-row-styles 599

19.740 table:use-last-column-styles 599

19.741 table:use-last-row-styles 599

19.742 table:use-labels 600

19.743 table:use-regular-expressions 600

19.744 table:use-wildcards 600

19.745 table:used-hierarchy 601

19.746 table:user-name 601

19.747 table:value 601

19.747.1 <table:filter-condition> 601

19.747.2 <table:filter-set-item> 602

19.748 table:value-type 602

19.749 table:visibility 602

19.750 text:active 602

19.751 text:address 603

19.752 text:alphabetical-separators 603

19.753 text:anchor-page-number 603

19.754 text:anchor-type 604

19.755 text:annote 605

19.756 text:author 605

19.757 text:bibliography-data-field 605

19.758 text:bibliography-type 606

19.759 text:booktitle 607

19.760 text:bullet-char 608

19.761 text:bullet-relative-size 608

19.762 text:capitalize-entries 608

19.763 text:c 609

19.764 text:caption-sequence-format 609

19.765 text:caption-sequence-name 609

19.766 text:change-id 609

19.767 text:chapter 610

19.768 text:citation-body-style-name 610

19.769 text:citation-style-name 610

19.770 text:class-names 610

19.770.1 General 610

19.770.2 <text:h> 610

19.770.3 <text:p> 611

19.770.4 <text:span> 611

19.771 text:column-name 611

19.772 text:combine-entries 611

19.773 text:combine-entries-with-dash 611

19.774 text:combine-entries-with-pp 612

19.775 text:comma-separated 612

19.776 text:cond-style-name 613

19.777 text:condition 613

19.777.1 General 613

19.777.2 <text:conditional-text> 613

19.777.3 <text:database-next> 613

19.777.4 <text:database-row-select> 613

19.777.5 <text:hidden-paragraph> 614

19.777.6 <text:hidden-text> 614

19.777.7 <text:section> 614

19.778 text:connection-name 614

19.779 text:consecutive-numbering 614

19.780 text:continue-list 615

19.781 text:continue-numbering 615

19.782 text:copy-outline-levels 615

19.783 text:count-empty-lines 616

19.784 text:count-in-text-boxes 616

19.785 text:current-value 616

19.786 text:custom1 616

19.787 text:custom2 617

19.788 text:custom3 617

19.789 text:custom4 617

19.790 text:custom5 617

19.791 text:database-name 617

19.792 text:date-adjust 617

19.793 text:date-value 618

19.794 text:default-style-name 618

19.795 text:description 618

19.796 text:display 618

19.796.1 General 618

19.796.2 <text:chapter> 618

19.796.3 <text:expression> 619

19.796.4 <text:file-name> 619

19.796.5 <text:index-entry-chapter> 620

19.796.6 <text:section> 620

19.796.7 <text:table-formula> 620

19.796.8 <text:template-name> 621

19.796.9 <text:user-field-get> 621

19.796.10 <text:variable-get> 621

19.796.11 <text:variable-input> 622

19.796.12 <text:variable-set> 622

19.797 text:display-levels 622

19.798 text:display-outline-level 622

19.799 text:duration 623

19.800 text:edition 623

19.801 text:editor 623

19.802 text:filter-name 623

19.803 text:fixed 623

19.804 text:footnotes-position 624

19.805 text:formula 624

19.806 text:global (deprecated) 624

19.807 text:howpublished 625

19.808 text:increment 625

19.809 text:id 625

19.809.1 General 625

19.809.2 <draw:text-box> 625

19.809.3 <text:alphabetical-index-mark-end> 626

19.809.4 <text:alphabetical-index-mark-start> 626

19.809.5 <text:changed-region> 626

19.809.6 <text:h> 626

19.809.7 <text:note> 627

19.809.8 <text:p> 627

19.809.9 <text:toc-mark-end> 627

19.809.10 <text:toc-mark-start> 627

19.809.11 <text:user-index-mark-end> 628

19.809.12 <text:user-index-mark-start> 628

19.810 text:identifier 628

19.811 text:index-name 628

19.812 text:index-scope 628

19.813 text:ignore-case 629

19.814 text:institution 629

19.815 text:is-hidden 629

19.816 text:is-list-header 630

19.817 text:isbn 630

19.818 text:issn 630

19.819 text:journal 630

19.820 text:key 631

19.821 text:key1 632

19.822 text:key2 632

19.823 text:key1-phonetic 632

19.824 text:key2-phonetic 632

19.825 text:kind 633

19.826 text:label 633

19.827 text:label-followed-by 633

19.828 text:level 633

19.829 text:list-id 634

19.830 text:list-tab-stop-position 634

19.831 text:main-entry 635

19.832 text:main-entry-style-name 635

19.833 text:master-page-name 635

19.834 text:month 635

19.835 text:name 636

19.835.1 General 636

19.835.2 <text:alphabetical-index> 636

19.835.3 <text:bibliography> 636

19.835.4 <text:bookmark> 636

19.835.5 <text:bookmark-end> 636

19.835.6 <text:bookmark-start> 636

19.835.7 <text:execute-macro> 636

19.835.8 <text:illustration-index> 637

19.835.9 <text:index-title> 637

19.835.10 <text:object-index> 637

19.835.11 <text:reference-mark> 637

19.835.12 <text:reference-mark-end> 637

19.835.13 <text:reference-mark-start> 637

19.835.14 <text:section> 638

19.835.15 <text:sequence> 638

19.835.16 <text:sequence-decl> 638

19.835.17 <text:table-of-content> 638

19.835.18 <text:table-index> 638

19.835.19 <text:user-defined> 638

19.835.20 <text:user-field-decl> 639

19.835.21 <text:user-field-get> 639

19.835.22 <text:user-field-input> 639

19.835.23 <text:user-index> 639

19.835.24 <text:variable-set> 639

19.835.25 <text:variable-decl> 639

19.835.26 <text:variable-get> 640

19.835.27 <text:variable-input> 640

19.836 text:note 640

19.837 text:note-class 640

19.838 text:number 640

19.839 text:number-lines 640

19.840 text:number-position 641

19.841 text:numbered-entries 641

19.842 text:offset 641

19.843 text:organizations 642

19.844 text:outline-level 642

19.844.1 General 642

19.844.2 <text:alphabetical-index-entry-template> 642

19.844.3 <text:chapter> 642

19.844.4 <text:h> 643

19.844.5 <text:index-entry-chapter> 643

19.844.6 <text:index-source-styles> 643

19.844.7 <text:user-index-mark> 643

19.844.8 <text:table-of-content-entry-template> 643

19.844.9 <text:table-of-content-source> 643

19.844.10 <text:toc-mark> 644

19.844.11 <text:toc-mark-start> 644

19.844.12 <text:user-index-entry-template> 644

19.844.13 <text:user-index-mark-start> 644

19.845 text:page-adjust 644

19.845.1 General 644

19.845.2 <text:page-number> 644

19.845.3 <text:page-variable-set> 645

19.846 text:pages 645

19.847 text:placeholder-type 645

19.848 text:prefix 645

19.849 text:protected 646

19.850 text:protection-key 646

19.851 text:protection-key-digest-algorithm 646

19.852 text:publisher 647

19.853 text:ref-name 647

19.853.1 General 647

19.853.2 <text:bookmark-ref> 647

19.853.3 <text:note-ref> 647

19.853.4 <text:reference-ref> 647

19.853.5 <text:sequence> 648

19.853.6 <text:sequence-ref> 648

19.854 text:reference-format 648

19.855 text:relative-tab-stop-position 649

19.856 text:report-type 650

19.857 text:restart-numbering 650

19.858 text:restart-on-page 650

19.859 text:row-number 650

19.860 text:school 651

19.861 text:section-name 651

19.862 text:series 651

19.863 text:select-page 651

19.863.1 General 651

19.863.2 <text:page-continuation> 651

19.863.3 <text:page-number> 652

19.864 text:separation-character 652

19.865 text:sort-algorithm 652

19.866 text:sort-ascending 653

19.867 text:sort-by-position 653

19.868 text:start-value 653

19.868.1 General 653

19.868.2 <text:h> 653

19.868.3 <text:list-item> 654

19.868.4 <text:list-level-style-number> 654

19.868.5 <text:notes-configuration> 654

19.868.6 <text:numbered-paragraph> 654

19.868.7 <text:outline-level-style> 654

19.869 text:start-numbering-at 655

19.870 text:string-value-phonetic 655

19.871 text:string-value 655

19.871.1 General 655

19.871.2 <text:alphabetical-index-mark> 655

19.871.3 <text:hidden-text> 655

19.871.4 <text:page-continuation> 656

19.871.5 <text:toc-mark> 656

19.871.6 <text:user-index-mark> 656

19.872 text:string-value-if-false 656

19.873 text:string-value-if-true 656

19.874 text:style-name 657

19.874.1 General 657

19.874.2 <text:a> 657

19.874.3 <text:alphabetical-index> 657

19.874.4 <text:alphabetical-index-entry-template> 657

19.874.5 <text:bibliography> 657

19.874.6 <text:bibliography-entry-template> 657

19.874.7 <text:h> 658

19.874.8 <text:illustration-index> 658

19.874.9 <text:illustration-index-entry-template> 658

19.874.10 <text:index-entry-bibliography> 658

19.874.11 <text:index-entry-chapter> 658

19.874.12 <text:index-entry-link-end> 658

19.874.13 <text:index-entry-link-start> 659

19.874.14 <text:index-entry-page-number> 659

19.874.15 <text:index-entry-span> 659

19.874.16 <text:index-entry-tab-stop> 659

19.874.17 <text:index-entry-text> 659

19.874.18 <text:index-source-style> 659

19.874.19 <text:index-title> 660

19.874.20 <text:index-title-template> 660

19.874.21 <text:linenumbering-configuration> 660

19.874.22 <text:list> 660

19.874.23 <text:list-level-style-number> 660

19.874.24 <text:list-level-style-bullet> 661

19.874.25 <text:numbered-paragraph> 661

19.874.26 <text:object-index> 661

19.874.27 <text:object-index-entry-template> 661

19.874.28 <text:outline-level-style> 662

19.874.29 <text:p> 662

19.874.30 <text:ruby> 662

19.874.31 <text:ruby-text> 662

19.874.32 <text:section> 662

19.874.33 <text:span> 662

19.874.34 <text:table-index-entry-template> 663

19.874.35 <text:table-of-content> 663

19.874.36 <text:table-of-content-entry-template> 663

19.874.37 <text:table-index> 663

19.874.38 <text:user-index> 663

19.874.39 <text:user-index-entry-template> 664

19.875 text:style-override 664

19.876 text:suffix 664

19.877 text:tab-ref 664

19.878 text:table-name 664

19.879 text:table-type 665

19.880 text:time-adjust 665

19.881 text:time-value 665

19.882 text:title 665

19.883 text:track-changes 665

19.884 text:url 666

19.885 text:use-caption 666

19.886 text:use-chart-objects 666

19.887 text:use-draw-objects 667

19.888 text:use-floating-frames 667

19.889 text:use-graphics 667

19.890 text:use-index-marks 668

19.891 text:use-index-source-styles 668

19.892 text:use-keys-as-entries 668

19.893 text:use-math-objects 669

19.894 text:use-objects 669

19.895 text:use-other-objects 669

19.896 text:use-outline-level 670

19.897 text:use-soft-page-breaks 670

19.898 text:use-spreadsheet-objects 671

19.899 text:use-tables 671

19.900 text:value 671

19.901 text:visited-style-name 672

19.902 text:volume 672

19.903 text:year 672

19.904 xforms:bind 672

19.905 xhtml:about 673

19.906 xhtml:content 673

19.907 xhtml:datatype 673

19.908 xhtml:property 674

19.909 xlink:actuate 674

19.910 xlink:href 675

19.910.1 General 675

19.910.2 <anim:audio> 675

19.910.3 <chart:chart> 675

19.910.4 <chart:symbol-image> 675

19.910.5 <db:component> 675

19.910.6 <db:connection-resource> 676

19.910.7 <db:file-based-database> 676

19.910.8 <draw:a> 676

19.910.9 <draw:applet> 676

19.910.10 <draw:area-circle> 676

19.910.11 <draw:area-polygon> 676

19.910.12 <draw:area-rectangle> 677

19.910.13 <draw:fill-image> 677

19.910.14 <draw:floating-frame> 677

19.910.15 <draw:image> 677

19.910.16 <draw:object> 677

19.910.17 <draw:object-ole> 677

19.910.18 <draw:plugin> 678

19.910.19 <form:button> 678

19.910.20 <form:connection-resource> 678

19.910.21 <form:image> 678

19.910.22 <form:form> 678

19.910.23 <meta:auto-reload> 678

19.910.24 <meta:template> 678

19.910.25 <presentation:event-listener> 679

19.910.26 <presentation:sound> 679

19.910.27 <script:event-listener> 679

19.910.28 <style:background-image> 679

19.910.29 <svg:definition-src> 679

19.910.30 <svg:font-face-uri> 679

19.910.31 <table:cell-range-source> 680

19.910.32 <table:table-source> 680

19.910.33 <text:a> 680

19.910.34 <text:alphabetical-index-auto-mark-file> 680

19.910.35 <text:list-level-style-image> 680

19.910.36 <text:script> 680

19.910.37 <text:section-source> 681

19.911 xlink:show 681

19.912 xlink:title 681

19.913 xlink:type 682

19.914 xml:id 682

20 Formatting Attributes 684

20.1 General 684

20.2 chart:angle-offset 684

20.3 chart:auto-position 684

20.4 chart:auto-size 684

20.5 chart:axis-label-position 685

20.6 chart:axis-position 685

20.7 chart:connect-bars 686

20.8 chart:data-label-number 686

20.9 chart:data-label-symbol 687

20.10 chart:data-label-text 687

20.11 chart:deep 687

20.12 chart:display-label 688

20.13 chart:error-category 688

20.14 chart:error-lower-indicator 689

20.15 chart:error-lower-limit 689

20.16 chart:error-lower-range 689

20.17 chart:error-margin 689

20.18 chart:error-percentage 690

20.19 chart:error-upper-indicator 690

20.20 chart:error-upper-limit 690

20.21 chart:error-upper-range 690

20.22 chart:gap-width 691

20.23 chart:group-bars-per-axis 691

20.24 chart:hole-size 691

20.25 chart:include-hidden-cells 691

20.26 chart:interpolation 692

20.27 chart:interval-major 694

20.28 chart:interval-minor-divisor 694

20.29 chart:japanese-candle-stick 695

20.30 chart:label-arrangement 695

20.31 chart:label-position 695

20.32 chart:label-position-negative 696

20.33 chart:lines (deprecated) 697

20.34 chart:link-data-style-to-source 697

20.35 chart:logarithmic 698

20.36 chart:maximum 698

20.37 chart:mean-value 698

20.38 chart:minimum 699

20.39 chart:origin 699

20.40 chart:overlap 699

20.41 chart:pie-offset 699

20.42 chart:percentage 700

20.43 chart:regression-type 700

20.44 chart:reverse-direction 701

20.45 chart:right-angled-axes 701

20.46 chart:scale-text 701

20.47 chart:series-source (deprecated) 702

20.48 chart:sort-by-x-values 702

20.49 chart:solid-type 702

20.50 chart:spline-order 703

20.51 chart:spline-resolution 703

20.52 chart:stacked 703

20.53 chart:symbol-height 704

20.54 chart:symbol-name 704

20.55 chart:symbol-type 704

20.56 chart:symbol-width 705

20.57 chart:text-overlap 705

20.58 chart:three-dimensional 705

20.59 chart:tick-marks-major-inner 706

20.60 chart:tick-marks-major-outer 706

20.61 chart:tick-marks-minor-inner 706

20.62 chart:tick-marks-minor-outer 707

20.63 chart:tick-mark-position 707

20.64 chart:treat-empty-cells 708

20.65 chart:vertical 708

20.66 chart:visible 708

20.67 dr3d:ambient-color 709

20.68 dr3d:back-scale 709

20.69 dr3d:backface-culling 709

20.70 dr3d:close-back 709

20.71 dr3d:close-front 710

20.72 dr3d:depth 710

20.73 dr3d:diffuse-color 710

20.74 dr3d:edge-rounding 710

20.75 dr3d:edge-rounding-mode 710

20.76 dr3d:emissive-color 711

20.77 dr3d:end-angle 711

20.78 dr3d:horizontal-segments 711

20.79 dr3d:lighting-mode 712

20.80 dr3d:normals-direction 712

20.81 dr3d:normals-kind 712

20.82 dr3d:shadow 713

20.83 dr3d:shininess 713

20.84 dr3d:specular-color 713

20.85 dr3d:texture-filter 713

20.86 dr3d:texture-kind 713

20.87 dr3d:texture-mode 714

20.88 dr3d:texture-generation-mode-x 714

20.89 dr3d:texture-generation-mode-y 714

20.90 dr3d:vertical-segments 715

20.91 draw:auto-grow-height 715

20.92 draw:auto-grow-width 715

20.93 draw:background-size 716

20.94 draw:blue 716

20.95 draw:caption-angle 716

20.96 draw:caption-angle-type 717

20.97 draw:caption-escape 717

20.98 draw:caption-escape-direction 717

20.99 draw:caption-fit-line-length 717

20.100 draw:caption-gap 718

20.101 draw:caption-line-length 718

20.102 draw:caption-type 718

20.103 draw:color-inversion 718

20.104 draw:color-mode 719

20.105 draw:contrast 719

20.106 draw:decimal-places 719

20.107 draw:draw-aspect 720

20.108 draw:end-guide 720

20.109 draw:end-line-spacing-horizontal 720

20.110 draw:end-line-spacing-vertical 720

20.111 draw:fill 721

20.112 draw:fill-color 721

20.113 draw:fill-gradient-name 721

20.114 draw:fill-hatch-name 721

20.115 draw:fill-hatch-solid 722

20.116 draw:fill-image-height 722

20.117 draw:fill-image-name 722

20.118 draw:fill-image-ref-point 722

20.119 draw:fill-image-ref-point-x 723

20.120 draw:fill-image-ref-point-y 723

20.121 draw:fill-image-width 723

20.122 draw:fit-to-contour 724

20.123 draw:fit-to-size 724

20.124 draw:frame-display-border 724

20.125 draw:frame-margin-horizontal 725

20.126 draw:frame-display-scrollbar 725

20.127 draw:frame-margin-vertical 725

20.128 draw:gamma 725

20.129 draw:green 726

20.130 draw:gradient-step-count 726

20.131 draw:guide-distance 726

20.132 draw:guide-overhang 726

20.133 draw:image-opacity 726

20.134 draw:line-distance 727

20.135 draw:luminance 727

20.136 draw:marker-end 727

20.137 draw:marker-end-center 727

20.138 draw:marker-end-width 727

20.139 draw:marker-start 728

20.140 draw:marker-start-center 728

20.141 draw:marker-start-width 728

20.142 draw:measure-align 728

20.143 draw:measure-vertical-align 729

20.144 draw:ole-draw-aspect (deprecated) 729

20.145 draw:opacity 729

20.146 draw:opacity-name 730

20.147 draw:parallel 730

20.148 draw:placing 730

20.149 draw:red 730

20.150 draw:secondary-fill-color 731

20.151 draw:shadow 731

20.152 draw:shadow-color 731

20.153 draw:shadow-offset-x 731

20.154 draw:shadow-offset-y 732

20.155 draw:shadow-opacity 732

20.156 draw:show-unit 732

20.157 draw:start-guide 732

20.158 draw:start-line-spacing-horizontal 732

20.159 draw:start-line-spacing-vertical 733

20.160 draw:stroke 733

20.161 draw:stroke-dash 733

20.162 draw:stroke-dash-names 733

20.163 draw:stroke-linejoin 734

20.164 svg:stroke-linecap 734

20.165 draw:symbol-color 734

20.166 draw:textarea-horizontal-align 734

20.167 draw:textarea-vertical-align 735

20.168 draw:tile-repeat-offset 735

20.169 draw:visible-area-height 736

20.170 draw:visible-area-left 736

20.171 draw:visible-area-top 736

20.172 draw:visible-area-width 737

20.173 draw:unit 737

20.174 draw:wrap-influence-on-position 737

20.175 fo:background-color 739

20.176 fo Border Properties 739

20.176.1 General 739

20.176.2 fo:border 739

20.176.3 fo:border-bottom 740

20.176.4 fo:border-left 740

20.176.5 fo:border-right 740

20.176.6 fo:border-top 740

20.177 fo:break-after 740

20.178 fo:break-before 741

20.179 fo:clip 741

20.180 fo:color 741

20.181 fo:country 741

20.182 fo:font-family 742

20.183 fo:font-size 742

20.184 fo:font-style 742

20.185 fo:font-variant 743

20.186 fo:font-weight 743

20.187 fo:height 743

20.188 fo:hyphenate 743

20.189 fo:hyphenation-keep 744

20.190 fo:hyphenation-ladder-count 744

20.191 fo:hyphenation-push-char-count 744

20.192 fo:hyphenation-remain-char-count 744

20.193 fo:keep-together 744

20.194 fo:keep-with-next 745

20.195 fo:language 745

20.196 fo:letter-spacing 745

20.197 fo:line-height 745

20.198 fo:margin 746

20.199 fo:margin-bottom 746

20.200 fo:margin-left 746

20.201 fo:margin-right 747

20.202 fo:margin-top 747

20.203 fo:max-height 747

20.204 fo:max-width 748

20.205 fo:min-height 748

20.205.1 <style:graphic-properties> 748

20.205.2 <style:header-footer-properties> 748

20.206 fo:min-width 748

20.207 fo:orphans 748

20.208 fo:page-height 749

20.209 fo:page-width 749

20.210 fo:padding 749

20.211 fo:padding-bottom 749

20.212 fo:padding-left 749

20.213 fo:padding-right 750

20.214 fo:padding-top 750

20.215 fo:script 750

20.216 fo:text-align 750

20.216.1 <style:paragraph-properties> 751

20.216.2 <style:list-level-properties> 751

20.217 fo:text-align-last 751

20.218 fo:text-indent 752

20.219 fo:text-shadow 752

20.220 fo:text-transform 752

20.221 fo:widows 752

20.222 fo:width 753

20.223 fo:wrap-option 753

20.224 presentation:background-objects-visible 753

20.225 presentation:background-visible 753

20.226 presentation:display-date-time 754

20.227 presentation:display-footer 754

20.228 presentation:display-header 754

20.229 presentation:display-page-number 755

20.230 presentation:duration 755

20.231 presentation:transition-speed 755

20.232 presentation:transition-style 756

20.233 presentation:transition-type 759

20.234 presentation:visibility 759

20.235 smil:direction 760

20.236 smil:fadeColor 760

20.237 smil:subtype 760

20.238 smil:type 760

20.239 style:auto-text-indent 760

20.240 style:background-transparency 761

20.241 style:border-line-width 761

20.242 style:border-line-width-bottom 761

20.243 style:border-line-width-left 762

20.244 style:border-line-width-right 762

20.245 style:border-line-width-top 762

20.246 style:cell-protect 763

20.247 style:column-width 763

20.248 style:country-asian 763

20.249 style:country-complex 764

20.250 style:decimal-places 764

20.251 style:diagonal-bl-tr 764

20.252 style:diagonal-bl-tr-widths 764

20.253 style:diagonal-tl-br 765

20.254 style:diagonal-tl-br-widths 765

20.255 style:direction 765

20.256 style:dynamic-spacing 765

20.257 style:editable 766

20.258 style:first-page-number 766

20.259 style:flow-with-text 766

20.260 style:font-charset 767

20.261 style:font-charset-asian 767

20.262 style:font-charset-complex 768

20.263 style:font-family-asian 768

20.264 style:font-family-complex 769

20.265 style:font-family-generic 769

20.266 style:font-family-generic-asian 770

20.267 style:font-family-generic-complex 770

20.268 style:font-independent-line-spacing 771

20.269 style:font-name 771

20.270 style:font-name-asian 771

20.271 style:font-name-complex 771

20.272 style:font-pitch 772

20.273 style:font-pitch-asian 772

20.274 style:font-pitch-complex 772

20.275 style:font-relief 773

20.276 style:font-size-asian 773

20.277 style:font-size-complex 773

20.278 style:font-size-rel 774

20.279 style:font-size-rel-asian 774

20.280 style:font-size-rel-complex 774

20.281 style:font-style-asian 775

20.282 style:font-style-complex 775

20.283 style:font-style-name 775

20.284 style:font-style-name-asian 776

20.285 style:font-style-name-complex 776

20.286 style:font-weight-asian 776

20.287 style:font-weight-complex 776

20.288 style:footnote-max-height 777

20.289 style:glyph-orientation-vertical 777

20.290 style:horizontal-pos 777

20.291 style:horizontal-rel 779

20.292 style:join-border 780

20.293 style:justify-single-word 781

20.294 style:language-asian 781

20.295 style:language-complex 781

20.296 style:layout-grid-base-height 781

20.297 style:layout-grid-base-width 782

20.298 style:layout-grid-color 782

20.299 style:layout-grid-display 782

20.300 style:layout-grid-lines 782

20.301 style:layout-grid-mode 782

20.302 style:layout-grid-print 783

20.303 style:layout-grid-ruby-below 783

20.304 style:layout-grid-ruby-height 783

20.305 style:layout-grid-snap-to 784

20.306 style:layout-grid-standard-mode 784

20.307 style:line-break 785

20.308 style:letter-kerning 785

20.309 style:line-height-at-least 785

20.310 style:line-spacing 785

20.311 style:may-break-between-rows 786

20.312 style:min-row-height 786

20.313 style:mirror 786

20.314 style:num-format 786

20.315 style:num-letter-sync 787

20.316 style:num-prefix 787

20.317 style:num-suffix 788

20.318 style:number-wrapped-paragraphs 788

20.319 style:overflow-behavior 788

20.320 style:page-number 789

20.321 style:paper-tray-name 789

20.322 style:print 789

20.323 style:print-content 790

20.323.1 General 790

20.323.2 <style:graphic-properties> 790

20.323.3 <style:table-cell-properties> 790

20.324 style:print-page-order 790

20.325 style:print-orientation 791

20.326 style:protect 791

20.326.1 General 791

20.326.2 <style:graphic-properties> 791

20.326.3 <style:section-properties> 791

20.327 style:punctuation-wrap 792

20.328 style:register-true 792

20.329 style:register-truth-ref-style-name 792

20.330 style:rel-column-width 793

20.331 style:rel-height 793

20.332 style:rel-width 793

20.332.1 <style:graphic-properties> 793

20.332.2 <style:table-properties> 794

20.333 style:repeat 794

20.334 style:repeat-content 794

20.335 style:rfc-language-tag 795

20.336 style:rfc-language-tag-asian 795

20.337 style:rfc-language-tag-complex 795

20.338 style:rotation-align 796

20.339 style:rotation-angle 796

20.340 style:row-height 796

20.341 style:ruby-align 797

20.342 style:ruby-position 797

20.343 style:run-through 798

20.344 style:scale-to 798

20.345 style:scale-to-pages 798

20.346 style:script-asian 798

20.347 style:script-complex 799

20.348 style:script-type 799

20.349 style:shadow 800

20.350 style:shrink-to-fit 800

20.351 style:snap-to-layout-grid 801

20.352 style:tab-stop-distance 801

20.353 style:table-centering 801

20.354 style:text-align-source 802

20.355 style:text-autospace 802

20.356 style:text-blinking 802

20.357 style:text-combine 802

20.358 style:text-combine-start-char 803

20.359 style:text-combine-end-char 803

20.360 style:text-emphasize 803

20.361 style:text-line-through-color 804

20.362 style:text-line-through-mode 804

20.363 style:text-line-through-style 804

20.364 style:text-line-through-text 805

20.365 style:text-line-through-text-style 805

20.366 style:text-line-through-type 805

20.367 style:text-line-through-width 806

20.368 style:text-outline 806

20.369 style:text-overline-color 807

20.370 style:text-overline-mode 807

20.371 style:text-overline-style 807

20.372 style:text-overline-type 808

20.373 style:text-overline-width 808

20.374 style:text-position 809

20.375 style:text-rotation-angle 809

20.376 style:text-rotation-scale 809

20.377 style:text-scale 810

20.378 style:text-underline-color 810

20.379 style:text-underline-mode 810

20.380 style:text-underline-style 810

20.381 style:text-underline-type 811

20.382 style:text-underline-width 811

20.383 style:use-optimal-column-width 812

20.384 style:use-optimal-row-height 812

20.385 style:use-window-font-color 812

20.386 style:vertical-align 813

20.386.1 <style:paragraph-properties> 813

20.386.2 <style:table-cell-properties> 813

20.387 style:vertical-pos 814

20.388 style:vertical-rel 814

20.389 style:width 815

20.390 style:wrap 815

20.391 style:wrap-contour 816

20.392 style:wrap-contour-mode 816

20.393 style:wrap-dynamic-threshold 816

20.394 style:writing-mode 817

20.394.1 General 817

20.394.2 <style:graphic-properties> 817

20.394.3 <style:page-layout-properties> 817

20.394.4 <style:paragraph-properties> 817

20.394.5 <style:section-properties> 817

20.394.6 <style:table-cell-properties> 818

20.394.7 <style:table-properties> 818

20.395 style:writing-mode-automatic 818

20.396 svg:fill-rule 819

20.397 svg:height 819

20.397.1 <style:graphic-properties> 819

20.397.2 <style:header-footer-properties> 819

20.398 svg:stroke-color 819

20.399 svg:stroke-opacity 819

20.400 svg:stroke-width 820

20.401 svg:x 820

20.402 svg:y 820

20.402.1 <style:graphic-properties> 820

20.402.2 <style:list-level-properties> 820

20.403 svg:width 820

20.404 table:align 820

20.405 table:border-model 821

20.406 table:display 821

20.407 text:anchor-page-number 821

20.408 text:anchor-type 822

20.409 text:animation 823

20.410 text:animation-delay 823

20.411 text:animation-direction 823

20.412 text:animation-repeat 824

20.413 text:animation-start-inside 824

20.414 text:animation-steps 824

20.415 text:animation-stop-inside 824

20.416 text:condition 825

20.417 text:display 825

20.418 text:dont-balance-text-columns 825

20.419 text:line-break 825

20.420 text:line-number 826

20.421 text:list-level-position-and-space-mode 826

20.422 text:min-label-distance 826

20.423 text:min-label-width 827

20.424 text:number-lines 827

20.425 text:space-before 827

Appendix A. OpenDocument Relax NG Schema 829

Appendix B. OpenDocument Metadata Manifest Ontology 830

Appendix C. MIME Types and File Name Extensions (Non Normative) 831

Appendix D. Accessibility Guidelines (Non Normative) 833

D.1. Title, Description and Caption of Graphical Elements 833

D.1.1. Guidance for authors 833

D.1.2. Authoring tool responsibility for presenting and prompting for the <svg:title> and <svg:desc> elements 833

D.2. Hyperlink Titles 834

D.3. Tables in Presentations 834

D.4. Further Guidelines 834

Appendix E. Bidirectional (BiDi) Scripts,Numeric Digits Presentation and Calendars (Non Normative) 835

E.1. Paragraph and Layout Direction 835

E.2. Numeric Digits Presentation and Calendars 836

Appendix F. Recommended Usage of SMIL 837

F.1. Slide Animation 837

F.2. Main Sequence 837

F.3. Interactive Sequence 838

Appendix G. Changes From Previous Specification Versions (Non Normative) 839

G.1. Changes from “Open Document Format for Office Applications (OpenDocument) v1.1” 839

1.4 Normative References 20

1.5 Non-Normative References 21

2 Expressions and Evaluators 22

2.1 Introduction 22

2.2 OpenDocument Formula Expression 22

2.3 Evaluators 22

2.3.1 OpenDocument Formula Evaluator 22

2.3.2 OpenDocument Formula Small Group Evaluator 22

2.3.3 OpenDocument Formula Medium Group Evaluator 23

2.3.4 OpenDocument Formula Large Group Evaluator 24

2.4 Variances (Implementation-defined, Unspecified, and Behavioral Changes) 25

3 Formula Processing Model 26

3.1 General 26

3.2 Expression Evaluation 26

3.2.1 General 26

3.2.2 Expression Calculation 26

3.2.3 Operator and Function Evaluation 26

3.3 Non-Scalar Evaluation (aka 'Array expressions') 27

3.4 Host-Defined Behaviors 29

3.5 When recalculation occurs 30

3.6 Numerical Models 30

4.3.7 Logical (Number) 33

4.4 Complex Number 34

4.5 Logical (Boolean) 34

4.11.6 TextOrNumber 36

4.11.12 Sequences (NumberSequence, NumberSequenceList, DateSequence, LogicalSequence, and ComplexSequence) 40

4.11.13 Any 40

5 Expression Syntax 41

5.1 General 41

5.2 Basic Expressions 41

5.3 Constant Numbers 42

5.4 Constant Strings 42

5.5 Operators 42

5.6 Functions and Function Parameters 43

5.7 Nonstandard Function Names 44

5.8 References 44

5.9 Reference List 45

5.10 Quoted Label 45

5.10.1 General 45

5.10.2 Lookup of Defined Labels 46

5.10.3 Automatic Lookup of Labels 46

5.10.4 Implicit Intersection 47

5.10.5 Automatic Range 47

5.10.6 Automatic Intersection 48

5.11 Named Expressions 48

5.12 Constant Errors 49

5.13 Inline Arrays 50

5.14 Whitespace 50

6 Standard Operators and Functions 51

6.1 General 51

6.2 Common Template for Functions and Operators 51

6.3 Implicit Conversion Operators 52

6.3.1 General 52

6.3.2 Conversion to Scalar 52

6.3.3 Implied intersection 52

6.3.4 Force to array context (ForceArray) 52

6.3.5 Conversion to Number 53

6.3.6 Conversion to Integer 53

6.3.7 Conversion to NumberSequence 53

6.3.8 Conversion to NumberSequenceList 54

6.3.9 Conversion to DateSequence 54

6.3.10 Conversion to Complex Number 54

6.3.11 Conversion to ComplexSequence 54

6.3.12 Conversion to Logical 55

6.3.13 Conversion to LogicalSequence 55

6.3.14 Conversion to Text 55

6.3.15 Conversion to DateParam 55

6.3.16 Conversion to TimeParam 55

6.4 Standard Operators 56

6.4.1 General 56

6.4.2 Infix Operator "+" 56

6.4.3 Infix Operator "-" 56

6.4.4 Infix Operator "*" 56

6.4.5 Infix Operator "/" 57

6.4.6 Infix Operator "^" 57

6.4.7 Infix Operator "=" 57

6.4.8 Infix Operator "<>" 57

6.4.9 Infix Operator Ordered Comparison ("<", "<=", ">", ">=") 58

6.4.10 Infix Operator "&" 58

6.4.11 Infix Operator Reference Range (":") 58

6.4.12 Infix Operator Reference Intersection ("!") 59

6.4.13 Infix Operator Reference Concatenation ("~") (aka Union) 59

6.4.14 Postfix Operator "%" 60

6.4.15 Prefix Operator "+" 60

6.4.16 Prefix Operator "-" 60

6.5 Matrix Functions 61

6.6 Bit operation functions 63

6.7 Byte-position text functions 64

6.8 Complex Number Functions 66

6.9 Database Functions 73

6.10 Date and Time Functions 76

6.10.11 ISOWEEKNUM 79

6.10.12 MINUTE 80

6.10.13 MONTH 80

6.10.14 NETWORKDAYS 80

6.11 External Access Functions 85

6.11.1 General 85

6.11.2 DDE 85

6.11.3 HYPERLINK 85

6.12 Financial Functions 86

6.12.21 FVSCHEDULE 97

6.12.31 ODDFPRICE 102

6.12.32 ODDFYIELD 102

6.12.33 ODDLPRICE 103

6.12.34 ODDLYIELD 103

6.12.35 PDURATION 104

6.12.36 PMT 104

6.12.37 PPMT 105

6.12.38 PRICE 105

6.12.39 PRICEDISC 106

6.12.48 TBILLPRICE 110

6.12.49 TBILLYIELD 111

6.12.54 YIELDDISC 113

6.12.55 YIELDMAT 114

6.13 Information Functions 114

6.13.8 COUNTBLANK 118

6.13.9 COUNTIF 118

6.13.10 COUNTIFS 118

6.13.11 ERROR.TYPE 119

6.13.18 ISFORMULA 121

6.13.19 ISLOGICAL 122

6.13.20 ISNA 122

6.13.21 ISNONTEXT 122

6.13.28 NUMBERVALUE 124

6.14 Lookup Functions 128

6.14.1 General 128

6.14.2 ADDRESS 128

6.14.3 CHOOSE 129

6.14.4 GETPIVOTDATA 129

6.14.10 MULTIPLE.OPERATIONS 134

6.14.11 OFFSET 135

6.14.12 VLOOKUP 136

6.15 Logical Functions 136

6.16 Mathematical Functions 139

6.16.29 EUROCONVERT 155

6.16.30 EVEN 156

6.16.31 EXP 157

6.16.32 FACT 157

6.16.33 FACTDOUBLE 157

6.16.43 MULTINOMIAL 160

6.16.51 RANDBETWEEN 162

6.16.52 SEC 162

6.16.53 SERIESSUM 162

6.16.64 SUMPRODUCT 167

6.17 Rounding Functions 169

6.18 Statistical Functions 171

6.18.6 AVERAGEIFS 173

6.18.7 BETADIST 173

6.18.8 BETAINV 174

6.18.9 BINOM.DIST.RANGE 174

6.18.10 BINOMDIST 175

6.18.11 LEGACY.CHIDIST 175

6.18.12 CHISQDIST 175

6.18.13 LEGACY.CHIINV 176

6.18.14 CHISQINV 176

6.18.15 LEGACY.CHITEST 176

6.18.16 CONFIDENCE 177

6.18.17 CORREL 177

6.18.18 COVAR 178

6.18.19 CRITBINOM 178

6.18.20 DEVSQ 178

6.18.21 EXPONDIST 179

6.18.22 FDIST 179

6.18.23 LEGACY.FDIST 180

6.18.24 FINV 180

6.18.25 LEGACY.FINV 180

6.18.26 FISHER 181

6.18.27 FISHERINV 181

6.18.28 FORECAST 181

6.18.29 FREQUENCY 182

6.18.30 FTEST 182

6.18.31 GAMMADIST 182

6.18.37 HYPGEOMDIST 185

6.18.38 INTERCEPT 186

6.18.44 LOGNORMDIST 191

6.18.51 NEGBINOMDIST 194

6.18.52 NORMDIST 194

6.18.53 NORMINV 195

6.18.54 LEGACY.NORMSDIST 195

6.18.55 LEGACY.NORMSINV 195

6.18.56 PEARSON 196

6.18.57 PERCENTILE 196

6.18.58 PERCENTRANK 197

6.18.59 PERMUT 198

6.18.60 PERMUTATIONA 198

6.18.71 STANDARDIZE 204

6.18.77 LEGACY.TDIST 206

6.19 Number Representation Conversion Functions 213

6.20 Text Functions 221

6.20.6 CONCATENATE 224

6.20.21 SUBSTITUTE 230

7 Other Capabilities 233

7.1 General 233

7.2 Inline constant arrays 233

7.3 Inline non-constant arrays 233

7.4 Year 1583 233

8 Non-portable Features 234

8.1 General 234

8.2 Distinct Logical 234

1 Introduction 8

1.1 Introduction 8

1.2 Terminology 8

1.3 Normative References 8

1.4 Non Normative References 9

1.5 Namespaces 9

2 Packages, Package Consumers and Package Producers 11

2.1 Introduction 11

2.2 Packages 11

2.2.1 OpenDocument Package 11

2.2.2 OpenDocument Extended Package 12

2.3 Producers 12

2.3.1 OpenDocument Package Producer 12

2.3.2 OpenDocument Package Extended Producer 12

2.4 OpenDocument Package Consumer 12

3 Packages 13

3.1 General 13

3.2 Manifest 13

3.3 MIME Media Type 13

3.4 Encryption 14

3.4.1 General 14

3.4.2 Encryption Process 14

3.5 Digital Signatures 15

3.6 Metadata 15

3.7 Usage of IRIs Within Packages 15

3.8 Preview Image 17

4 Manifest File 18

4.1 Introduction 18

4.2 <manifest:manifest> 18

4.3 <manifest:file-entry> 18

4.4 <manifest:encryption-data> 18

4.5 <manifest:algorithm> 19

4.6 <manifest:start-key-generation> 19

4.7 <manifest:key-derivation> 19

4.8 Manifest Attributes 20

4.8.1 manifest:algorithm-name 20

4.8.2 manifest:checksum 20

4.8.3 manifest:checksum-type 20

4.8.4 manifest:full-path 21

4.8.5 manifest:initialisation-vector 21

4.8.6 manifest:start-key-generation-name 22

4.8.7 manifest:key-size 22

4.8.8 manifest:iteration-count 22

4.8.9 manifest:key-derivation-name 23

4.8.10 manifest:media-type 23

4.8.11 manifest:preferred-view-mode 23

4.8.12 manifest:salt 24

4.8.13 manifest:size 24

4.8.14 manifest:version 24

5 Digital Signatures File 26

5.1 Introduction 26

5.2 <dsig:document-signatures> 26

5.3 <ds:Signature> 26

5.4 Digital Signatures Attributes 28

5.4.1 dsig:version 28

6 Metadata Manifest Files 29

6.1 General 29

6.2 pkg:Document 29

6.3 pkg:File 29

6.4 pkg:MetadataFile 29

7.2 W3C Schema Datatypes 31

7.3 Other Datatypes 31

7.3.1 namespacedToken 31

Appendix A. Schemas 32

A.1. OpenDocument Manifest Schema 32

A.2. OpenDocument Digital Signature Schema 32

Appendix B. OpenDocument Metadata Manifest Ontology 33

Appendix C. Zip File Structure (Non normative) 34

Appendix D. Changes From “Open Document Format for Office Applications (OpenDocument) v1.1” (Non Normative) 35

1 Introduction

1.1 Scope

1.2 Terminology

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 definition of behavior.

1.3 Normative References

1.4 Non Normative References

The individual parts of the OpenDocument specification each contains further non normative references.

1Introduction

1.1Scope

1.2Terminology

1.3Normative References

1.4Non Normative References

2Conformance

1 Introduction

1.1 Scope

1.2 Terminology

1.3 Normative References

1.4 Non Normative References

2 Conformance