Open Document Format for Office Applications (OpenDocument) Version 1.2

Committee Specification Draft 06

2 December 2010

Specification URIs:

This Version:

http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06.odt (Authoritative)
http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06.pdf
http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06.html

Previous Version:

http://docs.oasis-open.org/office/v1.2/cd05/OpenDocument-v1.2-cd05.odt (Authoritative)
http://docs.oasis-open.org/office/v1.2/cd05/OpenDocument-v1.2-cd05.pdf
http://docs.oasis-open.org/office/v1.2/cd05/OpenDocument-v1.2-cd05.html

Latest Version:

http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2.odt
http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2.pdf
http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2.html

Technical Committee:

OASIS Open Document Format for Office Applications (OpenDocument) TC

Chairs:

Rob Weir, IBM
Michael Brauer, Oracle Corporation

Editors:

Patrick Durusau <patrick@durusau.net>

Michael Brauer, Oracle Corporation <michael.brauer@sun.com>

Related Work:

This specification supersedes OASIS OpenDocument v1.1 [ODF11].

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

OpenDocument v1.2 part 1: OpenDocument Schema
OpenDocument v1.2 part 2: Recalculated Formula (OpenFormula) Format
OpenDocument v1.2 part 3: Packages
OpenDocument v1.2 Relax NG Schema
OpenDocument v1.2 Manifest Schema
OpenDocument v1.2 Digital Signature Schema
OpenDocument v1.2 Metadata Manifest Ontology
OpenDocument v1.2 Package Metadata Manifest Ontology

Declared XML Namespaces:

urn:oasis:names:tc:opendocument:xmlns:animation:1.0
urn:oasis:names:tc:opendocument:xmlns:chart:1.0
urn:oasis:names:tc:opendocument:xmlns:config:1.0
urn:oasis:names:tc:opendocument:xmlns:database:1.0
urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0
urn:oasis:names:tc:opendocument:xmlns:drawing:1.0
urn:oasis:names:tc:opendocument:xmlns:form:1.0
urn:oasis:names:tc:opendocument:xmlns:manifest:1.0
urn:oasis:names:tc:opendocument:xmlns:meta:1.0
urn:oasis:names:tc:opendocument:xmlns:data style:1.0
urn:oasis:names:tc:opendocument:xmlns:office:1.0
urn:oasis:names:tc:opendocument:xmlns:presentation:1.0
urn:oasis:names:tc:opendocument:xmlns:script:1.0
urn:oasis:names:tc:opendocument:xmlns:table:1.0
urn:oasis:names:tc:opendocument:xmlns:text:1.0
urn:oasis:names:tc:opendocument:xmlns:style:1.0
urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0
urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0
urn:oasis:names:tc:opendocument:xmlns:smil-compatible:1.0
urn:oasis:names:tc:opendocument:xmlns:of:1.2
http://docs.oasis-open.org/ns/office/1.2/meta/odf#
urn:oasis:names:tc:opendocument:xmlns:manifest:1.0
urn:oasis:names:tc:opendocument:xmlns:digitalsignature:1.0
http://docs.oasis-open.org/ns/office/1.2/meta/pkg#

Abstract:

This specification consists of this document as well as the following three parts:

Part 1 defines an XML schema for office applications and its semantics. The schema 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.

Part 2 defines a formula language to be used in OpenDocument documents.

Part 3 defines a package format to be used for OpenDocument documents.

Status:

This document was last revised or approved by the OASIS Open Document Format for Office Applications (OpenDocument) Technical Committee on the above date. The level of approval is also listed above. Check the current location noted above for possible later revisions of this document. This document is updated periodically on no particular schedule.

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 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 (www.oasis-open.org/committees/office/ipr.php.)

Citation Format:

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

OpenDocument-v1.2 OASIS Committee Specification Draft 06, Open Document Format for Office Applications (OpenDocument) Version 1.2, December 2010 http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06.odt

Notices

Copyright © OASIS® 2002–2010. All Rights Reserved.

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.

Table of Contents

1 Introduction 98

1.1 Scope 98

1.2 Terminology 98

1.3 Normative References 98

1.4 Non Normative References 99

2 Conformance 100

Appendix A. Changes From Previous Specification Versions (Non Normative) 102

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

Appendix B. Acknowledgments (Non Normative) 103

Table of Contents Part 1

1 Introduction 79

1.1 Introduction 79

1.2 Terminology 79

1.3 Normative References 79

1.4 Non Normative References 82

1.5 Namespaces 82

2 OpenDocument Documents, Consumers and Producers 85

2.1 Introduction 85

2.2 Documents 85

2.2.1 OpenDocument Document 85

2.2.2 OpenDocument Extended Document 86

2.2.3 OpenDocument Text Document 86

2.2.4 OpenDocument Spreadsheet Document 87

2.2.5 OpenDocument Drawing Document 87

2.2.6 OpenDocument Presentation Document 87

2.2.7 OpenDocument Chart Document 87

2.2.8 OpenDocument Image Document 88

2.2.9 OpenDocument Formula Document 88

2.2.10 OpenDocument Database Front End Document 88

2.3 Producers 88

2.3.1 OpenDocument Producer 88

2.3.2 OpenDocument Extended Producer 89

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 140

7.4.1 General 140

7.4.2 <text:variable-decls> 140

7.4.3 <text:variable-decl> 141

7.4.4 <text:variable-set> 141

7.4.5 <text:variable-get> 141

7.4.6 <text:variable-input> 141

7.4.7 <text:user-field-decls> 142

7.4.8 <text:user-field-decl> 142

7.4.9 <text:user-field-get> 142

7.4.10 <text:user-field-input> 143

7.4.11 <text:sequence-decls> 143

7.4.12 <text:sequence-decl> 143

7.4.13 <text:sequence> 144

7.4.14 <text:expression> 144

7.4.15 <text:text-input> 144

7.5 Metadata Fields 145

7.5.1 General 145

7.5.2 <text:initial-creator> 145

7.5.3 <text:creation-date> 145

7.5.4 <text:creation-time> 145

7.5.5 <text:description> 146

7.5.6 <text:user-defined> 146

7.5.7 <text:print-time> 146

7.5.8 <text:print-date> 146

7.5.9 <text:printed-by> 147

7.5.10 <text:title> 147

7.5.11 <text:subject> 147

7.5.12 <text:keywords> 148

7.5.13 <text:editing-cycles> 148

7.5.14 <text:editing-duration> 148

7.5.15 <text:modification-time> 148

7.5.16 <text:modification-date> 149

7.5.17 <text:creator> 149

7.5.18 Document Statistics Fields 149

7.5.18.1 General 149

7.5.18.2 <text:page-count> 149

7.5.18.3 <text:paragraph-count> 150

7.5.18.4 <text:word-count> 150

7.5.18.5 <text:character-count> 150

7.5.18.6 <text:table-count> 151

7.5.18.7 <text:image-count> 151

7.5.18.8 <text:object-count> 151

7.5.19 <text:meta-field> 151

7.6 Database Fields 153

7.6.1 General 153

7.6.2 <form:connection-resource> 153

7.6.3 <text:database-display> 153

7.6.4 <text:database-next> 154

7.6.5 <text:database-row-select> 154

7.6.6 <text:database-row-number> 154

7.6.7 <text:database-name> 155

7.7 More Fields 155

7.7.1 Page Variable Fields 155

7.7.1.1 General 155

7.7.1.2 <text:page-variable-set> 155

7.7.1.3 <text:page-variable-get> 156

7.7.2 <text:placeholder> 156

7.7.3 <text:conditional-text> 156

7.7.4 <text:hidden-text> 157

7.7.5 <text:reference-ref> 157

7.7.6 <text:bookmark-ref> 157

7.7.7 <text:note-ref> 157

7.7.8 <text:sequence-ref> 158

7.7.9 <text:script> 158

7.7.10 <text:execute-macro> 159

7.7.11 <text:hidden-paragraph> 159

7.7.12 <text:dde-connection> 159

7.7.13 <text:measure> 160

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

8 Text Indexes 161

8.1 Index Marks 161

8.1.1 General 161

8.1.2 <text:toc-mark-start> 161

8.1.3 <text:toc-mark-end> 161

8.1.4 <text:toc-mark> 162

8.1.5 <text:user-index-mark-start> 162

8.1.6 <text:user-index-mark-end> 162

8.1.7 <text:user-index-mark> 162

8.1.8 <text:alphabetical-index-mark-start> 163

8.1.9 <text:alphabetical-index-mark-end> 163

8.1.10 <text:alphabetical-index-mark> 163

8.1.11 <text:bibliography-mark> 164

8.2 Index Structure 164

8.2.1 General 164

8.2.2 <text:index-body> 164

8.2.3 <text:index-title> 165

8.3 <text:table-of-content> 165

8.3.1 General 165

8.3.2 <text:table-of-content-source> 166

8.3.3 <text:table-of-content-entry-template> 166

8.4 <text:illustration-index> 166

8.4.1 General 166

8.4.2 <text:illustration-index-source> 167

8.4.3 <text:illustration-index-entry-template> 167

8.5 <text:table-index> 167

8.5.1 General 167

8.5.2 <text:table-index-source> 168

8.5.3 <text:table-index-entry-template> 168

8.6 <text:object-index> 168

8.6.1 General 168

8.6.2 <text:object-index-source> 169

8.6.3 <text:object-index-entry-template> 169

8.7 <text:user-index> 169

8.7.1 General 169

8.7.2 <text:user-index-source> 170

8.7.3 <text:user-index-entry-template> 170

8.8 <text:alphabetical-index> 170

8.8.1 General 170

8.8.2 <text:alphabetical-index-source> 171

8.8.3 <text:alphabetical-index-auto-mark-file> 171

8.8.4 <text:alphabetical-index-entry-template> 172

8.9 <text:bibliography> 172

8.9.1 General 172

8.9.2 <text:bibliography-source> 172

8.9.3 <text:bibliography-entry-template> 172

8.10 <text:index-source-styles> 173

8.11 <text:index-source-style> 173

8.12 <text:index-title-template> 173

8.13 Index Template Entries 174

8.13.1 <text:index-entry-chapter> 174

8.13.2 <text:index-entry-text> 174

8.13.3 <text:index-entry-page-number> 174

8.13.4 <text:index-entry-span> 175

8.13.5 <text:index-entry-bibliography> 175

8.13.6 <text:index-entry-tab-stop> 175

8.13.7 <text:index-entry-link-start> 175

8.13.8 <text:index-entry-link-end> 176

9 Tables 177

9.1 Basic Tables 177

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

9.6.14 <table:data-pilot-sort-info> 198

9.6.15 <table:data-pilot-layout-info> 198

9.6.16 <table:data-pilot-field-reference> 198

9.6.17 <table:data-pilot-groups> 199

9.6.18 <table:data-pilot-group> 199

9.6.19 <table:data-pilot-group-member> 199

9.7 <table:consolidation> 199

9.8 <table:dde-links> 200

9.9 Change Tracking in Spreadsheets 200

9.9.1 General 200

9.9.2 <table:tracked-changes> 200

9.9.3 <table:insertion> 200

9.9.4 <table:dependencies> 201

9.9.5 <table:dependency> 201

9.9.6 <table:deletions> 201

9.9.7 <table:cell-content-deletion> 201

9.9.8 <table:change-deletion> 202

9.9.9 <table:deletion> 202

9.9.10 <table:cut-offs> 202

9.9.11 <table:insertion-cut-off> 202

9.9.12 <table:movement-cut-off> 203

9.9.13 <table:movement> 203

9.9.14 <table:source-range-address> 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> 205

10 Graphic Content 206

10.1 General 206

10.2 Enhanced Page Features for Graphical Applications 206

10.2.1 <style:handout-master> 206

10.2.2 <draw:layer-set> 206

10.2.3 <draw:layer> 207

10.2.4 <draw:page> 207

10.2.5 <draw:equation> 208

10.3 Drawing Shapes 208

10.3.1 General 208

10.3.2 <draw:rect> 208

10.3.3 <draw:line> 208

10.3.4 <draw:polyline> 209

10.3.5 <draw:polygon> 209

10.3.6 <draw:regular-polygon> 210

10.3.7 <draw:path> 211

10.3.8 <draw:circle> 211

10.3.9 <draw:ellipse> 212

10.3.10 <draw:connector> 212

10.3.11 <draw:caption> 213

10.3.12 <draw:measure> 213

10.3.13 <draw:control> 214

10.3.14 <draw:page-thumbnail> 215

10.3.15 <draw:g> 215

10.3.16 <draw:glue-point> 216

10.3.17 <svg:title> 216

10.3.18 <svg:desc> 217

10.3.19 <office:event-listeners> 217

10.4 Frames 217

10.4.1 General 217

10.4.2 <draw:frame> 218

10.4.3 <draw:text-box> 218

10.4.4 <draw:image> 219

10.4.5 <office:binary-data> 219

10.4.6 Objects 220

10.4.6.1 General 220

10.4.6.2 <draw:object> 220

10.4.6.3 <draw:object-ole> 220

10.4.7 <draw:applet> 221

10.4.8 <draw:plugin> 221

10.4.9 <draw:param> 221

10.4.10 <draw:floating-frame> 222

10.4.11 Contours 222

10.4.11.1 General 222

10.4.11.2 <draw:contour-polygon> 222

10.4.11.3 <draw:contour-path> 222

10.4.12 <draw:a> 223

10.4.13 Client Side Image Maps 223

10.4.13.1 General 223

10.4.13.2 <draw:image-map> 223

10.4.13.3 <draw:area-rectangle> 223

10.4.13.4 <draw:area-circle> 224

10.4.13.5 <draw:area-polygon> 224

10.5 3D Shapes 225

10.5.1 General 225

10.5.2 <dr3d:scene> 225

10.5.3 <dr3d:light> 225

10.5.4 <dr3d:cube> 226

10.5.5 <dr3d:sphere> 226

10.5.6 <dr3d:extrude> 226

10.5.7 <dr3d:rotate> 226

10.6 Custom Shape 227

10.6.1 <draw:custom-shape> 227

10.6.2 <draw:enhanced-geometry> 227

10.6.3 <draw:handle> 228

10.7 Presentation Shapes 228

10.8 Presentation Animations 229

10.8.1 <presentation:animations> 229

10.8.2 <presentation:sound> 229

10.8.3 <presentation:show-shape> 229

10.8.4 <presentation:show-text> 230

10.8.5 <presentation:hide-shape> 230

10.8.6 <presentation:hide-text> 230

10.8.7 <presentation:dim> 230

10.8.8 <presentation:play> 231

10.8.9 <presentation:animation-group> 231

10.9 SMIL Presentation Animations 231

10.9.1 General 231

10.9.2 <presentation:event-listener> 232

10.9.3 Presentation Document Content 232

10.9.3.1 <presentation:header> 232

10.9.3.2 <presentation:header-decl> 232

10.9.3.3 <presentation:footer> 232

10.9.3.4 <presentation:footer-decl> 233

10.9.3.5 <presentation:date-time> 233

10.9.3.6 <presentation:date-time-decl> 233

10.9.3.7 <presentation:settings> 234

10.9.3.8 <presentation:show> 234

11 Chart Content 235

11.1 <chart:chart> 235

11.2 Title, Subtitle and Footer 235

11.2.1 <chart:title> 235

11.2.2 <chart:subtitle> 235

11.2.3 <chart:footer> 236

11.3 <chart:legend> 236

11.4 <chart:plot-area> 237

11.5 3D Plot Area 237

11.6 <chart:wall> 237

11.7 <chart:floor> 237

11.8 <chart:axis> 238

11.9 <chart:categories> 238

11.10 <chart:grid> 238

11.11 <chart:series> 238

11.12 <chart:domain> 239

11.13 <chart:data-point> 239

11.14 <chart:data-label> 239

11.15 <chart:mean-value> 240

11.16 <chart:error-indicator> 240

11.17 <chart:regression-curve> 240

11.18 <chart:equation> 240

11.19 <chart:stock-gain-marker> 241

11.20 <chart:stock-loss-marker> 241

11.21 <chart:stock-range-line> 241

12 Database Front-end Document Content 242

12.1 <office:database> 242

12.2 <db:data-source> 242

12.3 <db:connection-data> 242

12.4 <db:database-description> 242

12.5 <db:file-based-database> 243

12.6 <db:server-database> 243

12.7 <db:connection-resource> 243

12.8 <db:login> 243

12.9 <db:driver-settings> 244

12.10 <db:auto-increment> 244

12.11 <db:delimiter> 244

12.12 <db:character-set> 244

12.13 <db:table-settings> 245

12.14 <db:table-setting> 245

12.15 <db:application-connection-settings> 245

12.16 <db:table-filter> 245

12.17 <db:table-include-filter> 246

12.18 <db:table-exclude-filter> 246

12.19 <db:table-filter-pattern> 246

12.20 <db:table-type-filter> 246

12.21 <db:table-type> 247

12.22 <db:data-source-settings> 247

12.23 <db:data-source-setting> 247

12.24 <db:data-source-setting-value> 247

12.25 Forms and Reports 248

12.25.1 General 248

12.25.2 <db:forms> 248

12.25.3 <db:reports> 248

12.25.4 <db:component-collection> 248

12.25.5 <db:component> 249

12.26 <db:queries> 249

12.27 <db:query-collection> 249

12.28 <db:query> 249

12.29 <db:order-statement> 250

12.30 <db:filter-statement> 250

12.31 <db:update-table> 250

12.32 <db:table-representations> 250

12.33 <db:table-representation> 251

12.34 <db:columns> 251

12.35 <db:column> 251

12.36 <db:schema-definition> 251

12.37 <db:table-definitions> 252

12.38 <db:table-definition> 252

12.39 <db:column-definitions> 252

12.40 <db:column-definition> 252

12.41 <db:keys> 253

12.42 <db:key> 253

12.43 <db:key-columns> 253

12.44 <db:key-column> 253

12.45 <db:indices> 253

12.46 <db:index> 254

12.47 <db:index-columns> 254

12.48 <db:index-column> 254

13 Form Content 255

13.1 General 255

13.2 <office:forms> 255

13.3 <form:form> 255

13.4 <xforms:model> 256

13.5 Controls 256

13.5.1 General 256

13.5.2 <form:text> 256

13.5.3 <form:textarea> 257

13.5.4 <form:password> 257

13.5.5 <form:file> 257

13.5.6 <form:formatted-text> 258

13.5.7 <form:number> 258

13.5.8 <form:date> 259

13.5.9 <form:time> 259

13.5.10 <form:fixed-text> 259

13.5.11 <form:combobox> 260

13.5.12 <form:item> 260

13.5.13 <form:listbox> 260

13.5.14 <form:option> 260

13.5.15 <form:button> 261

13.5.16 <form:image> 261

13.5.17 <form:checkbox> 261

13.5.18 <form:radio> 262

13.5.19 <form:frame> 262

13.5.20 <form:image-frame> 262

13.5.21 <form:hidden> 263

13.5.22 <form:grid> 263

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

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 290

16.27.1 General 290

16.27.2 <number:number-style> 290

16.27.3 <number:number> 290

16.27.4 <number:embedded-text> 290

16.27.5 <number:scientific-number> 291

16.27.6 <number:fraction> 291

16.27.7 <number:currency-style> 291

16.27.8 <number:currency-symbol> 291

16.27.9 <number:percentage-style> 292

16.27.10 <number:date-style> 292

16.27.11 <number:day> 293

16.27.12 <number:month> 293

16.27.13 <number:year> 293

16.27.14 <number:era> 293

16.27.15 <number:day-of-week> 294

16.27.16 <number:week-of-year> 294

16.27.17 <number:quarter> 294

16.27.18 <number:time-style> 294

16.27.19 <number:hours> 295

16.27.20 <number:minutes> 295

16.27.21 <number:seconds> 295

16.27.22 <number:am-pm> 295

16.27.23 <number:boolean-style> 296

16.27.24 <number:boolean> 296

16.27.25 <number:text-style> 296

16.27.26 <number:text> 296

16.27.27 <number:text-content> 297

16.27.28 <style:text-properties> 297

16.28 Text Style Families 298

16.28.1 Text Styles 298

16.28.2 Paragraph Styles 298

16.28.3 Section Styles 298

16.28.4 Ruby Styles 298

16.29 Enhanced Text Styles 298

16.29.1 <text:linenumbering-configuration> 298

16.29.2 <text:linenumbering-separator> 299

16.29.3 <text:notes-configuration> 299

16.29.4 <text:note-continuation-notice-forward> 299

16.29.5 <text:note-continuation-notice-backward> 300

16.29.6 <text:bibliography-configuration> 300

16.29.7 <text:sort-key> 300

16.30 <text:list-style> 300

16.31 <text:list-level-style-bullet> 301

16.32 <text:list-level-style-number> 301

16.33 <text:list-level-style-image> 302

16.34 <text:outline-style> 302

16.35 <text:outline-level-style> 302

16.36 Table Styles 303

16.36.1 Table Styles 303

16.36.2 Table Column Styles 303

16.36.3 Table Row Styles 303

16.36.4 Table Cell Styles 303

16.37 Graphic Styles 303

16.38 Presentation Styles 303

16.39 Drawing Page Style 303

16.40 Enhanced Graphic Style Elements 304

16.40.1 <draw:gradient> 304

16.40.2 <svg:linearGradient> 304

16.40.3 <svg:radialGradient> 304

16.40.4 <svg:stop> 305

16.40.5 <draw:hatch> 305

16.40.6 <draw:fill-image> 305

16.40.7 <draw:opacity> 306

16.40.8 <draw:marker> 306

16.40.9 <draw:stroke-dash> 307

16.41 <style:presentation-page-layout> 307

16.42 <presentation:placeholder> 307

16.43 Chart Styles 307

17 Formatting Elements 309

17.1 General 309

17.2 <style:page-layout-properties> 309

17.3 <style:background-image> 309

17.4 <style:footnote-sep> 310

17.5 <style:header-footer-properties> 310

17.6 <style:paragraph-properties> 311

17.7 <style:tab-stops> 311

17.8 <style:tab-stop> 311

17.9 <style:drop-cap> 312

17.10 <style:ruby-properties> 312

17.11 <style:section-properties> 312

17.12 <style:columns> 312

17.13 <style:column> 313

17.14 <style:column-sep> 313

17.15 <style:table-properties> 313

17.16 <style:table-column-properties> 314

17.17 <style:table-row-properties> 314

17.18 <style:table-cell-properties> 314

17.19 <style:list-level-properties> 315

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

17.21 <style:graphic-properties> 315

17.22 <style:chart-properties> 317

17.23 <chart:symbol-image> 318

17.24 <chart:label-separator> 318

17.25 <style:drawing-page-properties> 318

18 Datatypes 320

18.1 Introduction 320

18.2 W3C Schema Datatypes 320

18.3 Other Datatypes 321

18.3.1 angle 321

18.3.2 anyIRI 321

18.3.3 boolean 321

18.3.4 cellAddress 321

18.3.5 cellRangeAddress 321

18.3.6 cellRangeAddressList 321

18.3.7 character 321

18.3.8 clipShape 321

18.3.9 color 321

18.3.10 coordinate 321

18.3.11 countryCode 322

18.3.12 CURIE 322

18.3.13 CURIEs 322

18.3.14 dateOrDateTime 322

18.3.15 distance 322

18.3.16 language 322

18.3.17 languageCode 322

18.3.18 length 322

18.3.19 namespacedToken 322

18.3.20 nonNegativeLength 323

18.3.21 nonNegativePixelLength 323

18.3.22 pathData 323

18.3.23 percent 323

18.3.24 point3D 323

18.3.25 points 323

18.3.26 positiveLength 323

18.3.27 relativeLength 323

18.3.28 safeCURIE 323

18.3.29 scriptCode 323

18.3.30 signedZeroToHundredPercent 323

18.3.31 styleName 324

18.3.32 styleNameRef 324

18.3.33 styleNameRefs 324

18.3.34 targetFrameName 324

18.3.35 textEncoding 324

18.3.36 timeOrDateTime 324

18.3.37 URIorSafeCURIE 324

18.3.38 valueType 324

18.3.39 variableName 324

18.3.40 vector3D 324

18.3.41 zeroToHundredPercent 324

19 General Attributes 325

19.1 General 325

19.2 anim:color-interpolation 325

19.3 anim:color-interpolation-direction 325

19.4 anim:audio-level 325

19.5 anim:command 326

19.6 anim:formula 326

19.7 anim:id (deprecated) 327

19.8 anim:iterate-interval 328

19.9 anim:iterate-type 328

19.10 anim:name 328

19.11 anim:sub-item 328

19.12 anim:value 329

19.13 chart:attached-axis 329

19.14 chart:automatic-content 329

19.15 chart:class 330

19.15.1 <chart:chart>, <chart:series> 330

19.15.2 <chart:grid> 336

19.16 chart:column-mapping (deprecated) 337

19.17 chart:data-source-has-labels (deprecated) 337

19.18 chart:dimension 337

19.19 chart:display-equation 338

19.20 chart:display-r-square 338

19.21 chart:label-cell-address 338

19.22 chart:legend-align 339

19.23 chart:legend-position 339

19.24 chart:name 340

19.25 chart:repeated 340

19.26 chart:row-mapping (deprecated) 340

19.27 chart:style-name 340

19.28 chart:values-cell-range-address 341

19.29 config:name 341

19.30 config:type 341

19.31 db:additional-column-statement 342

19.32 db:append-table-alias-name 342

19.33 db:apply-command 342

19.34 db:as-template 342

19.35 db:base-dn 343

19.36 db:boolean-comparison-mode 343

19.37 db:catalog-name 343

19.38 db:command 343

19.39 db:data-source-setting-is-list 344

19.40 db:data-source-setting-name 344

19.41 db:data-source-setting-type 344

19.42 db:data-type 345

19.43 db:database-name 345

19.44 db:decimal 345

19.45 db:default-cell-style-name 345

19.46 db:default-row-style-name 345

19.47 db:delete-rule 346

19.48 db:description 346

19.49 db:enable-sql92-check 346

19.50 db:encoding 347

19.51 db:escape-processing 347

19.52 db:extension 347

19.53 db:field 347

19.54 db:hostname 347

19.55 db:ignore-driver-privileges 348

19.56 db:is-ascending 348

19.57 db:is-autoincrement 348

19.58 db:is-clustered 348

19.59 db:is-empty-allowed 349

19.60 db:is-first-row-header-line 349

19.61 db:login-timeout 349

19.62 db:is-nullable 349

19.63 db:is-password-required 350

19.64 db:is-unique 350

19.65 db:precision 350

19.66 db:is-table-name-length-limited 350

19.67 db:local-socket 351

19.68 db:max-row-count 351

19.69 db:media-type 351

19.70 db:name 351

19.70.1 General 351

19.70.2 <db:column> 351

19.70.3 <db:column-definition> 352

19.70.4 <db:component> 352

19.70.5 <db:component-collection> 352

19.70.6 <db:index> 352

19.70.7 <db:index-column> 352

19.70.8 <db:key> 352

19.70.9 <db:key-column> 353

19.70.10 <db:query> 353

19.70.11 <db:query-collection> 353

19.70.12 <db:table-definition> 353

19.70.13 <db:table-representation> 353

19.70.14 <db:update-table> 353

19.71 db:parameter-name-substitution 354

19.72 db:port 354

19.73 db:referenced-table-name 354

19.74 db:related-column-name 354

19.75 db:row-retrieving-statement 354

19.76 db:scale 355

19.77 db:schema-name 355

19.78 db:show-deleted 355

19.79 db:string 355

19.80 db:style-name 355

19.80.1 General 355

19.80.2 <db:column> 356

19.80.3 <db:query> 356

19.80.4 <db:table-representation> 356

19.81 db:suppress-version-columns 356

19.82 db:system-driver-settings 356

19.83 db:thousand 357

19.84 db:title 357

19.85 db:type 357

19.85.1 General 357

19.85.2 <db:key> 357

19.85.3 <db:server-database> 357

19.85.4 <db:table-definition> 358

19.86 db:type-name 358

19.87 db:update-rule 358

19.88 db:use-catalog 359

19.89 db:use-system-user 359

19.90 db:user-name 359

19.91 db:visible 359

19.92 dr3d:ambient-color 360

19.93 dr3d:center 360

19.94 dr3d:diffuse-color 360

19.95 dr3d:direction 360

19.96 dr3d:distance 360

19.97 dr3d:enabled 361

19.98 dr3d:focal-length 361

19.99 dr3d:lighting-mode 361

19.99.1 General 361

19.99.2 <chart:plot-area> 361

19.99.3 <dr3d:scene> 361

19.100 dr3d:max-edge 362

19.101 dr3d:min-edge 362

19.102 dr3d:projection 362

19.103 dr3d:shade-mode 362

19.104 dr3d:shadow-slant 363

19.105 dr3d:size 363

19.106 dr3d:specular 363

19.107 dr3d:transform 363

19.108 dr3d:vpn 364

19.109 dr3d:vrp 364

19.110 dr3d:vup 364

19.111 draw:align 364

19.112 draw:angle 365

19.113 draw:archive 365

19.114 draw:border 365

19.115 draw:caption-id 366

19.116 draw:caption-point-x 366

19.117 draw:caption-point-y 366

19.118 draw:chain-next-name 366

19.119 draw:class-id 366

19.120 draw:class-names 367

19.121 draw:code 367

19.122 draw:color 367

19.122.1 General 367

19.122.2 <draw:hatch> 367

19.122.3 <presentation:dim> 367

19.123 draw:concave 368

19.124 draw:concentric-gradient-fill-allowed 368

19.125 draw:control 368

19.126 draw:copy-of 368

19.127 draw:corner-radius 369

19.128 draw:corners 369

19.129 draw:cx 369

19.130 draw:cy 369

19.131 draw:data 370

19.132 draw:display 370

19.133 draw:display-name 370

19.133.1 General 370

19.133.2 <draw:fill-image> 370

19.133.3 <draw:gradient> 370

19.133.4 <draw:hatch> 371

19.133.5 <draw:marker> 371

19.133.6 <draw:opacity> 371

19.133.7 <draw:stroke-dash> 371

19.133.8 <svg:linearGradient> 371

19.133.9 <svg:radialGradient> 371

19.134 draw:distance 372

19.134.1 General 372

19.134.2 <draw:hatch> 372

19.134.3 <draw:stroke-dash> 372

19.135 draw:dots1 372

19.136 draw:dots1-length 372

19.137 draw:dots2 373

19.138 draw:dots2-length 373

19.139 draw:end 373

19.140 draw:end-angle 373

19.141 draw:end-color 373

19.142 draw:end-glue-point 374

19.143 draw:end-intensity 374

19.144 draw:end-shape 374

19.145 draw:enhanced-path 374

19.146 draw:engine 376

19.147 draw:escape-direction 377

19.148 draw:extrusion 377

19.149 draw:extrusion-allowed 377

19.150 draw:extrusion-brightness 378

19.151 draw:extrusion-color 378

19.152 draw:extrusion-depth 378

19.153 draw:extrusion-diffusion 378

19.154 draw:extrusion-first-light-direction 379

19.155 draw:extrusion-first-light-harsh 379

19.156 draw:extrusion-first-light-level 379

19.157 draw:extrusion-light-face 379

19.158 draw:extrusion-metal 380

19.159 draw:extrusion-number-of-line-segments 380

19.160 draw:extrusion-origin 380

19.161 draw:extrusion-rotation-angle 381

19.162 draw:extrusion-rotation-center 381

19.163 draw:extrusion-second-light-direction 381

19.164 draw:extrusion-second-light-harsh 382

19.165 draw:extrusion-second-light-level 382

19.166 draw:extrusion-shininess 382

19.167 draw:extrusion-skew 382

19.168 draw:extrusion-specularity 383

19.169 draw:extrusion-viewpoint 383

19.170 draw:filter-name 383

19.171 draw:formula 383

19.172 draw:frame-name 385

19.173 draw:glue-point-leaving-directions 385

19.174 draw:glue-point-type 386

19.175 draw:glue-points 386

19.176 draw:handle-mirror-horizontal 387

19.177 draw:handle-mirror-vertical 387

19.178 draw:handle-polar 387

19.179 draw:handle-position 388

19.180 draw:handle-radius-range-maximum 389

19.181 draw:handle-radius-range-minimum 389

19.182 draw:handle-range-x-maximum 390

19.183 draw:handle-range-x-minimum 390

19.184 draw:handle-range-y-maximum 390

19.185 draw:handle-range-y-minimum 390

19.186 draw:handle-switched 390

19.187 draw:id 391

19.187.1 General 391

19.187.2 <draw:glue-point> 391

19.187.3 <dr3d:cube>, <dr3d:extrude>, <dr3d:rotate>, <dr3d:scene>, <dr3d:sphere>, <draw:caption>, <draw:circle>, <draw:connector>, <draw:control>, <draw:custom-shape>, <draw:ellipse>, <draw:frame>, <draw:g>, <draw:line>, <draw:measure>, <draw:page>, <draw:page-thumbnail>, <draw:path>, <draw:polygon>, <draw:polyline>, <draw:rect>, <draw:regular-polygon> and <office:annotation> 391

19.188 draw:kind 392

19.189 draw:layer 392

19.190 draw:line-skew 392

19.191 draw:mime-type 393

19.192 draw:mirror-horizontal 393

19.193 draw:mirror-vertical 393

19.194 draw:master-page-name 394

19.195 draw:may-script 394

19.196 draw:modifiers 394

19.197 draw:name 394

19.197.1 General 394

19.197.2 <draw:caption> 395

19.197.3 <draw:circle> 395

19.197.4 <draw:connector> 395

19.197.5 <draw:control> 395

19.197.6 <draw:custom-shape> 395

19.197.7 <draw:ellipse> 395

19.197.8 <draw:equation> 396

19.197.9 <draw:fill-image> 396

19.197.10 <draw:frame> 396

19.197.11 <draw:g> 396

19.197.12 <draw:gradient> 396

19.197.13 <draw:hatch> 396

19.197.14 <draw:layer> 396

19.197.15 <draw:line> 397

19.197.16 <draw:marker> 397

19.197.17 <draw:measure> 397

19.197.18 <draw:opacity> 397

19.197.19 <draw:page> 397

19.197.20 <draw:page-thumbnail> 397

19.197.21 <draw:param> 398

19.197.22 <draw:path> 398

19.197.23 <draw:polygon> 398

19.197.24 <draw:polyline> 398

19.197.25 <draw:rect> 398

19.197.26 <draw:regular-polygon> 398

19.197.27 <draw:stroke-dash> 399

19.197.28 <office:annotation> (deprecated) 399

19.197.29 <svg:linearGradient> 399

19.197.30 <svg:radialGradient> 399

19.198 draw:nav-order 400

19.199 draw:nohref 400

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

19.201 draw:object 400

19.202 draw:opacity 401

19.203 draw:page-number 401

19.204 draw:path-stretchpoint-x 401

19.205 draw:path-stretchpoint-y 401

19.206 draw:points 402

19.207 draw:protected 402

19.208 draw:recreate-on-edit 402

19.209 draw:rotation 403

19.210 draw:shape-id 403

19.211 draw:sharpness 403

19.212 draw:start 403

19.213 draw:start-angle 403

19.214 draw:start-color 404

19.215 draw:start-glue-point 404

19.216 draw:start-intensity 404

19.217 draw:start-shape 404

19.218 draw:style 404

19.218.1 General 404

19.218.2 <draw:gradient> 405

19.218.3 <draw:hatch> 405

19.218.4 <draw:opacity> 406

19.218.5 <draw:stroke-dash> 406

19.219 draw:style-name 406

19.219.1 General 406

19.219.2 <dr3d:cube> 406

19.219.3 <dr3d:extrude> 407

19.219.4 <dr3d:rotate> 407

19.219.5 <dr3d:scene> 407

19.219.6 <dr3d:sphere> 407

19.219.7 <draw:caption> 407

19.219.8 <draw:circle> 407

19.219.9 <draw:connector> 408

19.219.10 <draw:control> 408

19.219.11 <draw:custom-shape> 408

19.219.12 <draw:ellipse> 408

19.219.13 <draw:frame> 408

19.219.14 <draw:g> 408

19.219.15 <draw:line> 409

19.219.16 <draw:measure> 409

19.219.17 <draw:page> 409

19.219.18 <draw:page-thumbnail> 409

19.219.19 <draw:path> 409

19.219.20 <draw:polygon> 409

19.219.21 <draw:polyline> 410

19.219.22 <draw:rect> 410

19.219.23 <draw:regular-polygon> 410

19.219.24 <office:annotation> 410

19.219.25 <presentation:notes> 410

19.219.26 <style:handout-master> 411

19.219.27 <style:master-page> 411

19.220 draw:text-areas 411

19.221 draw:text-path 412

19.222 draw:text-path-allowed 412

19.223 draw:text-path-mode 413

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

19.225 draw:text-path-scale 413

19.226 draw:text-rotate-angle 414

19.227 draw:text-style-name 414

19.228 draw:transform 414

19.229 draw:type 415

19.229.1 General 415

19.229.2 <draw:connector> 415

19.229.3 <draw:enhanced-geometry> 415

19.230 draw:value 416

19.231 draw:z-index 416

19.232 fo:column-count 416

19.233 fo:column-gap 416

19.234 fo:country 417

19.234.1 <text:alphabetical-index-source> 417

19.234.2 <text:bibliography-configuration> 417

19.235 fo:end-indent 417

19.236 fo:language 417

19.236.1 General 417

19.236.2 <text:alphabetical-index-source> 418

19.236.3 <text:bibliography-configuration> 418

19.237 fo:margin-left 418

19.238 fo:max-height 418

19.239 fo:max-width 419

19.240 fo:min-height 419

19.241 fo:min-width 419

19.242 fo:script 420

19.242.1 General 420

19.242.2 <text:alphabetical-index-source> 420

19.242.3 <text:bibliography-configuration> 420

19.243 fo:space-after 420

19.244 fo:space-before 420

19.245 fo:start-indent 421

19.246 fo:text-indent 421

19.247 form:allow-deletes 421

19.248 form:allow-inserts 421

19.249 form:allow-updates 422

19.250 form:apply-design-mode 422

19.251 form:apply-filter 422

19.252 form:auto-complete 423

19.253 form:automatic-focus 423

19.254 form:bound-column 423

19.255 form:button-type 424

19.256 form:command 424

19.257 form:command-type 424

19.258 form:control-implementation 425

19.259 form:convert-empty-to-null 425

19.260 form:current-selected 425

19.261 form:current-state 426

19.262 form:current-value 426

19.263 form:data-field 426

19.264 form:datasource 427

19.265 form:default-button 427

19.266 form:delay-for-repeat 428

19.267 form:detail-fields 428

19.268 form:disabled 428

19.269 form:dropdown 428

19.270 form:echo-char 429

19.271 form:enctype 429

19.272 form:escape-processing 429

19.273 form:filter 430

19.274 form:focus-on-click 430

19.275 form:for 430

19.276 form:id 430

19.277 form:ignore-result 431

19.278 form:image-align 431

19.279 form:image-data 431

19.280 form:image-position 432

19.281 form:is-tristate 432

19.282 form:label 432

19.283 form:linked-cell 433

19.284 form:list-linkage-type 433

19.285 form:list-source 433

19.286 form:list-source-type 434

19.287 form:master-fields 435

19.288 form:max-length 435

19.289 form:max-value 435

19.289.1 General 435

19.289.2 <form:date> 435

19.289.3 <form:formatted-text> 436

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

19.289.5 <form:time> 436

19.290 form:min-value 436

19.290.1 General 436

19.290.2 <form:date> 436

19.290.3 <form:formatted-text> 436

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

19.290.5 <form:time> 437

19.291 form:method 437

19.292 form:multi-line 437

19.293 form:multiple 437

19.294 form:name 438

19.295 form:navigation-mode 438

19.296 form:order 438

19.297 form:orientation 439

19.298 form:page-step-size 439

19.299 form:printable 439

19.300 form:property-name 439

19.301 form:readonly 440

19.302 form:repeat 440

19.303 form:selected 440

19.304 form:size 441

19.305 form:source-cell-range 441

19.306 form:spin-button 441

19.307 form:state 442

19.308 form:step-size 442

19.309 form:tab-cycle 442

19.310 form:tab-index 443

19.311 form:tab-stop 443

19.312 form:text-style-name 444

19.313 form:title 444

19.314 form:toggle 444

19.315 form:validation 444

19.316 form:value 445

19.316.1 General 445

19.316.2 <form:button> 445

19.316.3 <form:date> 445

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

19.316.5 <form:checkbox>, <form:combobox>, <form:file>, <form:formatted-text>, <form:hidden>, <form:image>, <form:option>, <form:password>, <form:radio>, <form:text>, <form:textarea> 445

19.316.6 <form:time> 446

19.317 form:visual-effect 446

19.318 form:xforms-list-source 446

19.319 form:xforms-submission 446

19.320 grddl:transformation 446

19.321 meta:cell-count 447

19.322 meta:character-count 447

19.323 meta:date 447

19.324 meta:delay 447

19.325 meta:draw-count 448

19.326 meta:frame-count 448

19.327 meta:image-count 448

19.328 meta:name 448

19.329 meta:non-whitespace-character-count 448

19.330 meta:object-count 449

19.331 meta:ole-object-count 449

19.332 meta:page-count 449

19.333 meta:paragraph-count 449

19.334 meta:row-count 449

19.335 meta:sentence-count 450

19.336 meta:syllable-count 450

19.337 meta:table-count 450

19.338 meta:value-type 450

19.339 meta:word-count 451

19.340 number:automatic-order 451

19.341 number:calendar 451

19.342 number:country 452

19.343 number:decimal-places 452

19.343.1 General 452

19.343.2 <number:number> 452

19.343.3 <number:seconds> 453

19.343.4 <number:scientific-number> 453

19.344 number:decimal-replacement 453

19.345 number:denominator-value 453

19.346 number:display-factor 454

19.347 number:format-source 454

19.348 number:grouping 454

19.349 number:language 455

19.350 number:min-denominator-digits 455

19.351 number:min-exponent-digits 455

19.352 number:min-integer-digits 455

19.353 number:min-numerator-digits 455

19.354 number:position 456

19.355 number:possessive-form 456

19.356 number:rfc-language-tag 456

19.357 number:script 457

19.358 number:style 457

19.358.1 General 457

19.358.2 <number:day> 457

19.358.3 <number:day-of-week> 457

19.358.4 <number:era> 458

19.358.5 <number:hours> 458

19.358.6 <number:minutes> 458

19.358.7 <number:month> 458

19.358.8 <number:quarter> 459

19.358.9 <number:seconds> 459

19.358.10 <number:year> 459

19.359 number:textual 459

19.360 number:title 460

19.361 number:transliteration-country 460

19.362 number:transliteration-format 460

19.363 number:transliteration-language 460

19.364 number:transliteration-style 461

19.365 number:truncate-on-overflow 461

19.366 office:automatic-update 461

19.367 office:boolean-value 462

19.368 office:conversion-mode 462

19.369 office:currency 463

19.370 office:date-value 463

19.371 office:dde-application 463

19.372 office:dde-item 463

19.373 office:dde-topic 464

19.374 office:display 464

19.375 office:mimetype 464

19.376 office:name 464

19.376.1 General 464

19.376.2 <draw:a> 464

19.376.3 <draw:area-circle> 465

19.376.4 <draw:area-rectangle> 465

19.376.5 <draw:area-polygon> 465

19.376.6 <office:annotation> 465

19.376.7 <office:annotation-end> 465

19.376.8 <office:dde-source> 466

19.376.9 <text:a> 466

19.376.10 <text:dde-connection-decl> 466

19.377 office:process-content (deprecated) 466

19.378 office:server-map 466

19.379 office:string-value 467

19.380 office:target-frame 467

19.381 office:target-frame-name 467

19.382 office:time-value 468

19.383 office:title 468

19.384 office:value 468

19.385 office:value-type 469

19.386 office:version 470

19.387 presentation:action 471

19.388 presentation:animations 472

19.389 presentation:class 472

19.390 presentation:class-names 473

19.391 presentation:delay 473

19.392 presentation:direction 473

19.393 presentation:endless 475

19.394 presentation:effect 475

19.395 presentation:force-manual 476

19.396 presentation:full-screen 476

19.397 presentation:group-id 477

19.398 presentation:master-element 477

19.399 presentation:mouse-as-pen 477

19.400 presentation:mouse-visible 477

19.401 presentation:name 478

19.402 presentation:node-type 478

19.403 presentation:object 479

19.404 presentation:pages 479

19.405 presentation:path-id 479

19.406 presentation:pause 479

19.407 presentation:placeholder 480

19.408 presentation:play-full 480

19.409 presentation:presentation-page-layout-name 480

19.410 presentation:preset-class 480

19.411 presentation:preset-id 481

19.412 presentation:preset-sub-type 481

19.413 presentation:show 481

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

19.415 presentation:show-logo 482

19.416 presentation:source 482

19.417 presentation:speed 482

19.418 presentation:start-scale 483

19.419 presentation:start-page 483

19.420 presentation:start-with-navigator 483

19.421 presentation:stay-on-top 483

19.422 presentation:style-name 484

19.423 presentation:transition-on-click 484

19.424 presentation:use-date-time-name 484

19.425 presentation:use-footer-name 485

19.426 presentation:use-header-name 485

19.427 presentation:user-transformed 485

19.428 presentation:verb 485

19.429 script:event-name 486

19.430 script:language 487

19.431 script:macro-name 487

19.432 smil:accelerate 487

19.433 smil:accumulate 487

19.434 smil:additive 487

19.435 smil:attributeName 488

19.436 smil:autoReverse 489

19.437 smil:begin 489

19.438 smil:by 489

19.439 smil:calcMode 489

19.440 smil:decelerate 490

19.441 smil:direction 490

19.442 smil:dur 490

19.443 smil:end 490

19.444 smil:endsync 490

19.445 smil:fadeColor 491

19.446 smil:fill 491

19.447 smil:fillDefault 491

19.448 smil:from 491

19.449 smil:keySplines 492

19.450 smil:keyTimes 492

19.451 smil:mode 492

19.452 smil:repeatCount 492

19.453 smil:repeatDur 492

19.454 smil:restart 493

19.455 smil:restartDefault 493

19.456 smil:subtype 493

19.457 smil:targetElement 493

19.458 smil:to 494

19.459 smil:type 494

19.460 smil:values 494

19.461 style:adjustment 494

19.462 style:apply-style-name 495

19.463 style:auto-update 495

19.464 style:base-cell-address 495

19.465 style:char 495

19.466 style:class 496

19.467 style:color 496

19.468 style:condition 496

19.469 style:data-style-name 497

19.469.1 General 497

19.469.2 <presentation:date-time-decl> 497

19.469.3 <style:style> 498

19.469.4 <text:creation-date> 498

19.469.5 <text:creation-time> 498

19.469.6 <text:database-display> 498

19.469.7 <text:date> 498

19.469.8 <text:editing-duration> 499

19.469.9 <text:expression> 499

19.469.10 <text:meta-field> 499

19.469.11 <text:modification-date> 499

19.469.12 <text:modification-time> 499

19.469.13 <text:print-date> 499

19.469.14 <text:print-time> 500

19.469.15 <text:table-formula> 500

19.469.16 <text:time> 500

19.469.17 <text:user-defined> 500

19.469.18 <text:user-field-get> 500

19.469.19 <text:user-field-input> 501

19.469.20 <text:variable-get> 501

19.469.21 <text:variable-input> 501

19.469.22 <text:variable-set> 501

19.470 style:default-outline-level 501

19.471 style:display 502

19.472 style:display-name 502

19.473 style:distance 502

19.474 style:distance-before-sep 503

19.475 style:distance-after-sep 503

19.476 style:family 503

19.477 style:filter-name 504

19.478 style:font-adornments 504

19.479 style:font-charset 504

19.480 style:font-family-generic 504

19.481 style:font-pitch 505

19.482 style:height 505

19.483 style:leader-char 505

19.484 style:leader-color 505

19.485 style:leader-style 506

19.486 style:leader-text 506

19.487 style:leader-text-style 507

19.488 style:leader-type 507

19.489 style:leader-width 507

19.490 style:legend-expansion 508

19.491 style:legend-expansion-aspect-ratio 508

19.492 style:length 508

19.493 style:line-style 508

19.494 style:lines 509

19.495 style:list-level 509

19.496 style:list-style-name 509

19.497 style:master-page-name 509

19.498 style:name 510

19.498.1 General 510

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

19.498.3 <style:font-face> 511

19.499 style:next-style-name 511

19.499.1 General 511

19.499.2 <style:master-page> 511

19.499.3 <style:style> 511

19.500 style:num-format 511

19.501 style:num-letter-sync 512

19.502 style:num-prefix 512

19.503 style:num-suffix 513

19.504 style:page-layout-name 513

19.505 style:page-usage 513

19.506 style:parent-style-name 514

19.507 style:percentage-data-style-name 514

19.508 style:position 514

19.508.1 General 514

19.508.2 <style:background-image> 514

19.508.3 <style:tab-stop> 515

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

19.509 style:rel-height 515

19.510 style:rel-width 516

19.510.1 General 516

19.510.2 <draw:frame> 516

19.510.3 <style:column> 516

19.510.4 <style:footnote-sep> 516

19.511 style:repeat 517

19.512 style:rfc-language-tag 517

19.513 style:style 517

19.514 style:style-name 518

19.515 style:type 518

19.515.1 General 518

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

19.515.3 <style:tab-stop> 518

19.516 style:vertical-align 519

19.517 style:volatile 519

19.518 style:width 519

19.518.1 General 519

19.518.2 <style:column-sep> 519

19.518.3 <style:footnote-sep> 520

19.519 svg:accent-height 520

19.520 svg:alphabetic 520

19.521 svg:ascent 520

19.522 svg:bbox 520

19.523 svg:cap-height 520

19.524 svg:cx 521

19.524.1 <draw:area-circle> 521

19.524.2 <draw:circle> 521

19.524.3 <draw:ellipse> 521

19.524.4 <svg:radialGradient> 521

19.525 svg:cy 521

19.525.1 <draw:area-circle> 521

19.525.2 <draw:circle> 521

19.525.3 <draw:ellipse> 522

19.525.4 <svg:radialGradient> 522

19.526 svg:d 522

19.527 svg:descent 522

19.528 svg:font-family 522

19.529 svg:font-size 522

19.530 svg:font-stretch 523

19.531 svg:font-style 523

19.532 svg:font-variant 523

19.533 svg:font-weight 523

19.534 svg:fx 523

19.535 svg:fy 523

19.536 svg:gradientTransform 524

19.537 svg:gradientUnits 524

19.538 svg:hanging 524

19.539 svg:height 524

19.539.1 <chart:chart> 524

19.539.2 <chart:plot-area> 524

19.539.3 <dr3d:scene> 525

19.539.4 <draw:area-polygon> 525

19.539.5 <draw:area-rectangle> 525

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

19.539.7 <draw:fill-image> 525

19.539.8 <draw:caption>, <draw:custom-shape>, <draw:circle>, <draw:control>, <draw:ellipse>, <draw:frame>, <draw:rect>, <draw:page-thumbnail>, <draw:path>, <draw:polygon>, <draw:polyline>, <draw:regular-polygon> 525

19.539.9 <office:annotation> 526

19.539.10 <presentation:placeholder> 526

19.540 svg:ideographic 526

19.541 svg:mathematical 526

19.542 svg:name 526

19.543 svg:offset 527

19.544 svg:origin 527

19.545 svg:overline-position 527

19.546 svg:overline-thickness 527

19.547 svg:panose-1 527

19.548 svg:path 527

19.549 svg:r 528

19.549.1 <draw:area-circle> 528

19.549.2 <draw:circle> 528

19.549.3 <svg:radialGradient> 528

19.550 svg:rx 528

19.551 svg:ry 529

19.552 svg:slope 529

19.553 svg:spreadMethod 529

19.554 svg:stemh 529

19.555 svg:stemv 529

19.556 svg:stop-color 529

19.557 svg:stop-opacity 530

19.558 svg:strikethrough-position 530

19.559 svg:strikethrough-thickness 530

19.560 svg:string 530

19.561 svg:type 530

19.562 svg:underline-position 530

19.563 svg:underline-thickness 531

19.564 svg:unicode-range 531

19.565 svg:units-per-em 531

19.566 svg:v-alphabetic 531

19.567 svg:v-hanging 531

19.568 svg:v-ideographic 531

19.569 svg:v-mathematical 532

19.570 svg:viewBox 532

19.571 svg:width 532

19.571.1 <chart:chart> 532

19.571.2 <chart:floor> 532

19.571.3 <chart:plot-area> 533

19.571.4 <chart:wall> 533

19.571.5 <dr3d:scene> 533

19.571.6 <draw:area-polygon> 533

19.571.7 <draw:area-rectangle> 533

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

19.571.9 <draw:fill-image> 533

19.571.10 <draw:caption>, <draw:custom-shape>, <draw:circle>, <draw:control>, <draw:ellipse>, <draw:frame>, <draw:rect>, <draw:page-thumbnail>, <draw:path>, <draw:polygon>, <draw:polyline>, <draw:regular-polygon> 534

19.571.11 <office:annotation> 534

19.571.12 <presentation:placeholder> 534

19.572 svg:widths 534

19.573 svg:x 535

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

19.573.2 <draw:area-polygon> 535

19.573.3 <draw:area-rectangle> 535

19.573.4 <dr3d:scene> 535

19.573.5 <draw:caption>, <draw:custom-shape>, <draw:circle>, <draw:control>, <draw:ellipse>, <draw:frame>, <draw:rect>, <draw:page-thumbnail>, <draw:path>, <draw:polygon>, <draw:polyline>, <draw:regular-polygon> 535

19.573.6 <draw:glue-point> 536

19.573.7 <office:annotation> 536

19.573.8 <presentation:placeholder> 536

19.574 svg:x1 536

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

19.574.2 <svg:linearGradient> 536

19.575 svg:x2 537

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

19.575.2 <svg:linearGradient> 537

19.576 svg:x-height 537

19.577 svg:y 537

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

19.577.2 <draw:area-polygon> 538

19.577.3 <draw:area-rectangle> 538

19.577.4 <dr3d:scene> 538

19.577.5 <draw:caption>, <draw:custom-shape>, <draw:circle>, <draw:control>, <draw:ellipse>, <draw:frame>, <draw:g>, <draw:rect>, <draw:page-thumbnail>, <draw:path>, <draw:polygon>, <draw:polyline>, <draw:regular-polygon> 538

19.577.6 <draw:glue-point> 538

19.577.7 <office:annotation> 539

19.577.8 <presentation:placeholder> 539

19.578 svg:y1 539

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

19.578.2 <svg:linearGradient> 539

19.579 svg:y2 539

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

19.579.2 <svg:linearGradient> 540

19.580 table:acceptance-state 540

19.581 table:algorithm 540

19.582 table:add-empty-lines 540

19.583 table:allow-empty-cell 541

19.584 table:application-data 541

19.585 table:automatic-find-labels 541

19.586 table:base-cell-address 542

19.587 table:bind-styles-to-content 542

19.588 table:border-color 542

19.589 table:buttons 542

19.590 table:case-sensitive 543

19.591 table:cell-address 543

19.592 table:cell-range 543

19.593 table:cell-range-address 543

19.593.1 General 543

19.593.2 <chart:categories> 544

19.593.3 <chart:domain> - bubble 544

19.593.4 <chart:domain>- scatter 544

19.593.5 <chart:domain> - surface 544

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

19.593.7 <table:highlighted-range> 545

19.593.8 <table:named-range> 545

19.593.9 <table:source-cell-range> 545

19.594 table:column 545

19.595 table:comment 546

19.596 table:condition 546

19.597 table:condition-source 547

19.598 table:condition-source-range-address 548

19.599 table:contains-error 548

19.600 table:contains-header 548

19.601 table:content-validation-name 548

19.602 table:copy-back 549

19.603 table:copy-formulas 549

19.604 table:copy-styles 549

19.605 table:count 550

19.606 table:country 550

19.607 table:data-field 550

19.608 table:data-cell-range-address 550

19.609 table:database-name 550

19.610 table:database-table-name 551

19.611 table:data-type 551

19.611.1 General 551

19.611.2 <table:filter-condition> 551

19.611.3 <table:sort-by> 551

19.611.4 <table:sort-groups> 552

19.612 table:date-end 552

19.613 table:date-start 552

19.614 table:date-value 553

19.615 table:default-cell-style-name 553

19.616 table:direction 553

19.617 table:display 553

19.618 table:display-border 554

19.619 table:display-duplicates 554

19.620 table:display-filter-buttons 555

19.621 table:display-list 555

19.622 table:display-member-mode 555

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

19.624 table:embedded-number-behavior 556

19.625 table:enabled 557

19.626 table:end 557

19.627 table:end-cell-address 558

19.628 table:end-column 558

19.629 table:end-position 558

19.630 table:end-row 558

19.631 table:end-table 559

19.632 table:end-x 559

19.633 table:end-y 559

19.634 table:execute 559

19.635 table:expression 560

19.636 table:field-name 560

19.637 table:field-number 560

19.638 table:filter-name 561

19.639 table:filter-options 561

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

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

19.642 table:formula 562

19.643 table:function 563

19.643.1 General 563

19.643.2 <table:consolidation> 563

19.643.3 <table:data-pilot-field> 563

19.643.4 <table:data-pilot-subtotal> 564

19.643.5 <table:subtotal-field> 564

19.644 table:grand-total 564

19.645 table:group-by-field-number 565

19.646 table:grouped-by 565

19.647 table:has-persistent-data 565

19.648 table:id 566

19.649 table:identify-categories 566

19.650 table:ignore-empty-rows 566

19.651 table:index 566

19.652 table:is-active 567

19.653 table:is-data-layout-field 567

19.654 table:is-selection 567

19.655 table:is-sub-table 567

19.656 table:label-cell-range-address 568

19.657 table:language 568

19.658 table:last-column-spanned 568

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

19.660 table:last-row-spanned 569

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

19.662 table:layout-mode 569

19.663 table:link-to-source-data 570

19.664 table:marked-invalid 570

19.665 table:matrix-covered 570

19.666 table:maximum-difference 571

19.667 table:member-count 571

19.668 table:member-name 571

19.669 table:member-type 571

19.670 table:message-type 572

19.671 table:mode 572

19.672 table:multi-deletion-spanned 572

19.673 table:name 573

19.673.1 General 573

19.673.2 <table:cell-range-source> 573

19.673.3 <table:content-validation> 573

19.673.4 <table:data-pilot-group> 573

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

19.673.6 <table:data-pilot-member> 573

19.673.7 <table:data-pilot-table> 574

19.673.8 <table:database-range> 574

19.673.9 <table:named-expression> 574

19.673.10 <table:named-range> 574

19.673.11 <table:operation> 574

19.673.12 <table:source-service> 575

19.673.13 <table:table> 575

19.673.14 <table:table-template> 575

19.674 table:null-year 575

19.675 table:number-columns-repeated 575

19.675.1 General 575

19.675.2 <table:covered-table-cell> 576

19.675.3 <table:table-cell> 576

19.675.4 <table:table-column> 576

19.676 table:number-columns-spanned 576

19.677 table:number-rows-repeated 577

19.678 table:number-rows-spanned 577

19.679 table:number-matrix-columns-spanned 577

19.680 table:number-matrix-rows-spanned 577

19.681 table:object-name 578

19.682 table:on-update-keep-size 578

19.683 table:on-update-keep-styles 578

19.684 table:operator 578

19.685 table:order 579

19.686 table:orientation 580

19.686.1 General 580

19.686.2 <table:data-pilot-field> 580

19.686.3 <table:database-range> 580

19.686.4 <table:label-range> 581

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

19.688 table:paragraph-style-name 581

19.689 table:parse-sql-statement 582

19.690 table:password 582

19.691 table:position 582

19.692 table:precision-as-shown 582

19.693 table:print 583

19.694 table:print-ranges 583

19.695 table:protect 583

19.696 table:protected 584

19.696.1 General 584

19.696.2 <table:covered-table-cell> 584

19.696.3 <table:scenario> 584

19.696.4 <table:table> 584

19.696.5 <table:table-cell> 585

19.697 table:protection-key 585

19.698 table:protection-key-digest-algorithm 585

19.699 table:query-name 586

19.700 table:range-usable-as 586

19.701 table:refresh-delay 586

19.702 table:rejecting-change-id 586

19.703 table:rfc-language-tag 587

19.704 table:row 587

19.705 table:scenario-ranges 587

19.706 table:script 587

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

19.708 table:selected-page 588

19.709 table:show-details 588

19.710 table:show-empty 589

19.711 table:show-filter-button 589

19.712 table:sort-mode 589

19.713 table:source-cell-range-addresses 589

19.714 table:source-field-name 590

19.715 table:source-name 590

19.716 table:sql-statement 590

19.717 table:start 590

19.718 table:start-column 591

19.719 table:start-position 591

19.720 table:start-row 591

19.721 table:start-table 591

19.722 table:status 591

19.723 table:step 592

19.724 table:steps 592

19.725 table:structure-protected 592

19.726 table:style-name 592

19.726.1 General 592

19.726.2 <table:background> 593

19.726.3 <table:body> 593

19.726.4 <table:covered-table-cell> 593

19.726.5 <table:even-columns> 593

19.726.6 <table:even-rows> 593

19.726.7 <table:first-column> 593

19.726.8 <table:first-row> 594

19.726.9 <table:last-column> 594

19.726.10 <table:last-row> 594

19.726.11 <table:odd-columns> 594

19.726.12 <table:odd-rows> 594

19.726.13 <table:table-cell> 594

19.726.14 <table:table-column> 595

19.726.15 <table:table-row> 595

19.726.16 <table:table> 595

19.727 table:table 595

19.728 table:table-background 595

19.729 table:table-name 596

19.730 table:target-cell-address 596

19.731 table:target-range-address 596

19.731.1 General 596

19.731.2 <table:data-pilot-table> 596

19.731.3 <table:database-range> 597

19.731.4 <table:filter> 597

19.731.5 <table:sort> 597

19.732 table:template-name 597

19.733 table:title 597

19.734 table:track-changes 597

19.735 table:type 598

19.735.1 General 598

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

19.735.3 <table:deletion> 599

19.735.4 <table:insertion> 599

19.736 table:use-banding-columns-styles 599

19.737 table:use-banding-rows-styles 600

19.738 table:use-first-column-styles 600

19.739 table:use-first-row-styles 600

19.740 table:use-last-column-styles 601

19.741 table:use-last-row-styles 601

19.742 table:use-labels 601

19.743 table:use-regular-expressions 602

19.744 table:use-wildcards 602

19.745 table:used-hierarchy 603

19.746 table:user-name 603

19.747 table:value 603

19.747.1 <table:filter-condition> 603

19.747.2 <table:filter-set-item> 603

19.748 table:value-type 604

19.749 table:visibility 604

19.750 text:active 604

19.751 text:address 604

19.752 text:alphabetical-separators 605

19.753 text:anchor-page-number 605

19.754 text:anchor-type 605

19.755 text:annote 606

19.756 text:author 607

19.757 text:bibliography-data-field 607

19.758 text:bibliography-type 608

19.759 text:booktitle 609

19.760 text:bullet-char 609

19.761 text:bullet-relative-size 610

19.762 text:capitalize-entries 610

19.763 text:c 611

19.764 text:caption-sequence-format 611

19.765 text:caption-sequence-name 611

19.766 text:change-id 611

19.767 text:chapter 612

19.768 text:citation-body-style-name 612

19.769 text:citation-style-name 612

19.770 text:class-names 612

19.770.1 General 612

19.770.2 <text:h> 612

19.770.3 <text:p> 613

19.770.4 <text:span> 613

19.771 text:column-name 613

19.772 text:combine-entries 613

19.773 text:combine-entries-with-dash 613

19.774 text:combine-entries-with-pp 614

19.775 text:comma-separated 614

19.776 text:cond-style-name 614

19.777 text:condition 615

19.777.1 General 615

19.777.2 <text:conditional-text> 615

19.777.3 <text:database-next> 615

19.777.4 <text:database-row-select> 615

19.777.5 <text:hidden-paragraph> 616

19.777.6 <text:hidden-text> 616

19.777.7 <text:section> 616

19.778 text:connection-name 616

19.779 text:consecutive-numbering 616

19.780 text:continue-list 617

19.781 text:continue-numbering 617

19.782 text:copy-outline-levels 617

19.783 text:count-empty-lines 617

19.784 text:count-in-text-boxes 618

19.785 text:current-value 618

19.786 text:custom1 618

19.787 text:custom2 618

19.788 text:custom3 619

19.789 text:custom4 619

19.790 text:custom5 619

19.791 text:database-name 619

19.792 text:date-adjust 619

19.793 text:date-value 620

19.794 text:default-style-name 620

19.795 text:description 620

19.796 text:display 620

19.796.1 General 620

19.796.2 <text:chapter> 620

19.796.3 <text:expression> 621

19.796.4 <text:file-name> 621

19.796.5 <text:index-entry-chapter> 621

19.796.6 <text:section> 622

19.796.7 <text:table-formula> 622

19.796.8 <text:template-name> 623

19.796.9 <text:user-field-get> 623

19.796.10 <text:variable-get> 623

19.796.11 <text:variable-input> 624

19.796.12 <text:variable-set> 624

19.797 text:display-levels 624

19.798 text:display-outline-level 624

19.799 text:duration 625

19.800 text:edition 625

19.801 text:editor 625

19.802 text:filter-name 625

19.803 text:fixed 625

19.804 text:footnotes-position 626

19.805 text:formula 626

19.806 text:global (deprecated) 626

19.807 text:howpublished 627

19.808 text:increment 627

19.809 text:id 627

19.809.1 General 627

19.809.2 <draw:text-box> 627

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

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

19.809.5 <text:changed-region> 628

19.809.6 <text:h> 628

19.809.7 <text:note> 629

19.809.8 <text:p> 629

19.809.9 <text:toc-mark-end> 629

19.809.10 <text:toc-mark-start> 630

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

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

19.810 text:identifier 630

19.811 text:index-name 630

19.812 text:index-scope 631

19.813 text:ignore-case 631

19.814 text:institution 631

19.815 text:is-hidden 632

19.816 text:is-list-header 632

19.817 text:isbn 632

19.818 text:issn 632

19.819 text:journal 632

19.820 text:key 633

19.821 text:key1 634

19.822 text:key2 634

19.823 text:key1-phonetic 634

19.824 text:key2-phonetic 635

19.825 text:kind 635

19.826 text:label 635

19.827 text:label-followed-by 635

19.828 text:level 636

19.829 text:list-id 636

19.830 text:list-tab-stop-position 636

19.831 text:main-entry 637

19.832 text:main-entry-style-name 637

19.833 text:master-page-name 637

19.834 text:month 638

19.835 text:name 638

19.835.1 General 638

19.835.2 <text:alphabetical-index> 638

19.835.3 <text:bibliography> 638

19.835.4 <text:bookmark> 638

19.835.5 <text:bookmark-end> 638

19.835.6 <text:bookmark-start> 639

19.835.7 <text:execute-macro> 639

19.835.8 <text:illustration-index> 639

19.835.9 <text:index-title> 639

19.835.10 <text:object-index> 639

19.835.11 <text:reference-mark> 639

19.835.12 <text:reference-mark-end> 640

19.835.13 <text:reference-mark-start> 640

19.835.14 <text:section> 640

19.835.15 <text:sequence> 640

19.835.16 <text:sequence-decl> 640

19.835.17 <text:table-of-content> 640

19.835.18 <text:table-index> 641

19.835.19 <text:user-defined> 641

19.835.20 <text:user-field-decl> 641

19.835.21 <text:user-field-get> 641

19.835.22 <text:user-field-input> 641

19.835.23 <text:user-index> 641

19.835.24 <text:variable-set> 642

19.835.25 <text:variable-decl> 642

19.835.26 <text:variable-get> 642

19.835.27 <text:variable-input> 642

19.836 text:note 642

19.837 text:note-class 642

19.838 text:number 643

19.839 text:number-lines 643

19.840 text:number-position 643

19.841 text:numbered-entries 644

19.842 text:offset 644

19.843 text:organizations 644

19.844 text:outline-level 644

19.844.1 General 644

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

19.844.3 <text:chapter> 645

19.844.4 <text:h> 645

19.844.5 <text:index-entry-chapter> 645

19.844.6 <text:index-source-styles> 645

19.844.7 <text:user-index-mark> 645

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

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

19.844.10 <text:toc-mark> 646

19.844.11 <text:toc-mark-start> 646

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

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

19.845 text:page-adjust 647

19.845.1 General 647

19.845.2 <text:page-number> 647

19.845.3 <text:page-variable-set> 647

19.846 text:pages 647

19.847 text:placeholder-type 647

19.848 text:prefix 648

19.849 text:protected 648

19.850 text:protection-key 648

19.851 text:protection-key-digest-algorithm 649

19.852 text:publisher 649

19.853 text:ref-name 649

19.853.1 General 649

19.853.2 <text:bookmark-ref> 649

19.853.3 <text:note-ref> 650

19.853.4 <text:reference-ref> 650

19.853.5 <text:sequence> 650

19.853.6 <text:sequence-ref> 650

19.854 text:reference-format 650

19.855 text:relative-tab-stop-position 652

19.856 text:report-type 652

19.857 text:restart-numbering 652

19.858 text:restart-on-page 653

19.859 text:row-number 653

19.860 text:school 653

19.861 text:section-name 653

19.862 text:series 654

19.863 text:select-page 654

19.863.1 General 654

19.863.2 <text:page-continuation> 654

19.863.3 <text:page-number> 654

19.864 text:separation-character 655

19.865 text:sort-algorithm 655

19.866 text:sort-ascending 655

19.867 text:sort-by-position 655

19.868 text:start-value 656

19.868.1 General 656

19.868.2 <text:h> 656

19.868.3 <text:list-item> 656

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

19.868.5 <text:notes-configuration> 656

19.868.6 <text:numbered-paragraph> 657

19.868.7 <text:outline-level-style> 657

19.869 text:start-numbering-at 657

19.870 text:string-value-phonetic 657

19.871 text:string-value 657

19.871.1 General 657

19.871.2 <text:alphabetical-index-mark> 658

19.871.3 <text:hidden-text> 658

19.871.4 <text:page-continuation> 658

19.871.5 <text:toc-mark> 658

19.871.6 <text:user-index-mark> 658

19.872 text:string-value-if-false 658

19.873 text:string-value-if-true 659

19.874 text:style-name 659

19.874.1 General 659

19.874.2 <text:a> 659

19.874.3 <text:alphabetical-index> 659

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

19.874.5 <text:bibliography> 659

19.874.6 <text:bibliography-entry-template> 660

19.874.7 <text:h> 660

19.874.8 <text:illustration-index> 660

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

19.874.10 <text:index-entry-bibliography> 660

19.874.11 <text:index-entry-chapter> 661

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

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

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

19.874.15 <text:index-entry-span> 661

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

19.874.17 <text:index-entry-text> 662

19.874.18 <text:index-source-style> 662

19.874.19 <text:index-title> 662

19.874.20 <text:index-title-template> 662

19.874.21 <text:linenumbering-configuration> 662

19.874.22 <text:list> 662

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

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

19.874.25 <text:numbered-paragraph> 663

19.874.26 <text:object-index> 663

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

19.874.28 <text:outline-level-style> 664

19.874.29 <text:p> 664

19.874.30 <text:ruby> 664

19.874.31 <text:ruby-text> 664

19.874.32 <text:section> 665

19.874.33 <text:span> 665

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

19.874.35 <text:table-of-content> 665

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

19.874.37 <text:table-index> 665

19.874.38 <text:user-index> 666

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

19.875 text:style-override 666

19.876 text:suffix 666

19.877 text:tab-ref 666

19.878 text:table-name 667

19.879 text:table-type 667

19.880 text:time-adjust 667

19.881 text:time-value 667

19.882 text:title 667

19.883 text:track-changes 668

19.884 text:url 668

19.885 text:use-caption 668

19.886 text:use-chart-objects 668

19.887 text:use-draw-objects 669

19.888 text:use-floating-frames 669

19.889 text:use-graphics 669

19.890 text:use-index-marks 670

19.891 text:use-index-source-styles 670

19.892 text:use-keys-as-entries 670

19.893 text:use-math-objects 671

19.894 text:use-objects 671

19.895 text:use-other-objects 671

19.896 text:use-outline-level 672

19.897 text:use-soft-page-breaks 672

19.898 text:use-spreadsheet-objects 673

19.899 text:use-tables 673

19.900 text:value 674

19.901 text:visited-style-name 674

19.902 text:volume 674

19.903 text:year 674

19.904 xforms:bind 674

19.905 xhtml:about 675

19.906 xhtml:content 675

19.907 xhtml:datatype 675

19.908 xhtml:property 676

19.909 xlink:actuate 676

19.910 xlink:href 677

19.910.1 General 677

19.910.2 <anim:audio> 677

19.910.3 <chart:chart> 677

19.910.4 <chart:symbol-image> 677

19.910.5 <db:component> 677

19.910.6 <db:connection-resource> 678

19.910.7 <db:file-based-database> 678

19.910.8 <draw:a> 678

19.910.9 <draw:applet> 678

19.910.10 <draw:area-circle> 678

19.910.11 <draw:area-polygon> 678

19.910.12 <draw:area-rectangle> 679

19.910.13 <draw:fill-image> 679

19.910.14 <draw:floating-frame> 679

19.910.15 <draw:image> 679

19.910.16 <draw:object> 679

19.910.17 <draw:object-ole> 679

19.910.18 <draw:plugin> 680

19.910.19 <form:button> 680

19.910.20 <form:connection-resource> 680

19.910.21 <form:image> 680

19.910.22 <form:form> 680

19.910.23 <meta:auto-reload> 680

19.910.24 <meta:template> 680

19.910.25 <presentation:event-listener> 681

19.910.26 <presentation:sound> 681

19.910.27 <script:event-listener> 681

19.910.28 <style:background-image> 681

19.910.29 <svg:definition-src> 681

19.910.30 <svg:font-face-uri> 681

19.910.31 <table:cell-range-source> 682

19.910.32 <table:table-source> 682

19.910.33 <text:a> 682

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

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

19.910.36 <text:script> 682

19.910.37 <text:section-source> 683

19.911 xlink:show 683

19.912 xlink:title 683

19.913 xlink:type 684

19.914 xml:id 684

20 Formatting Attributes 686

20.1 General 686

20.2 chart:angle-offset 686

20.3 chart:auto-position 686

20.4 chart:auto-size 686

20.5 chart:axis-label-position 687

20.6 chart:axis-position 687

20.7 chart:connect-bars 688

20.8 chart:data-label-number 688

20.9 chart:data-label-symbol 689

20.10 chart:data-label-text 689

20.11 chart:deep 689

20.12 chart:display-label 690

20.13 chart:error-category 690

20.14 chart:error-lower-indicator 691

20.15 chart:error-lower-limit 691

20.16 chart:error-lower-range 691

20.17 chart:error-margin 691

20.18 chart:error-percentage 692

20.19 chart:error-upper-indicator 692

20.20 chart:error-upper-limit 692

20.21 chart:error-upper-range 692

20.22 chart:gap-width 693

20.23 chart:group-bars-per-axis 693

20.24 chart:hole-size 693

20.25 chart:include-hidden-cells 694

20.26 chart:interpolation 694

20.27 chart:interval-major 696

20.28 chart:interval-minor-divisor 696

20.29 chart:japanese-candle-stick 697

20.30 chart:label-arrangement 697

20.31 chart:label-position 697

20.32 chart:label-position-negative 698

20.33 chart:lines (deprecated) 699

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

20.35 chart:logarithmic 700

20.36 chart:maximum 700

20.37 chart:mean-value 700

20.38 chart:minimum 701

20.39 chart:origin 701

20.40 chart:overlap 701

20.41 chart:pie-offset 702

20.42 chart:percentage 702

20.43 chart:regression-type 702

20.44 chart:reverse-direction 703

20.45 chart:right-angled-axes 703

20.46 chart:scale-text 704

20.47 chart:series-source (deprecated) 704

20.48 chart:sort-by-x-values 704

20.49 chart:solid-type 705

20.50 chart:spline-order 705

20.51 chart:spline-resolution 705

20.52 chart:stacked 706

20.53 chart:symbol-height 706

20.54 chart:symbol-name 706

20.55 chart:symbol-type 706

20.56 chart:symbol-width 707

20.57 chart:text-overlap 707

20.58 chart:three-dimensional 707

20.59 chart:tick-marks-major-inner 708

20.60 chart:tick-marks-major-outer 708

20.61 chart:tick-marks-minor-inner 709

20.62 chart:tick-marks-minor-outer 709

20.63 chart:tick-mark-position 709

20.64 chart:treat-empty-cells 710

20.65 chart:vertical 710

20.66 chart:visible 711

20.67 dr3d:ambient-color 711

20.68 dr3d:back-scale 711

20.69 dr3d:backface-culling 711

20.70 dr3d:close-back 712

20.71 dr3d:close-front 712

20.72 dr3d:depth 712

20.73 dr3d:diffuse-color 712

20.74 dr3d:edge-rounding 712

20.75 dr3d:edge-rounding-mode 713

20.76 dr3d:emissive-color 713

20.77 dr3d:end-angle 713

20.78 dr3d:horizontal-segments 714

20.79 dr3d:lighting-mode 714

20.80 dr3d:normals-direction 714

20.81 dr3d:normals-kind 714

20.82 dr3d:shadow 715

20.83 dr3d:shininess 715

20.84 dr3d:specular-color 715

20.85 dr3d:texture-filter 715

20.86 dr3d:texture-kind 716

20.87 dr3d:texture-mode 716

20.88 dr3d:texture-generation-mode-x 716

20.89 dr3d:texture-generation-mode-y 717

20.90 dr3d:vertical-segments 717

20.91 draw:auto-grow-height 717

20.92 draw:auto-grow-width 718

20.93 draw:background-size 718

20.94 draw:blue 718

20.95 draw:caption-angle 719

20.96 draw:caption-angle-type 719

20.97 draw:caption-escape 719

20.98 draw:caption-escape-direction 719

20.99 draw:caption-fit-line-length 720

20.100 draw:caption-gap 720

20.101 draw:caption-line-length 720

20.102 draw:caption-type 720

20.103 draw:color-inversion 721

20.104 draw:color-mode 721

20.105 draw:contrast 721

20.106 draw:decimal-places 722

20.107 draw:draw-aspect 722

20.108 draw:end-guide 722

20.109 draw:end-line-spacing-horizontal 722

20.110 draw:end-line-spacing-vertical 723

20.111 draw:fill 723

20.112 draw:fill-color 723

20.113 draw:fill-gradient-name 723

20.114 draw:fill-hatch-name 724

20.115 draw:fill-hatch-solid 724

20.116 draw:fill-image-height 724

20.117 draw:fill-image-name 724

20.118 draw:fill-image-ref-point 725

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

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

20.121 draw:fill-image-width 726

20.122 draw:fit-to-contour 726

20.123 draw:fit-to-size 726

20.124 draw:frame-display-border 727

20.125 draw:frame-margin-horizontal 727

20.126 draw:frame-display-scrollbar 727

20.127 draw:frame-margin-vertical 727

20.128 draw:gamma 728

20.129 draw:green 728

20.130 draw:gradient-step-count 728

20.131 draw:guide-distance 728

20.132 draw:guide-overhang 729

20.133 draw:image-opacity 729

20.134 draw:line-distance 729

20.135 draw:luminance 729

20.136 draw:marker-end 729

20.137 draw:marker-end-center 729

20.138 draw:marker-end-width 730

20.139 draw:marker-start 730

20.140 draw:marker-start-center 730

20.141 draw:marker-start-width 730

20.142 draw:measure-align 731

20.143 draw:measure-vertical-align 731

20.144 draw:ole-draw-aspect 731

20.145 draw:opacity 732

20.146 draw:opacity-name 732

20.147 draw:parallel 732

20.148 draw:placing 732

20.149 draw:red 733

20.150 draw:secondary-fill-color 733

20.151 draw:shadow 733

20.152 draw:shadow-color 733

20.153 draw:shadow-offset-x 734

20.154 draw:shadow-offset-y 734

20.155 draw:shadow-opacity 734

20.156 draw:show-unit 734

20.157 draw:start-guide 734

20.158 draw:start-line-spacing-horizontal 735

20.159 draw:start-line-spacing-vertical 735

20.160 draw:stroke 735

20.161 draw:stroke-dash 735

20.162 draw:stroke-dash-names 736

20.163 draw:stroke-linejoin 736

20.164 svg:stroke-linecap 736

20.165 draw:symbol-color 737

20.166 draw:textarea-horizontal-align 737

20.167 draw:textarea-vertical-align 737

20.168 draw:tile-repeat-offset 737

20.169 draw:visible-area-height 738

20.170 draw:visible-area-left 738

20.171 draw:visible-area-top 738

20.172 draw:visible-area-width 739

20.173 draw:unit 739

20.174 draw:wrap-influence-on-position 740

20.175 fo:background-color 741

20.176 fo Border Properties 742

20.176.1 General 742

20.176.2 fo:border 742

20.176.3 fo:border-bottom 742

20.176.4 fo:border-left 742

20.176.5 fo:border-right 742

20.176.6 fo:border-top 743

20.177 fo:break-after 743

20.178 fo:break-before 743

20.179 fo:clip 743

20.180 fo:color 744

20.181 fo:country 744

20.182 fo:font-family 744

20.183 fo:font-size 744

20.184 fo:font-style 745

20.185 fo:font-variant 745

20.186 fo:font-weight 745

20.187 fo:height 746

20.188 fo:hyphenate 746

20.189 fo:hyphenation-keep 746

20.190 fo:hyphenation-ladder-count 746

20.191 fo:hyphenation-push-char-count 747

20.192 fo:hyphenation-remain-char-count 747

20.193 fo:keep-together 747

20.194 fo:keep-with-next 747

20.195 fo:language 747

20.196 fo:letter-spacing 748

20.197 fo:line-height 748

20.198 fo:margin 748

20.199 fo:margin-bottom 749

20.200 fo:margin-left 749

20.201 fo:margin-right 749

20.202 fo:margin-top 750

20.203 fo:max-height 750

20.204 fo:max-width 750

20.205 fo:min-height 750

20.205.1 <style:graphic-properties> 750

20.205.2 <style:header-footer-properties> 751

20.206 fo:min-width 751

20.207 fo:orphans 751

20.208 fo:page-height 751

20.209 fo:page-width 751

20.210 fo:padding 751

20.211 fo:padding-bottom 752

20.212 fo:padding-left 752

20.213 fo:padding-right 752

20.214 fo:padding-top 752

20.215 fo:script 753

20.216 fo:text-align 753

20.216.1 <style:paragraph-properties> 753

20.216.2 <style:list-level-properties> 753

20.217 fo:text-align-last 754

20.218 fo:text-indent 754

20.219 fo:text-shadow 754

20.220 fo:text-transform 755

20.221 fo:widows 755

20.222 fo:width 755

20.223 fo:wrap-option 755

20.224 presentation:background-objects-visible 756

20.225 presentation:background-visible 756

20.226 presentation:display-date-time 756

20.227 presentation:display-footer 757

20.228 presentation:display-header 757

20.229 presentation:display-page-number 757

20.230 presentation:duration 758

20.231 presentation:transition-speed 758

20.232 presentation:transition-style 758

20.233 presentation:transition-type 761

20.234 presentation:visibility 762

20.235 smil:direction 762

20.236 smil:fadeColor 762

20.237 smil:subtype 762

20.238 smil:type 763

20.239 style:auto-text-indent 763

20.240 style:background-transparency 763

20.241 style:border-line-width 763

20.242 style:border-line-width-bottom 764

20.243 style:border-line-width-left 764

20.244 style:border-line-width-right 765

20.245 style:border-line-width-top 765

20.246 style:cell-protect 765

20.247 style:column-width 766

20.248 style:country-asian 766

20.249 style:country-complex 766

20.250 style:decimal-places 766

20.251 style:diagonal-bl-tr 767

20.252 style:diagonal-bl-tr-widths 767

20.253 style:diagonal-tl-br 767

20.254 style:diagonal-tl-br-widths 767

20.255 style:direction 767

20.256 style:dynamic-spacing 768

20.257 style:editable 768

20.258 style:first-page-number 768

20.259 style:flow-with-text 769

20.260 style:font-charset 770

20.261 style:font-charset-asian 770

20.262 style:font-charset-complex 771

20.263 style:font-family-asian 771

20.264 style:font-family-complex 771

20.265 style:font-family-generic 772

20.266 style:font-family-generic-asian 772

20.267 style:font-family-generic-complex 773

20.268 style:font-independent-line-spacing 773

20.269 style:font-name 774

20.270 style:font-name-asian 774

20.271 style:font-name-complex 774

20.272 style:font-pitch 774

20.273 style:font-pitch-asian 775

20.274 style:font-pitch-complex 775

20.275 style:font-relief 775

20.276 style:font-size-asian 776

20.277 style:font-size-complex 776

20.278 style:font-size-rel 776

20.279 style:font-size-rel-asian 777

20.280 style:font-size-rel-complex 777

20.281 style:font-style-asian 777

20.282 style:font-style-complex 778

20.283 style:font-style-name 778

20.284 style:font-style-name-asian 778

20.285 style:font-style-name-complex 779

20.286 style:font-weight-asian 779

20.287 style:font-weight-complex 779

20.288 style:footnote-max-height 779

20.289 style:glyph-orientation-vertical 780

20.290 style:horizontal-pos 780

20.291 style:horizontal-rel 782

20.292 style:join-border 782

20.293 style:justify-single-word 783

20.294 style:language-asian 784

20.295 style:language-complex 784

20.296 style:layout-grid-base-height 784

20.297 style:layout-grid-base-width 784

20.298 style:layout-grid-color 785

20.299 style:layout-grid-display 785

20.300 style:layout-grid-lines 785

20.301 style:layout-grid-mode 785

20.302 style:layout-grid-print 786

20.303 style:layout-grid-ruby-below 786

20.304 style:layout-grid-ruby-height 786

20.305 style:layout-grid-snap-to 786

20.306 style:layout-grid-standard-mode 787

20.307 style:line-break 787

20.308 style:letter-kerning 787

20.309 style:line-height-at-least 788

20.310 style:line-spacing 788

20.311 style:may-break-between-rows 788

20.312 style:min-row-height 788

20.313 style:mirror 789

20.314 style:num-format 789

20.315 style:num-letter-sync 790

20.316 style:num-prefix 790

20.317 style:num-suffix 790

20.318 style:number-wrapped-paragraphs 791

20.319 style:overflow-behavior 791

20.320 style:page-number 791

20.321 style:paper-tray-name 792

20.322 style:print 792

20.323 style:print-content 793

20.323.1 General 793

20.323.2 <style:graphic-properties> 793

20.323.3 <style:table-cell-properties> 793

20.324 style:print-page-order 793

20.325 style:print-orientation 793

20.326 style:protect 794

20.326.1 General 794

20.326.2 <style:graphic-properties> 794

20.326.3 <style:section-properties> 794

20.327 style:punctuation-wrap 795

20.328 style:register-true 795

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

20.330 style:rel-column-width 795

20.331 style:rel-height 796

20.332 style:rel-width 796

20.332.1 <style:graphic-properties> 796

20.332.2 <style:table-properties> 797

20.333 style:repeat 797

20.334 style:repeat-content 797

20.335 style:rfc-language-tag 797

20.336 style:rfc-language-tag-asian 798

20.337 style:rfc-language-tag-complex 798

20.338 style:rotation-align 799

20.339 style:rotation-angle 799

20.340 style:row-height 799

20.341 style:ruby-align 800

20.342 style:ruby-position 800

20.343 style:run-through 800

20.344 style:scale-to 801

20.345 style:scale-to-pages 801

20.346 style:script-asian 801

20.347 style:script-complex 801

20.348 style:script-type 802

20.349 style:shadow 803

20.350 style:shrink-to-fit 803

20.351 style:snap-to-layout-grid 803

20.352 style:tab-stop-distance 804

20.353 style:table-centering 804

20.354 style:text-align-source 804

20.355 style:text-autospace 805

20.356 style:text-blinking 805

20.357 style:text-combine 805

20.358 style:text-combine-start-char 806

20.359 style:text-combine-end-char 806

20.360 style:text-emphasize 806

20.361 style:text-line-through-color 806

20.362 style:text-line-through-mode 807

20.363 style:text-line-through-style 807

20.364 style:text-line-through-text 808

20.365 style:text-line-through-text-style 808

20.366 style:text-line-through-type 808

20.367 style:text-line-through-width 809

20.368 style:text-outline 809

20.369 style:text-overline-color 809

20.370 style:text-overline-mode 810

20.371 style:text-overline-style 810

20.372 style:text-overline-type 811

20.373 style:text-overline-width 811

20.374 style:text-position 812

20.375 style:text-rotation-angle 812

20.376 style:text-rotation-scale 812

20.377 style:text-scale 812

20.378 style:text-underline-color 813

20.379 style:text-underline-mode 813

20.380 style:text-underline-style 813

20.381 style:text-underline-type 814

20.382 style:text-underline-width 814

20.383 style:use-optimal-column-width 815

20.384 style:use-optimal-row-height 815

20.385 style:use-window-font-color 815

20.386 style:vertical-align 816

20.386.1 <style:paragraph-properties> 816

20.386.2 <style:table-cell-properties> 816

20.387 style:vertical-pos 816

20.388 style:vertical-rel 817

20.389 style:width 818

20.390 style:wrap 818

20.391 style:wrap-contour 819

20.392 style:wrap-contour-mode 819

20.393 style:wrap-dynamic-threshold 819

20.394 style:writing-mode 820

20.394.1 General 820

20.394.2 <style:graphic-properties> 820

20.394.3 <style:page-layout-properties> 820

20.394.4 <style:paragraph-properties> 820

20.394.5 <style:section-properties> 820

20.394.6 <style:table-cell-properties> 821

20.394.7 <style:table-properties> 821

20.395 style:writing-mode-automatic 821

20.396 svg:fill-rule 821

20.397 svg:height 822

20.397.1 <style:graphic-properties> 822

20.397.2 <style:header-footer-properties> 822

20.398 svg:stroke-color 822

20.399 svg:stroke-opacity 822

20.400 svg:stroke-width 822

20.401 svg:x 823

20.402 svg:y 823

20.402.1 <style:graphic-properties> 823

20.402.2 <style:list-level-properties> 823

20.403 svg:width 823

20.404 table:align 823

20.405 table:border-model 824

20.406 table:display 824

20.407 text:anchor-page-number 824

20.408 text:anchor-type 825

20.409 text:animation 826

20.410 text:animation-delay 826

20.411 text:animation-direction 826

20.412 text:animation-repeat 827

20.413 text:animation-start-inside 827

20.414 text:animation-steps 827

20.415 text:animation-stop-inside 827

20.416 text:condition 828

20.417 text:display 828

20.418 text:dont-balance-text-columns 828

20.419 text:line-break 828

20.420 text:line-number 829

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

20.422 text:min-label-distance 829

20.423 text:min-label-width 830

20.424 text:number-lines 830

20.425 text:space-before 830

Appendix A. OpenDocument Relax NG Schema 832

Appendix B. OpenDocument Metadata Manifest Ontology 833

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

Appendix D. Accessibility Guidelines (Non Normative) 836

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

D.1.1. Guidance for authors 836

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

D.2. Hyperlink Titles 837

D.3. Tables in Presentations 837

D.4. Further Guidelines 837

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

E.1. Paragraph and Layout Direction 838

E.2. Numeric Digits Presentation and Calendars 839

Appendix F. Recommended Usage of SMIL 840

F.1. Slide Animation 840

F.2. Main Sequence 840

F.3. Interactive Sequence 841

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

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

Table of Contents Part 2

1 Introduction 19

1.1 Introduction 19

1.2 Terminology 19

1.3 Purpose 19

1.4 Normative References 19

1.5 Non-Normative References 20

2 Expressions and Evaluators 21

2.1 Introduction 21

2.2 OpenDocument Formula Expression 21

2.3 Evaluators 21

2.3.1 OpenDocument Formula Evaluator 21

2.3.2 OpenDocument Formula Small Group Evaluator 21

2.3.3 OpenDocument Formula Medium Group Evaluator 22

2.3.4 OpenDocument Formula Large Group Evaluator 23

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

3 Formula Processing Model 25

3.1 General 25

3.2 Expression Evaluation 25

3.2.1 General 25

3.2.2 Expression Calculation 25

3.2.3 Operator and Function Evaluation 25

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

3.4 Host-Defined Behaviors 28

3.5 When recalculation occurs 29

3.6 Numerical Models 29

3.7 Basic Limits 29

4 Types 31

4.1 General 31

4.2 Text (String) 31

4.3 Number 31

4.3.1 General 31

4.3.2 Time 32

4.3.3 Date 32

4.3.4 DateTime 32

4.3.5 Percentage 32

4.3.6 Currency 32

4.3.7 Logical (Number) 32

4.4 Complex Number 33

4.5 Logical (Boolean) 33

4.6 Error 33

4.7 Empty Cell 34

4.8 Reference 34

4.9 ReferenceList 34

4.10 Array 34

4.11 Pseudotypes 34

4.11.1 General 34

4.11.2 Scalar 35

4.11.3 DateParam 35

4.11.4 TimeParam 35

4.11.5 Integer 35

4.11.6 TextOrNumber 35

4.11.7 Basis 35

4.11.8 Criterion 37

4.11.9 Database 38

4.11.10 Field 38

4.11.11 Criteria 38

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

4.11.13 Any 39

5 Expression Syntax 40

5.1 General 40

5.2 Basic Expressions 40

5.3 Constant Numbers 41

5.4 Constant Strings 41

5.5 Operators 41

5.6 Functions and Function Parameters 42

5.7 Nonstandard Function Names 43

5.8 References 43

5.9 Reference List 44

5.10 Quoted Label 45

5.10.1 General 45

5.10.2 Lookup of Defined Labels 45

5.10.3 Automatic Lookup of Labels 45

5.10.4 Implicit Intersection 46

5.10.5 Automatic Range 46

5.10.6 Automatic Intersection 47

5.11 Named Expressions 47

5.12 Constant Errors 48

5.13 Inline Arrays 49

5.14 Whitespace 49

6 Standard Operators and Functions 50

6.1 General 50

6.2 Common Template for Functions and Operators 50

6.3 Implicit Conversion Operators 51

6.3.1 General 51

6.3.2 Conversion to Scalar 51

6.3.3 Implied intersection 51

6.3.4 Force to array context (ForceArray) 51

6.3.5 Conversion to Number 52

6.3.6 Conversion to Integer 52

6.3.7 Conversion to NumberSequence 52

6.3.8 Conversion to NumberSequenceList 53

6.3.9 Conversion to DateSequence 53

6.3.10 Conversion to Complex Number 53

6.3.11 Conversion to ComplexSequence 53

6.3.12 Conversion to Logical 53

6.3.13 Conversion to LogicalSequence 54

6.3.14 Conversion to Text 54

6.3.15 Conversion to DateParam 54

6.3.16 Conversion to TimeParam 54

6.4 Standard Operators 55

6.4.1 General 55

6.4.2 Infix Operator "+" 55

6.4.3 Infix Operator "-" 55

6.4.4 Infix Operator "*" 55

6.4.5 Infix Operator "/" 56

6.4.6 Infix Operator "^" 56

6.4.7 Infix Operator "=" 56

6.4.8 Infix Operator "<>" 56

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

6.4.10 Infix Operator "&" 57

6.4.11 Infix Operator Reference Range (":") 57

6.4.12 Infix Operator Reference Intersection ("!") 58

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

6.4.14 Postfix Operator "%" 59

6.4.15 Prefix Operator "+" 59

6.4.16 Prefix Operator "-" 59

6.5 Matrix Functions 60

6.5.1 General 60

6.5.2 MDETERM 60

6.5.3 MINVERSE 60

6.5.4 MMULT 61

6.5.5 MUNIT 61

6.5.6 TRANSPOSE 61

6.6 Bit operation functions 62

6.6.1 General 62

6.6.2 BITAND 62

6.6.3 BITLSHIFT 62

6.6.4 BITOR 62

6.6.5 BITRSHIFT 63

6.6.6 BITXOR 63

6.7 Byte-position text functions 63

6.7.1 General 63

6.7.2 FINDB 63

6.7.3 LEFTB 64

6.7.4 LENB 64

6.7.5 MIDB 64

6.7.6 REPLACEB 64

6.7.7 RIGHTB 65

6.7.8 SEARCHB 65

6.8 Complex Number Functions 65

6.8.1 General 65

6.8.2 COMPLEX 65

6.8.3 IMABS 65

6.8.4 IMAGINARY 66

6.8.5 IMARGUMENT 66

6.8.6 IMCONJUGATE 66

6.8.7 IMCOS 66

6.8.8 IMCOSH 66

6.8.9 IMCOT 67

6.8.10 IMCSC 67

6.8.11 IMCSCH 67

6.8.12 IMDIV 67

6.8.13 IMEXP 68

6.8.14 IMLN 68

6.8.15 IMLOG10 68

6.8.16 IMLOG2 68

6.8.17 IMPOWER 69

6.8.18 IMPRODUCT 69

6.8.19 IMREAL 69

6.8.20 IMSIN 69

6.8.21 IMSINH 70

6.8.22 IMSEC 70

6.8.23 IMSECH 70

6.8.24 IMSQRT 70

6.8.25 IMSUB 71

6.8.26 IMSUM 71

6.8.27 IMTAN 71

6.9 Database Functions 71

6.9.1 General 71

6.9.2 DAVERAGE 72

6.9.3 DCOUNT 72

6.9.4 DCOUNTA 72

6.9.5 DGET 72

6.9.6 DMAX 73

6.9.7 DMIN 73

6.9.8 DPRODUCT 73

6.9.9 DSTDEV 73

6.9.10 DSTDEVP 74

6.9.11 DSUM 74

6.9.12 DVAR 74

6.9.13 DVARP 74

6.10 Date and Time Functions 75

6.10.1 General 75

6.10.2 DATE 75

6.10.3 DATEDIF 75

6.10.4 DATEVALUE 76

6.10.5 DAY 76

6.10.6 DAYS 76

6.10.7 DAYS360 76

6.10.8 EDATE 77

6.10.9 EOMONTH 78

6.10.10 HOUR 78

6.10.11 ISOWEEKNUM 78

6.10.12 MINUTE 78

6.10.13 MONTH 79

6.10.14 NETWORKDAYS 79

6.10.15 NOW 79

6.10.16 SECOND 80

6.10.17 TIME 80

6.10.18 TIMEVALUE 80

6.10.19 TODAY 81

6.10.20 WEEKDAY 81

6.10.21 WEEKNUM 82

6.10.22 WORKDAY 82

6.10.23 YEAR 82

6.10.24 YEARFRAC 83

6.11 External Access Functions 83

6.11.1 General 83

6.11.2 DDE 83

6.11.3 HYPERLINK 84

6.12 Financial Functions 84

6.12.1 General 84

6.12.2 ACCRINT 84

6.12.3 ACCRINTM 85

6.12.4 AMORLINC 86

6.12.5 COUPDAYBS 86

6.12.6 COUPDAYS 87

6.12.7 COUPDAYSNC 88

6.12.8 COUPNCD 88

6.12.9 COUPNUM 89

6.12.10 COUPPCD 89

6.12.11 CUMIPMT 90

6.12.12 CUMPRINC 90

6.12.13 DB 91

6.12.14 DDB 92

6.12.15 DISC 93

6.12.16 DOLLARDE 94

6.12.17 DOLLARFR 94

6.12.18 DURATION 94

6.12.19 EFFECT 95

6.12.20 FV 95

6.12.21 FVSCHEDULE 96

6.12.22 INTRATE 96

6.12.23 IPMT 96

6.12.24 IRR 97

6.12.25 ISPMT 97

6.12.26 MDURATION 98

6.12.27 MIRR 98

6.12.28 NOMINAL 99

6.12.29 NPER 99

6.12.30 NPV 100

6.12.31 ODDFPRICE 100

6.12.32 ODDFYIELD 101

6.12.33 ODDLPRICE 101

6.12.34 ODDLYIELD 102

6.12.35 PDURATION 102

6.12.36 PMT 103

6.12.37 PPMT 103

6.12.38 PRICE 104

6.12.39 PRICEDISC 104

6.12.40 PRICEMAT 105

6.12.41 PV 105

6.12.42 RATE 106

6.12.43 RECEIVED 107

6.12.44 RRI 107

6.12.45 SLN 107

6.12.46 SYD 108

6.12.47 TBILLEQ 108

6.12.48 TBILLPRICE 109

6.12.49 TBILLYIELD 109

6.12.50 VDB 109

6.12.51 XIRR 110

6.12.52 XNPV 111

6.12.53 YIELD 111

6.12.54 YIELDDISC 112

6.12.55 YIELDMAT 112

6.13 Information Functions 113

6.13.1 General 113

6.13.2 AREAS 113

6.13.3 CELL 113

6.13.4 COLUMN 115

6.13.5 COLUMNS 115

6.13.6 COUNT 116

6.13.7 COUNTA 116

6.13.8 COUNTBLANK 116

6.13.9 COUNTIF 117

6.13.10 COUNTIFS 117

6.13.11 ERROR.TYPE 117

6.13.12 FORMULA 118

6.13.13 INFO 118

6.13.14 ISBLANK 119

6.13.15 ISERR 119

6.13.16 ISERROR 119

6.13.17 ISEVEN 120

6.13.18 ISFORMULA 120

6.13.19 ISLOGICAL 120

6.13.20 ISNA 120

6.13.21 ISNONTEXT 121

6.13.22 ISNUMBER 121

6.13.23 ISODD 121

6.13.24 ISREF 122

6.13.25 ISTEXT 122

6.13.26 N 122

6.13.27 NA 122

6.13.28 NUMBERVALUE 123

6.13.29 ROW 123

6.13.30 ROWS 123

6.13.31 SHEET 124

6.13.32 SHEETS 124

6.13.33 TYPE 124

6.13.34 VALUE 125

6.14 Lookup Functions 127

6.14.1 General 127

6.14.2 ADDRESS 127

6.14.3 CHOOSE 127

6.14.4 GETPIVOTDATA 128

6.14.5 HLOOKUP 128

6.14.6 INDEX 129

6.14.7 INDIRECT 130

6.14.8 LOOKUP 130

6.14.9 MATCH 131

6.14.10 MULTIPLE.OPERATIONS 132

6.14.11 OFFSET 133

6.14.12 VLOOKUP 134

6.15 Logical Functions 134

6.15.1 General 134

6.15.2 AND 135

6.15.3 FALSE 135

6.15.4 IF 135

6.15.5 IFERROR 135

6.15.6 IFNA 136

6.15.7 NOT 136

6.15.8 OR 136

6.15.9 TRUE 137

6.15.10 XOR 137

6.16 Mathematical Functions 137

6.16.1 General 137

6.16.2 ABS 137

6.16.3 ACOS 138

6.16.4 ACOSH 138

6.16.5 ACOT 138

6.16.6 ACOTH 138

6.16.7 ASIN 139

6.16.8 ASINH 139

6.16.9 ATAN 139

6.16.10 ATAN2 140

6.16.11 ATANH 140

6.16.12 BESSELI 140

6.16.13 BESSELJ 140

6.16.14 BESSELK 141

6.16.15 BESSELY 141

6.16.16 COMBIN 141

6.16.17 COMBINA 142

6.16.18 CONVERT 142

6.16.19 COS 150

6.16.20 COSH 150

6.16.21 COT 151

6.16.22 COTH 151

6.16.23 CSC 151

6.16.24 CSCH 152

6.16.25 DEGREES 152

6.16.26 DELTA 152

6.16.27 ERF 152

6.16.28 ERFC 153

6.16.29 EUROCONVERT 153

6.16.30 EVEN 154

6.16.31 EXP 155

6.16.32 FACT 155

6.16.33 FACTDOUBLE 155

6.16.34 GAMMA 155

6.16.35 GAMMALN 156

6.16.36 GCD 156

6.16.37 GESTEP 156

6.16.38 LCM 157

6.16.39 LN 157

6.16.40 LOG 157

6.16.41 LOG10 157

6.16.42 MOD 158

6.16.43 MULTINOMIAL 158

6.16.44 ODD 158

6.16.45 PI 158

6.16.46 POWER 159

6.16.47 PRODUCT 159

6.16.48 QUOTIENT 159

6.16.49 RADIANS 159

6.16.50 RAND 160

6.16.51 RANDBETWEEN 160

6.16.52 SEC 160

6.16.53 SERIESSUM 160

6.16.54 SIGN 161

6.16.55 SIN 161

6.16.56 SINH 161

6.16.57 SECH 162

6.16.58 SQRT 162

6.16.59 SQRTPI 162

6.16.60 SUBTOTAL 163

6.16.61 SUM 163

6.16.62 SUMIF 164

6.16.63 SUMIFS 164

6.16.64 SUMPRODUCT 164

6.16.65 SUMSQ 165

6.16.66 SUMX2MY2 165

6.16.67 SUMX2PY2 165

6.16.68 SUMXMY2 165

6.16.69 TAN 166

6.16.70 TANH 166

6.17 Rounding Functions 166

6.17.1 CEILING 166

6.17.2 INT 167

6.17.3 FLOOR 167

6.17.4 MROUND 167

6.17.5 ROUND 168

6.17.6 ROUNDDOWN 168

6.17.7 ROUNDUP 168

6.17.8 TRUNC 169

6.18 Statistical Functions 169

6.18.1 General 169

6.18.2 AVEDEV 169

6.18.3 AVERAGE 169

6.18.4 AVERAGEA 170

6.18.5 AVERAGEIF 170

6.18.6 AVERAGEIFS 170

6.18.7 BETADIST 171

6.18.8 BETAINV 171

6.18.9 BINOM.DIST.RANGE 172

6.18.10 BINOMDIST 172

6.18.11 LEGACY.CHIDIST 172

6.18.12 CHISQDIST 173

6.18.13 LEGACY.CHIINV 173

6.18.14 CHISQINV 174

6.18.15 LEGACY.CHITEST 174

6.18.16 CONFIDENCE 175

6.18.17 CORREL 175

6.18.18 COVAR 175

6.18.19 CRITBINOM 176

6.18.20 DEVSQ 176

6.18.21 EXPONDIST 176

6.18.22 FDIST 177

6.18.23 LEGACY.FDIST 177

6.18.24 FINV 178

6.18.25 LEGACY.FINV 178

6.18.26 FISHER 178

6.18.27 FISHERINV 179

6.18.28 FORECAST 179

6.18.29 FREQUENCY 179

6.18.30 FTEST 180

6.18.31 GAMMADIST 180

6.18.32 GAMMAINV 180

6.18.33 GAUSS 181

6.18.34 GEOMEAN 181

6.18.35 GROWTH 181

6.18.36 HARMEAN 182

6.18.37 HYPGEOMDIST 182

6.18.38 INTERCEPT 183

6.18.39 KURT 183

6.18.40 LARGE 184

6.18.41 LINEST 184

6.18.42 LOGEST 186

6.18.43 LOGINV 189

6.18.44 LOGNORMDIST 189

6.18.45 MAX 190

6.18.46 MAXA 190

6.18.47 MEDIAN 190

6.18.48 MIN 191

6.18.49 MINA 191

6.18.50 MODE 191

6.18.51 NEGBINOMDIST 192

6.18.52 NORMDIST 192

6.18.53 NORMINV 193

6.18.54 LEGACY.NORMSDIST 193

6.18.55 LEGACY.NORMSINV 193

6.18.56 PEARSON 194

6.18.57 PERCENTILE 194

6.18.58 PERCENTRANK 195

6.18.59 PERMUT 196

6.18.60 PERMUTATIONA 196

6.18.61 PHI 196

6.18.62 POISSON 197

6.18.63 PROB 197

6.18.64 QUARTILE 198

6.18.65 RANK 198

6.18.66 RSQ 199

6.18.67 SKEW 200

6.18.68 SKEWP 200

6.18.69 SLOPE 200

6.18.70 SMALL 201

6.18.71 STANDARDIZE 201

6.18.72 STDEV 201

6.18.73 STDEVA 202

6.18.74 STDEVP 202

6.18.75 STDEVPA 203

6.18.76 STEYX 203

6.18.77 LEGACY.TDIST 204

6.18.78 TINV 204

6.18.79 TREND 204

6.18.80 TRIMMEAN 205

6.18.81 TTEST 206

6.18.82 VAR 208

6.18.83 VARA 208

6.18.84 VARP 208

6.18.85 VARPA 209

6.18.86 WEIBULL 209

6.18.87 ZTEST 210

6.19 Number Representation Conversion Functions 210

6.19.1 General 210

6.19.2 ARABIC 211

6.19.3 BASE 211

6.19.4 BIN2DEC 211

6.19.5 BIN2HEX 212

6.19.6 BIN2OCT 212

6.19.7 DEC2BIN 213

6.19.8 DEC2HEX 213

6.19.9 DEC2OCT 214

6.19.10 DECIMAL 214

6.19.11 HEX2BIN 214

6.19.12 HEX2DEC 215

6.19.13 HEX2OCT 215

6.19.14 OCT2BIN 216

6.19.15 OCT2DEC 216

6.19.16 OCT2HEX 216

6.19.17 ROMAN 217

6.20 Text Functions 218

6.20.1 General 218

6.20.2 ASC 218

6.20.3 CHAR 220

6.20.4 CLEAN 221

6.20.5 CODE 221

6.20.6 CONCATENATE 221

6.20.7 DOLLAR 221

6.20.8 EXACT 222

6.20.9 FIND 222

6.20.10 FIXED 222

6.20.11 JIS 222

6.20.12 LEFT 225

6.20.13 LEN 225

6.20.14 LOWER 225

6.20.15 MID 226

6.20.16 PROPER 226

6.20.17 REPLACE 226

6.20.18 REPT 227

6.20.19 RIGHT 227

6.20.20 SEARCH 227

6.20.21 SUBSTITUTE 228

6.20.22 T 228

6.20.23 TEXT 228

6.20.24 TRIM 228

6.20.25 UNICHAR 229

6.20.26 UNICODE 229

6.20.27 UPPER 229

7 Other Capabilities 231

7.1 General 231

7.2 Inline constant arrays 231

7.3 Inline non-constant arrays 231

7.4 Year 1583 231

8 Non-portable Features 232

8.1 General 232

8.2 Distinct Logical 232

Table of Contents Part 3

1 Introduction 7

1.1 Introduction 7

1.2 Terminology 7

1.3 Normative References 7

1.4 Non Normative References 8

1.5 Namespaces 8

2 Packages, Package Consumers and Package Producers 10

2.1 Introduction 10

2.2 Packages 10

2.2.1 OpenDocument Package 10

2.2.2 OpenDocument Extended Package 11

2.3 Producers 11

2.3.1 OpenDocument Package Producer 11

2.3.2 OpenDocument Package Extended Producer 11

2.4 OpenDocument Package Consumer 11

3 Packages 12

3.1 General 12

3.2 Manifest 12

3.3 MIME Media Type 12

3.4 Encryption 13

3.4.1 General 13

3.4.2 Encryption Process 13

3.5 Digital Signatures 14

3.6 Metadata 14

3.7 Usage of IRIs Within Packages 14

3.8 Preview Image 16

4 Manifest File 17

4.1 Introduction 17

4.2 <manifest:manifest> 17

4.3 <manifest:file-entry> 17

4.4 <manifest:encryption-data> 17

4.5 <manifest:algorithm> 18

4.6 <manifest:start-key-generation> 18

4.7 <manifest:key-derivation> 18

4.8 Manifest Attributes 19

4.8.1 manifest:algorithm-name 19

4.8.2 manifest:checksum 19

4.8.3 manifest:checksum-type 19

4.8.4 manifest:full-path 20

4.8.5 manifest:initialisation-vector 20

4.8.6 manifest:start-key-generation-name 21

4.8.7 manifest:key-size 21

4.8.8 manifest:iteration-count 22

4.8.9 manifest:key-derivation-name 22

4.8.10 manifest:media-type 22

4.8.11 manifest:preferred-view-mode 23

4.8.12 manifest:salt 23

4.8.13 manifest:size 23

4.8.14 manifest:version 24

5 Digital Signatures File 25

5.1 Introduction 25

5.2 <dsig:document-signatures> 25

5.3 <ds:Signature> 25

5.4 Digital Signatures Attributes 27

5.4.1 dsig:version 27

6 Metadata Manifest Files 28

6.1 General 28

6.2 pkg:Document 28

6.3 pkg:File 28

6.4 pkg:MetadataFile 28

6.5 pkg:Element 28

6.6 pkg:hasPart 28

6.7 pkg:mimeType 29

7 Datatypes 30

7.1 Introduction 30

7.2 W3C Schema Datatypes 30

7.3 Other Datatypes 30

7.3.1 namespacedToken 30

Appendix A. Schemas 31

A.1. OpenDocument Manifest Schema 31

A.2. OpenDocument Digital Signature Schema 31

Appendix B. OpenDocument Metadata Manifest Ontology 32

Appendix C. Zip File Structure (Non normative) 33

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

1Introduction

1.1Scope

This standard specifies the characteristics of an XML-based application-independent and platform-independent digital document file format, as well as the characteristics of software applications which read, write and process such documents. This standard is applicable to document authoring, editing, viewing, exchange and archiving, including text documents, spreadsheets, presentation graphics, drawings, charts and similar documents commonly used by personal productivity software applications.

This standard has three parts.

Part 1 defines an XML schema for office documents. Office documents includes text documents, spreadsheets, charts and graphical documents like drawings or presentations, but is not restricted to these kinds of documents.

Part 2 defines a formula language for OpenDocument documents.

Part 3 defines the package format for OpenDocument documents.

This standard, for illustrative purposes, describes functionality using terminology common in desktop computing environments that contain a display terminal, keyboard and mouse, attached to a computer hosting an operating system with a graphical user interface which includes user interface controls such as input controls, command buttons, selection boxes, etc.

However, this standard is not limited to such environments. The standard also supports the use of alternative computing environments, other form factors, non-GUI consumers and producers, and the use of assistive technologies, using analogous user interface operations.

1.2Terminology

All text is normative unless otherwise labeled.

Within the normative text of this specification, the terms "shall", "shall not", "should", "should not", "may" and “need not” are to be interpreted as described in Annex H of [ISO/IEC Directives].

implementation-defined behavior: behavior that depends on the implementation and that each implementation shall document.

implementation-dependent behavior: behavior that depends on the implementation. The implementation is not required to document which behavior occurs.

Note:: Usually, the range of possible behaviors is delineated by the Standard.

undefined behavior: behavior for which the Standard imposes no requirements. Undefined behavior may also be expected when the standard omits the description of any explicit definition of behavior.



1.3Normative References

[ISO/IEC Directives] ISO/IEC Directives, Part 2 (Fifth Edition) Rules for the structure and drafting of International Standards, International Organization for Standardization and International Electrotechnical Commission, 2004.

The individual parts of the OpenDocument specification each defines its own set of normative references.

1.4Non Normative References

[ODF11] OASIS Standard, Open Document Format for Office Applications (OpenDocument) v1.1, February 2007, http://docs.oasis-open.org/office/v1.1/OS/OpenDocument-v1.1.pdf.

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

2Conformance

The OpenDocument specification defines conformance for documents, consumers, producers, packages, package consumer, package producers, formula expressions and formula evaluators, with multiple conformance classes.

  1. A conforming OpenDocument Document shall meet the requirements defined in part 1 section 2.2.1 and chapters 3 to 20 for OpenDocument documents..

  2. A conforming OpenDocument extended Document shall meet the requirements defined in part 1 section 2.2.2 and chapters 3 to 20 for OpenDocument extended documents.

  3. A conforming OpenDocument Text Document shall meet the requirements defined in part 1 section 2.2.3 and chapters 3 to 20 for OpenDocument Text documents.

  4. A conforming OpenDocument Spreadsheet Document shall meet the requirements defined in part 1 section 2.2.4 and chapters 3 to 20 for OpenDocument Spreadsheet documents.

  5. A conforming OpenDocument Drawing Document shall meet the requirements defined in part 1 section 2.2.5 and chapters 3 to 20 for OpenDocument Drawing documents.

  6. A conforming OpenDocument Presentation Document shall meet the requirements defined in part 1 section 2.2.6 and chapters 3 to 20 for OpenDocument Presentation documents.

  7. A conforming OpenDocument Chart Document shall meet the requirements defined in part 1 section 2.2.7 and chapters 3 to 20 for OpenDocument Chart documents.

  8. A conforming OpenDocument Image Document shall meet the requirements defined in part 1 section 2.2.8 and chapters 3 to 20 for OpenDocument Image documents.

  9. A conforming OpenDocument Formula Document shall meet the requirements defined in part 1 section 2.2.9 and chapters 3 to 20 for OpenDocument Formula documents.

  10. A conforming OpenDocument Database Front End Document shall meet the requirements defined in part 1 section 2.2.10 and chapters 3 to 20 for OpenDocument Database Front End documents.

  11. A Conforming OpenDocument Producer shall meet the requirements defined in part 1 section 2.3.1 and chapters 3 to 20 for OpenDocument producers.

  12. A Conforming OpenDocument Extended Producer shall meet the requirements defined in part 1 section 2.3.2 and chapters 3 to 20 for OpenDocument extended producers.

  13. A Conforming OpenDocument Consumer shall meet the requirements defined in part 1 section 2.4 and chapters 3 to 20 for OpenDocument consumers.

  14. A conforming OpenDocument Formula Expression shall meet the requirements defined in part 2 section 2.2 and chapters 3 to 8 for OpenDocument formula expressions.

  15. A Conforming OpenDocument Formula Evaluator shall meet the requirements defined in part 2 section 2.3.1 and chapters 3 to 8 for OpenDocument formula evaluators.

  16. A Conforming OpenDocument Formula Small Group Evaluator shall meet the requirements defined in part 2 section 2.3.2 and chapters 3 to 8 for OpenDocument formula small group evaluators.

  17. A Conforming OpenDocument Formula Medium Group Evaluator shall meet the requirements defined in part 2 section 2.3.3 and chapters 3 to 8 for OpenDocument formula medium group evaluators.

  18. A Conforming OpenDocument Formula Large Group Evaluator shall meet the requirements defined in part 2 section 2.3.4 and chapters 3 to 8 for OpenDocument formula large group evaluators.

  19. A conforming OpenDocument Package shall meet the requirements defined in part 3 section 2.2.1 and chapters 3 to 7 for OpenDocument packages.

  20. A conforming OpenDocument Extended Package shall meet the requirements defined in part 3 section 2.2.2 and chapters 3 to 7 for OpenDocument extended packages.

  21. A Conforming OpenDocument Package Producer shall meet the requirements defined in part 3 section 2.3.1 and chapters 3 to 7 for OpenDocument package producers.

  22. A Conforming OpenDocument Package Extended Producer shall meet the requirements defined in part 3 section 2.3.2 and chapters 3 to 7 for OpenDocument package extended producers.

  23. A Conforming OpenDocument Package Consumer shall meet the requirements defined in part 3 section 2.4 and chapters 3 to 7 for OpenDocument package consumers.

  1. Changes From Previous Specification Versions (Non Normative)

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

The OpenDocument specification has been divided into three parts and has been restructured. A more detailed list of changes is included in parts 1 and 3. Part 2 contains content that is new in OpenDocument v1.2.

  1. Acknowledgments (Non Normative)

The following individuals have participated in the creation of this specification and are gratefully acknowledged:

Participants:

Chieko Asakawa, IBM

Waldo Bastian, Intel Corporation

Thorsten Behrens, Novell

Nathaniel Borenstein, IBM

Michael Brauer, Oracle Corporation

Pete Brunet, IBM

Manuel Cano
Suresh Chande, Nokia Corporation

Robin Cover, OASIS

Pierre Ducroquet

Jerome Dumonteil, Ars Aperta

Patrick Durusau

Cherie Ekholm, Microsoft Corporation

Ezer Farhi

David Faure

Jean Gouarne, Ars Aperta

Andreas J. Guelzow

Bettina Haberer, Sun Microsystems

Dennis E. Hamilton

Bart Hanssens, Fedict

Donald Harbison, IBM

Mingfei Jia, IBM

Bob Jolliffe

Peter Junge

Kazmer Koleszar, MultiRacio Ltd.

Peter Korn, Oracle Corporation

Jirka Kosek

Robin LaFontaine

Marcus Lange, Sun Microsystems

David LeBlanc, Microsoft

Fong Lin, Novell

Jun Ma, Beijing Redflag Chinese 2000 Software Co., Ltd.

Yue Ma, IBM

John Madden, Duke University

Doug Mahugh, Microsoft Corporation

Ben Martin, KDE e.V.

James Mason, ISO/IEC JTC1/SC34

Tristan Mitchell

Duane Nickull, Adobe Systems

Michael Paciello
Ganesh Paramasivam, KDE e.V.

Eric Patterson, Microsoft Corporation

David Pawson
Steven Pemberton, Stichting Centrum voor Wiskunde & Informatica

Stephen Peront, Microsoft Corporation

Asokan Ramanathan, IBM

Eike Rathke, Oracle Corporation

Florian Reuter, Novell

Janina Sajka

Svante Schubert, Oracle Corporation

Charles Schulz, Ars Aperta

Richard Schwerdtfeger, IBM

Douglas Schepers

Wei Guo Shi, IBM

Michael Stahl, Oracle Corporation

Yan Shi, Beijing Sursen International Information Technology Co., Ltd.

Jomar Silva, OpenDocument Format Alliance

Frank Stecher, Sun Microsystems

Hironobu Takagi, IBM

Malte Timmermann, Oracle Corporation

John Tolbert, The Boeing Company

Elias Torres, IBM

Warren Turkal, Google Inc.

Jos van den Oever, KDE e.V.

Alex Wang, Beijing Sursen International Information Technology Co., Ltd.

Robert Weir, IBM

Oliver-Rainer Wittmann, Oracle Corporation

David A. Wheeler

Cheng XiuZhi, Beijing Redflag Chinese 2000 Software Co., Ltd.

Panrong Yin, IBM

Kohei Yoshida, Novell

Helen Yue, IBM

Jin YouBing, Beijing Redflag Chinese 2000 Software Co., Ltd.

Thorsten Zachmann, Nokia Corporation

Thomas Zander, Nokia Corporation

Pine Zhang, UOML Alliance

OpenDocument-v1.2-csd06 2 December 2010
Copyright ©
OASIS® 2010. All Rights Reserved. Standards Track Work Product Page 104 of 104