Open Document Format for Office Applications (OpenDocument) Version 1.2

OASIS Standard

29 September 2011

Specification URIs:

This version:

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

Previous 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

Latest version:

http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2.odt (Authoritative)
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

Michael Brauer, Oracle Corporation

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) TC on the above date. The level of approval is also listed above. Check the "Latest version" location noted above for possible later revisions of this document.

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

For information on whether any patents have been disclosed that may be essential to implementing this specification, and any offers of patent licensing terms, please refer to the Intellectual Property Rights section of the Technical Committee web page (http://www.oasis-open.org/committees/office/ipr.php).

 

Citation format:

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

OpenDocument-v1.2

Open Document Format for Office Applications (OpenDocument) Version 1.2. 29 September 2011.  OASIS Standard. http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os.html.

Notices

Copyright © OASIS Open 2002–2011. 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

1.1 Scope

1.2 Terminology

1.3 Normative References

1.4 Non Normative References

2 Conformance

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

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

Appendix B. Acknowledgments (Non Normative)

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        88

2.2.8 OpenDocument Image Document        88

2.2.9 OpenDocument Formula Document        88

2.2.10 OpenDocument Database Front End Document        88

2.3 Producers        89

2.3.1 OpenDocument Producer        89

2.3.2 OpenDocument Extended Producer        89

2.4 Consumer        89

3 Document Structure        90

3.1 Document Representation         90

3.1.1 General        90

3.1.2 <office:document>(Single OpenDocument XML Files)        90

3.1.3 Package OpenDocument Files        90

3.1.3.1 General        90

3.1.3.2 <office:document-content>        90

3.1.3.3 <office:document-styles>        91

3.1.3.4 <office:document-meta>        91

3.1.3.5 <office:document-settings>        91

3.1.4 Summary of Document Representation        91

3.2 <office:meta>        92

3.3 <office:body>        92

3.4 <office:text>        93

3.5 <office:drawing>        93

3.6 <office:presentation>        93

3.7 <office:spreadsheet>        94

3.8 <office:chart>        94

3.9 <office:image>        94

3.10 <office:settings>        95

3.10.1 General        95

3.10.2 <config:config-item-set>        95

3.10.3 <config:config-item>        95

3.10.4 <config:config-item-map-indexed>        96

3.10.5 <config:config-item-map-entry>        96

3.10.6 <config:config-item-map-named>        96

3.11 Cursor Position Setting        96

3.12 <office:scripts>        97

3.13 <office:script>        97

3.14 <office:font-face-decls>        97

3.15 Styles        97

3.15.1 General        97

3.15.2 <office:styles>        98

3.15.3 <office:automatic-styles>        98

3.15.4 <office:master-styles>        98

3.16 Document Signatures        99

3.17 Foreign Elements and Attributes        99

3.18 White Space Processing and EOL Handling        100

3.19 MIME Types and File Name Extensions        100

4 Metadata        101

4.1 General        101

4.2 RDF Metadata        101

4.2.1 In Content Metadata (RDFa)        101

4.2.2 manifest.rdf        101

4.2.2.1 General        101

4.2.2.2 odf:ContentFile        101

4.2.2.3 odf:StylesFile        102

4.2.2.4 odf:Element        102

4.2.2.5 odf:prefix        102

4.2.2.6 odf:suffix        102

4.3 Non-RDF Metadata        102

4.3.1 General        102

4.3.2 Pre-Defined Metadata Elements        103

4.3.2.1 <meta:generator>        103

4.3.2.2 <dc:title>        103

4.3.2.3 <dc:description>        103

4.3.2.4 <dc:subject>        104

4.3.2.5 <meta:keyword>        104

4.3.2.6 <meta:initial-creator>        104

4.3.2.7 <dc:creator>        104

4.3.2.8 <meta:printed-by>        104

4.3.2.9 <meta:creation-date>        105

4.3.2.10 <dc:date>        105

4.3.2.11 <meta:print-date>        105

4.3.2.12 <meta:template>        105

4.3.2.13 <meta:auto-reload>        106

4.3.2.14 <meta:hyperlink-behaviour>        106

4.3.2.15 <dc:language>        106

4.3.2.16 <meta:editing-cycles>        106

4.3.2.17 <meta:editing-duration>        107

4.3.2.18 <meta:document-statistic>        107

4.3.3 <meta:user-defined>        107

5 Text Content        108

5.1 Headings, Paragraphs and Basic Text Structure        108

5.1.1 General        108

5.1.2 <text:h>        108

5.1.3 <text:p>        109

5.2 <text:page-sequence>        111

5.2.1 General        111

5.2.2 <text:page>        111

5.3 Lists        111

5.3.1 <text:list>        111

5.3.2 Default List Style         112

5.3.3 <text:list-header>        112

5.3.4 <text:list-item>        112

5.3.5 List Item Style Rules        113

5.3.6 <text:numbered-paragraph>        113

5.3.7 Numbered Paragraph Style Rules        113

5.4 <text:section>        114

5.4.1 General        114

5.4.2 <text:section-source>        115

5.5 Change Tracking        115

5.5.1 <text:tracked-changes>        115

5.5.2 <text:changed-region>        115

5.5.3 <text:insertion>        116

5.5.4 <text:deletion>        116

5.5.5 <text:format-change>        117

5.5.6 <office:change-info>        117

5.5.7 Change Marks        117

5.5.7.1 General        117

5.5.7.2 <text:change-start>        118

5.5.7.3 <text:change-end>        118

5.5.7.4 <text:change>        118

5.6 <text:soft-page-break>        118

5.7 Document Declarations        119

6 Paragraph Elements Content        120

6.1 Basic Text Content        120

6.1.1 General        120

6.1.2 White Space Characters        120

6.1.3 <text:s>        121

6.1.4 <text:tab>        121

6.1.5 <text:line-break>        121

6.1.6 Soft Hyphens, Hyphens, and Non-breaking Spaces        121

6.1.7 <text:span>        122

6.1.8 <text:a>        123

6.1.9 <text:meta>        124

6.1.10 <text:number>        125

6.2 Bookmarks and References        126

6.2.1 Bookmarks        126

6.2.1.1 General        126

6.2.1.2 <text:bookmark>        126

6.2.1.3 <text:bookmark-start>        126

6.2.1.4 <text:bookmark-end>        126

6.2.2 References        127

6.2.2.1 General        127

6.2.2.2 <text:reference-mark>        127

6.2.2.3 <text:reference-mark-start>        127

6.2.2.4 <text:reference-mark-end>        128

6.3 Notes        128

6.3.1 General        128

6.3.2 <text:note>        128

6.3.3 <text:note-citation>        128

6.3.4 <text:note-body>        128

6.4 <text:ruby>        129

6.4.1 General        129

6.4.2 <text:ruby-base>        129

6.4.3 <text:ruby-text>        130

7 Text Fields        132

7.1 General        132

7.2 Common Characteristics of Field Elements        132

7.3 Document Fields        132

7.3.1 General        132

7.3.2 <text:date>        132

7.3.3 <text:time>        133

7.3.4 <text:page-number>        133

7.3.5 <text:page-continuation>        133

7.3.6 Subsequent Author Fields        134

7.3.6.1 General        134

7.3.6.2 <text:sender-firstname>        134

7.3.6.3 <text:sender-lastname>        134

7.3.6.4 <text:sender-initials>        134

7.3.6.5 <text:sender-title>        135

7.3.6.6 <text:sender-position>        135

7.3.6.7 <text:sender-email>        135

7.3.6.8 <text:sender-phone-private>        135

7.3.6.9 <text:sender-fax>        136

7.3.6.10 <text:sender-company>        136

7.3.6.11 <text:sender-phone-work>        136

7.3.6.12 <text:sender-street>        136

7.3.6.13 <text:sender-city>        137

7.3.6.14 <text:sender-postal-code>        137

7.3.6.15 <text:sender-country>        137

7.3.6.16 <text:sender-state-or-province>        137

7.3.7 Author Fields        138

7.3.7.1 <text:author-name>        138

7.3.7.2 <text:author-initials>        138

7.3.8 <text:chapter>        138

7.3.9 <text:file-name>        139

7.3.10 <text:template-name>        139

7.3.11 <text:sheet-name>        139

7.4 Variable Fields        139

7.4.1 General        139

7.4.2 <text:variable-decls>        140

7.4.3 <text:variable-decl>        140

7.4.4 <text:variable-set>        141

7.4.5 <text:variable-get>        141

7.4.6 <text:variable-input>        141

7.4.7 <text:user-field-decls>        142

7.4.8 <text:user-field-decl>        142

7.4.9 <text:user-field-get>        142

7.4.10 <text:user-field-input>        142

7.4.11 <text:sequence-decls>        143

7.4.12 <text:sequence-decl>        143

7.4.13 <text:sequence>        143

7.4.14 <text:expression>        144

7.4.15 <text:text-input>        144

7.5 Metadata Fields        144

7.5.1 General        144

7.5.2 <text:initial-creator>        144

7.5.3 <text:creation-date>        145

7.5.4 <text:creation-time>        145

7.5.5 <text:description>        145

7.5.6 <text:user-defined>        146

7.5.7 <text:print-time>        146

7.5.8 <text:print-date>        146

7.5.9 <text:printed-by>        146

7.5.10 <text:title>        147

7.5.11 <text:subject>        147

7.5.12 <text:keywords>        147

7.5.13 <text:editing-cycles>        148

7.5.14 <text:editing-duration>        148

7.5.15 <text:modification-time>        148

7.5.16 <text:modification-date>        148

7.5.17 <text:creator>        149

7.5.18 Document Statistics Fields        149

7.5.18.1 General        149

7.5.18.2 <text:page-count>        149

7.5.18.3 <text:paragraph-count>        149

7.5.18.4 <text:word-count>        150

7.5.18.5 <text:character-count>        150

7.5.18.6 <text:table-count>        150

7.5.18.7 <text:image-count>        151

7.5.18.8 <text:object-count>        151

7.5.19 <text:meta-field>        151

7.6 Database Fields        152

7.6.1 General        152

7.6.2 <form:connection-resource>        153

7.6.3 <text:database-display>        153

7.6.4 <text:database-next>        153

7.6.5 <text:database-row-select>        154

7.6.6 <text:database-row-number>        154

7.6.7 <text:database-name>        154

7.7 More Fields        155

7.7.1 Page Variable Fields        155

7.7.1.1 General        155

7.7.1.2 <text:page-variable-set>        155

7.7.1.3 <text:page-variable-get>        155

7.7.2 <text:placeholder>        155

7.7.3 <text:conditional-text>        156

7.7.4 <text:hidden-text>        156

7.7.5 <text:reference-ref>         156

7.7.6 <text:bookmark-ref>        157

7.7.7 <text:note-ref>        157

7.7.8 <text:sequence-ref>        157

7.7.9 <text:script>        158

7.7.10 <text:execute-macro>        158

7.7.11 <text:hidden-paragraph>        158

7.7.12 <text:dde-connection>        159

7.7.13 <text:measure>        159

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

8 Text Indexes        161

8.1 Index Marks        161

8.1.1 General        161

8.1.2 <text:toc-mark-start>        161

8.1.3 <text:toc-mark-end>        161

8.1.4 <text:toc-mark>        162

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

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

8.1.7 <text:user-index-mark>        162

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

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

8.1.10 <text:alphabetical-index-mark>        163

8.1.11 <text:bibliography-mark>        163

8.2 Index Structure        164

8.2.1 General        164

8.2.2 <text:index-body>        164

8.2.3 <text:index-title>        165

8.3 <text:table-of-content>        165

8.3.1 General        165

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

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

8.4 <text:illustration-index>        166

8.4.1 General        166

8.4.2 <text:illustration-index-source>        167

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

8.5 <text:table-index>        167

8.5.1 General        167

8.5.2 <text:table-index-source>        168

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

8.6 <text:object-index>        168

8.6.1 General        168

8.6.2 <text:object-index-source>        169

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

8.7 <text:user-index>        169

8.7.1 General        169

8.7.2 <text:user-index-source>        170

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

8.8 <text:alphabetical-index>        170

8.8.1 General        170

8.8.2 <text:alphabetical-index-source>        171

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

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

8.9 <text:bibliography>        172

8.9.1 General        172

8.9.2 <text:bibliography-source>        172

8.9.3 <text:bibliography-entry-template>        172

8.10 <text:index-source-styles>        173

8.11 <text:index-source-style>        173

8.12 <text:index-title-template>        173

8.13 Index Template Entries        174

8.13.1 <text:index-entry-chapter>        174

8.13.2 <text:index-entry-text>        174

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

8.13.4 <text:index-entry-span>        174

8.13.5 <text:index-entry-bibliography>        175

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

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

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

9 Tables        177

9.1 Basic Tables        177

9.1.1 General        177

9.1.2 <table:table>        177

9.1.3 <table:table-row>        178

9.1.4 <table:table-cell>        178

9.1.5 <table:covered-table-cell>        178

9.1.6 <table:table-column>        179

9.1.7 <table:table-header-rows>        179

9.1.8 <table:table-rows>        180

9.1.9 <table:table-row-group>        180

9.1.10 <table:table-column-group>        180

9.1.11 <table:table-header-columns>        181

9.1.12 <table:table-columns>        181

9.1.13 <table:title>        181

9.1.14 <table:desc>        182

9.2 Advanced Tables        182

9.2.1 Referencing Table Cells        182

9.2.2 Absolute and relative cell addressing        183

9.2.3 Cell Range Address        183

9.2.4 Column and Row Range Addresses        183

9.2.5 Cell Range Address List        183

9.2.6 <table:table-source>        183

9.2.7 <table:scenario>        184

9.2.8 <table:shapes>        184

9.3 Advanced Table Cells        185

9.3.1 <table:cell-range-source>        185

9.3.2 <table:detective>        185

9.3.3 <table:operation>        185

9.3.4 <table:highlighted-range>        185

9.4 Spreadsheet Document Content        186

9.4.1 <table:calculation-settings>        186

9.4.2 <table:null-date>        186

9.4.3 <table:iteration>        186

9.4.4 <table:content-validations>        187

9.4.5 <table:content-validation>        187

9.4.6 <table:help-message>        187

9.4.7 <table:error-message>        188

9.4.8 <table:error-macro>        188

9.4.9 <table:label-range>        188

9.4.10 <table:label-ranges>        189

9.4.11 <table:named-expressions>        189

9.4.12 <table:named-range>        189

9.4.13 <table:named-expression>        189

9.4.14 <table:database-ranges>        190

9.4.15 <table:database-range>        190

9.4.16 <table:database-source-sql>        190

9.4.17 <table:database-source-table>        191

9.4.18 <table:database-source-query>        191

9.4.19 <table:sort>        191

9.4.20 <table:sort-by>        191

9.4.21 <table:subtotal-rules>        192

9.4.22 <table:sort-groups>        192

9.4.23 <table:subtotal-rule>        192

9.4.24 <table:subtotal-field>        192

9.5 Filters        193

9.5.1 General        193

9.5.2 <table:filter>        193

9.5.3 <table:filter-and>        193

9.5.4 <table:filter-or>        193

9.5.5 <table:filter-condition>        193

9.5.6 <table:filter-set-item>        194

9.6 Data Pilot Tables        194

9.6.1 General        194

9.6.2 <table:data-pilot-tables>        195

9.6.3 <table:data-pilot-table>        195

9.6.4 Data Pilot Table Source        195

9.6.5 <table:source-cell-range>        195

9.6.6 <table:source-service>        196

9.6.7 <table:data-pilot-field>        196

9.6.8 <table:data-pilot-level>        196

9.6.9 <table:data-pilot-subtotals>        197

9.6.10 <table:data-pilot-subtotal>        197

9.6.11 <table:data-pilot-members>        197

9.6.12 <table:data-pilot-member>        197

9.6.13 <table:data-pilot-display-info>        197

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

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

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

9.6.17 <table:data-pilot-groups>        198

9.6.18 <table:data-pilot-group>        199

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

9.7 <table:consolidation>        199

9.8 <table:dde-links>        200

9.9 Change Tracking in Spreadsheets        200

9.9.1 General         200

9.9.2 <table:tracked-changes>        200

9.9.3 <table:insertion>        200

9.9.4 <table:dependencies>        201

9.9.5 <table:dependency>        201

9.9.6 <table:deletions>        201

9.9.7 <table:cell-content-deletion>        201

9.9.8 <table:change-deletion>        202

9.9.9 <table:deletion>        202

9.9.10 <table:cut-offs>        202

9.9.11 <table:insertion-cut-off>        202

9.9.12 <table:movement-cut-off>        203

9.9.13 <table:movement>        203

9.9.14 <table:source-range-address>        203

9.9.15 <table:target-range-address>        203

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

9.9.17 <table:cell-content-change>        204

9.9.18 <table:cell-address>        204

9.9.19 <table:previous>        204

10 Graphic Content        206

10.1 General        206

10.2 Enhanced Page Features for Graphical Applications        206

10.2.1 <style:handout-master>        206

10.2.2 <draw:layer-set>        206

10.2.3 <draw:layer>        207

10.2.4 <draw:page>        207

10.2.5 <draw:equation>        208

10.3 Drawing Shapes        208

10.3.1 General        208

10.3.2 <draw:rect>        208

10.3.3 <draw:line>        208

10.3.4 <draw:polyline>        209

10.3.5 <draw:polygon>        209

10.3.6 <draw:regular-polygon>        210

10.3.7 <draw:path>        210

10.3.8 <draw:circle>        211

10.3.9 <draw:ellipse>        211

10.3.10 <draw:connector>        212

10.3.11 <draw:caption>        213

10.3.12 <draw:measure>        213

10.3.13 <draw:control>        214

10.3.14 <draw:page-thumbnail>        215

10.3.15 <draw:g>        215

10.3.16 <draw:glue-point>        216

10.3.17 <svg:title>        216

10.3.18 <svg:desc>        216

10.3.19 <office:event-listeners>        217

10.4 Frames        217

10.4.1 General        217

10.4.2 <draw:frame>        218

10.4.3 <draw:text-box>        218

10.4.4 <draw:image>        219

10.4.5 <office:binary-data>        219

10.4.6 Objects        219

10.4.6.1 General        219

10.4.6.2 <draw:object>        220

10.4.6.3 <draw:object-ole>        220

10.4.7 <draw:applet>        220

10.4.8 <draw:plugin>        221

10.4.9 <draw:param>        221

10.4.10 <draw:floating-frame>        221

10.4.11 Contours        222

10.4.11.1 General        222

10.4.11.2 <draw:contour-polygon>        222

10.4.11.3 <draw:contour-path>        222

10.4.12 <draw:a>        222

10.4.13 Client Side Image Maps        223

10.4.13.1 General        223

10.4.13.2 <draw:image-map>        223

10.4.13.3 <draw:area-rectangle>        223

10.4.13.4 <draw:area-circle>        224

10.4.13.5 <draw:area-polygon>        224

10.5 3D Shapes        224

10.5.1 General        224

10.5.2 <dr3d:scene>        225

10.5.3 <dr3d:light>        225

10.5.4 <dr3d:cube>        225

10.5.5 <dr3d:sphere>        226

10.5.6 <dr3d:extrude>        226

10.5.7 <dr3d:rotate>        226

10.6 Custom Shape        227

10.6.1 <draw:custom-shape>        227

10.6.2 <draw:enhanced-geometry>        227

10.6.3 <draw:handle>        228

10.7 Presentation Shapes        228

10.8 Presentation Animations        228

10.8.1 <presentation:animations>        228

10.8.2 <presentation:sound>        229

10.8.3 <presentation:show-shape>        229

10.8.4 <presentation:show-text>        229

10.8.5 <presentation:hide-shape>        230

10.8.6 <presentation:hide-text>        230

10.8.7 <presentation:dim>        230

10.8.8 <presentation:play>        230

10.8.9 <presentation:animation-group>        231

10.9 SMIL Presentation Animations        231

10.9.1 General        231

10.9.2 <presentation:event-listener>         231

10.9.3 Presentation Document Content        232

10.9.3.1 <presentation:header>        232

10.9.3.2 <presentation:header-decl>        232

10.9.3.3 <presentation:footer>        232

10.9.3.4 <presentation:footer-decl>        233

10.9.3.5 <presentation:date-time>        233

10.9.3.6 <presentation:date-time-decl>        233

10.9.3.7 <presentation:settings>        233

10.9.3.8 <presentation:show>        234

11 Chart Content        235

11.1 <chart:chart>        235

11.2 Title, Subtitle and Footer        235

11.2.1 <chart:title>        235

11.2.2 <chart:subtitle>        235

11.2.3 <chart:footer>        236

11.3 <chart:legend>        236

11.4 <chart:plot-area>        237

11.5 3D Plot Area        237

11.6 <chart:wall>        237

11.7 <chart:floor>        237

11.8 <chart:axis>        238

11.9 <chart:categories>        238

11.10 <chart:grid>        238

11.11 <chart:series>        238

11.12 <chart:domain>        239

11.13 <chart:data-point>        239

11.14 <chart:data-label>        239

11.15 <chart:mean-value>        240

11.16 <chart:error-indicator>        240

11.17 <chart:regression-curve>        240

11.18 <chart:equation>        240

11.19 <chart:stock-gain-marker>        241

11.20 <chart:stock-loss-marker>        241

11.21 <chart:stock-range-line>        241

12 Database Front-end Document Content        242

12.1 <office:database>        242

12.2 <db:data-source>        242

12.3 <db:connection-data>        242

12.4 <db:database-description>        242

12.5 <db:file-based-database>        243

12.6 <db:server-database>        243

12.7 <db:connection-resource>        243

12.8 <db:login>        243

12.9 <db:driver-settings>        244

12.10 <db:auto-increment>        244

12.11 <db:delimiter>        244

12.12 <db:character-set>        244

12.13 <db:table-settings>        245

12.14 <db:table-setting>        245

12.15 <db:application-connection-settings>        245

12.16 <db:table-filter>        245

12.17 <db:table-include-filter>        246

12.18 <db:table-exclude-filter>        246

12.19 <db:table-filter-pattern>        246

12.20 <db:table-type-filter>        246

12.21 <db:table-type>        247

12.22 <db:data-source-settings>        247

12.23 <db:data-source-setting>        247

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

12.25 Forms and Reports        248

12.25.1 General        248

12.25.2 <db:forms>        248

12.25.3 <db:reports>        248

12.25.4 <db:component-collection>        248

12.25.5 <db:component>        248

12.26 <db:queries>        249

12.27 <db:query-collection>        249

12.28 <db:query>        249

12.29 <db:order-statement>        249

12.30 <db:filter-statement>        250

12.31 <db:update-table>        250

12.32 <db:table-representations>        250

12.33 <db:table-representation>        250

12.34 <db:columns>        251

12.35 <db:column>        251

12.36 <db:schema-definition>        251

12.37 <db:table-definitions>        251

12.38 <db:table-definition>        252

12.39 <db:column-definitions>        252

12.40 <db:column-definition>        252

12.41 <db:keys>        252

12.42 <db:key>        253

12.43 <db:key-columns>        253

12.44 <db:key-column>        253

12.45 <db:indices>        253

12.46 <db:index>        253

12.47 <db:index-columns>        254

12.48 <db:index-column>        254

13 Form Content        255

13.1 General        255

13.2 <office:forms>        255

13.3 <form:form>        255

13.4 <xforms:model>        256

13.5 Controls        256

13.5.1 General        256

13.5.2 <form:text>        256

13.5.3 <form:textarea>        257

13.5.4 <form:password>        257

13.5.5 <form:file>        258

13.5.6 <form:formatted-text>        258

13.5.7 <form:number>        258

13.5.8 <form:date>        259

13.5.9 <form:time>        259

13.5.10 <form:fixed-text>        259

13.5.11 <form:combobox>        260

13.5.12 <form:item>        260

13.5.13 <form:listbox>        260

13.5.14 <form:option>        260

13.5.15 <form:button>        261

13.5.16 <form:image>        261

13.5.17 <form:checkbox>        261

13.5.18 <form:radio>        262

13.5.19 <form:frame>        262

13.5.20 <form:image-frame>        262

13.5.21 <form:hidden>        263

13.5.22 <form:grid>        263

13.5.23 <form:column>        263

13.5.24 <form:value-range>        264

13.5.25 <form:generic-control>        264

13.6 Event Listeners        264

13.7 <form:properties>        266

13.8 <form:property>        266

13.9 <form:list-property>        266

13.10 <form:list-value>        267

14 Common Content        268

14.1 <office:annotation>        268

14.2 <office:annotation-end>        268

14.3 <meta:date-string>        268

14.4 Event Listener Tables        269

14.4.1 General        269

14.4.2 <script:event-listener>        269

14.4.3 Event Types        269

14.4.4 Macro Name and Location        269

14.5 <math:math>        270

14.6 DDE Connections        270

14.6.1 General        270

14.6.2 <text:dde-connection-decls>        270

14.6.3 <text:dde-connection-decl>        270

14.6.4 <table:dde-link>        271

14.6.5 <office:dde-source>        271

15 SMIL Animations        272

15.1 General        272

15.2 Basic Animation Elements        272

15.2.1 General         272

15.2.2 <anim:animate>        272

15.2.3 <anim:animateTransform>        272

15.2.4 <anim:set>        273

15.2.5 <anim:animateMotion>        273

15.2.6 <anim:animateColor>        273

15.2.7 <anim:transitionFilter>        274

15.3 Animation Model Attributes        274

15.3.1 General        274

15.3.2 Simple Animation Functions        274

15.4 Animation Timing        274

15.4.1 General        274

15.4.2 <anim:par>        274

15.4.3 <anim:seq>        275

15.4.4 <anim:iterate>        275

15.5 <anim:audio>        276

15.6 Animation Command Elements        276

15.6.1 <anim:command>        276

15.6.2 <anim:param>        277

16 Styles        278

16.1 General        278

16.2 <style:style>        278

16.3 <style:map>        279

16.4 <style:default-style>        280

16.5 <style:page-layout>        280

16.6 <style:header-style>        280

16.7 <style:footer-style>        280

16.8 <style:default-page-layout>        281

16.9 <style:master-page>        281

16.10 <style:header>        282

16.11 <style:footer>        282

16.12 <style:header-left>        283

16.13 <style:footer-left>        283

16.14 <style:region-left>        283

16.15 <style:region-center>        284

16.16 <style:region-right>        284

16.17 <presentation:notes>        284

16.18 <table:table-template>        285

16.19 Cell Styles        285

16.19.1 General        285

16.19.2 <table:first-row>        285

16.19.3 <table:last-row>        286

16.19.4 <table:first-column>        286

16.19.5 <table:last-column>        286

16.19.6 <table:body>        286

16.19.7 <table:even-rows>        286

16.19.8 <table:odd-rows>        287

16.19.9 <table:even-columns>        287

16.19.10 <table:odd-columns>        287

16.20 <table:background>        287

16.21 <style:font-face>        288

16.22 <svg:font-face-src>        288

16.23 <svg:font-face-name>        289

16.24 <svg:font-face-uri>        289

16.25 <svg:definition-src>        289

16.26 <svg:font-face-format>        289

16.27 Data Styles        289

16.27.1 General        289

16.27.2 <number:number-style>        290

16.27.3 <number:number>        290

16.27.4 <number:embedded-text>        290

16.27.5 <number:scientific-number>        290

16.27.6 <number:fraction>        291

16.27.7 <number:currency-style>        291

16.27.8 <number:currency-symbol>        291

16.27.9 <number:percentage-style>        292

16.27.10 <number:date-style>        292

16.27.11 <number:day>        292

16.27.12 <number:month>        293

16.27.13 <number:year>        293

16.27.14 <number:era>        293

16.27.15 <number:day-of-week>        293

16.27.16 <number:week-of-year>        294

16.27.17 <number:quarter>        294

16.27.18 <number:time-style>        294

16.27.19 <number:hours>        294

16.27.20 <number:minutes>        295

16.27.21 <number:seconds>        295

16.27.22 <number:am-pm>        295

16.27.23 <number:boolean-style>        295

16.27.24 <number:boolean>        296

16.27.25 <number:text-style>        296

16.27.26 <number:text>        296

16.27.27 <number:text-content>        296

16.27.28 <style:text-properties>        297

16.28 Text Style Families        298

16.28.1 Text Styles        298

16.28.2 Paragraph Styles        298

16.28.3 Section Styles        298

16.28.4 Ruby Styles        298

16.29 Enhanced Text Styles        298

16.29.1 <text:linenumbering-configuration>        298

16.29.2 <text:linenumbering-separator>        299

16.29.3 <text:notes-configuration>        299

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

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

16.29.6 <text:bibliography-configuration>        300

16.29.7 <text:sort-key>        300

16.30 <text:list-style>        300

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

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

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

16.34 <text:outline-style>        302

16.35 <text:outline-level-style>        302

16.36 Table Styles        302

16.36.1 Table Styles        302

16.36.2 Table Column Styles        302

16.36.3 Table Row Styles        302

16.36.4 Table Cell Styles        303

16.37 Graphic Styles        303

16.38 Presentation Styles        303

16.39 Drawing Page Style        303

16.40 Enhanced Graphic Style Elements        303

16.40.1 <draw:gradient>        303

16.40.2 <svg:linearGradient>        304

16.40.3 <svg:radialGradient>        304

16.40.4 <svg:stop>        305

16.40.5 <draw:hatch>        305

16.40.6 <draw:fill-image>        305

16.40.7 <draw:opacity>        305

16.40.8 <draw:marker>        306

16.40.9 <draw:stroke-dash>        306

16.41 <style:presentation-page-layout>        307

16.42 <presentation:placeholder>        307

16.43 Chart Styles        307

17 Formatting Elements        308

17.1 General        308

17.2 <style:page-layout-properties>        308

17.3 <style:background-image>        308

17.4 <style:footnote-sep>        309

17.5 <style:header-footer-properties>        309

17.6 <style:paragraph-properties>        310

17.7 <style:tab-stops>        310

17.8 <style:tab-stop>        310

17.9 <style:drop-cap>        311

17.10 <style:ruby-properties>        311

17.11 <style:section-properties>        311

17.12 <style:columns>        311

17.13 <style:column>        312

17.14 <style:column-sep>        312

17.15 <style:table-properties>        312

17.16 <style:table-column-properties>        313

17.17 <style:table-row-properties>        313

17.18 <style:table-cell-properties>        313

17.19 <style:list-level-properties>        314

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

17.21 <style:graphic-properties>        314

17.22 <style:chart-properties>        316

17.23 <chart:symbol-image>        317

17.24 <chart:label-separator>        317

17.25 <style:drawing-page-properties>        317

18 Datatypes        319

18.1 Introduction        319

18.2 W3C Schema Datatypes        319

18.3 Other Datatypes        320

18.3.1 angle        320

18.3.2 anyIRI         320

18.3.3 boolean        320

18.3.4 cellAddress        320

18.3.5 cellRangeAddress        320

18.3.6 cellRangeAddressList        320

18.3.7 character        320

18.3.8 clipShape        320

18.3.9 color        320

18.3.10 coordinate        321

18.3.11 countryCode        321

18.3.12 CURIE        321

18.3.13 CURIEs        321

18.3.14 dateOrDateTime        321

18.3.15 distance        321

18.3.16 language        321

18.3.17 languageCode        321

18.3.18 length        321

18.3.19 namespacedToken        322

18.3.20 nonNegativeLength        322

18.3.21 nonNegativePixelLength        322

18.3.22 pathData        322

18.3.23 percent        322

18.3.24 point3D        322

18.3.25 points        322

18.3.26 positiveLength        322

18.3.27 relativeLength        322

18.3.28 safeCURIE        322

18.3.29 scriptCode        322

18.3.30 signedZeroToHundredPercent        323

18.3.31 styleName        323

18.3.32 styleNameRef        323

18.3.33 styleNameRefs        323

18.3.34 targetFrameName        323

18.3.35 textEncoding        323

18.3.36 timeOrDateTime        323

18.3.37 URIorSafeCURIE        323

18.3.38 valueType        323

18.3.39 variableName        323

18.3.40 vector3D        323

18.3.41 zeroToHundredPercent        324

19 General Attributes        325

19.1 General        325

19.2 anim:color-interpolation        325

19.3 anim:color-interpolation-direction        325

19.4 anim:audio-level        325

19.5 anim:command        326

19.6 anim:formula        326

19.7 anim:id (deprecated)        327

19.8 anim:iterate-interval        328

19.9 anim:iterate-type        328

19.10 anim:name        328

19.11 anim:sub-item        328

19.12 anim:value        329

19.13 chart:attached-axis        329

19.14 chart:automatic-content        329

19.15 chart:class        329

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

19.15.2 <chart:grid>        336

19.16 chart:column-mapping (deprecated)        336

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

19.18 chart:dimension        337

19.19 chart:display-equation        338

19.20 chart:display-r-square        338

19.21 chart:label-cell-address        338

19.22 chart:legend-align        338

19.23 chart:legend-position        339

19.24 chart:name        339

19.25 chart:repeated        340

19.26 chart:row-mapping (deprecated)        340

19.27 chart:style-name        340

19.28 chart:values-cell-range-address        340

19.29 config:name        341

19.30 config:type        341

19.31 db:additional-column-statement        341

19.32 db:append-table-alias-name        342

19.33 db:apply-command        342

19.34 db:as-template        342

19.35 db:base-dn        342

19.36 db:boolean-comparison-mode        343

19.37 db:catalog-name        343

19.38 db:command        343

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

19.40 db:data-source-setting-name        344

19.41 db:data-source-setting-type        344

19.42 db:data-type        344

19.43 db:database-name        345

19.44 db:decimal        345

19.45 db:default-cell-style-name        345

19.46 db:default-row-style-name        345

19.47 db:delete-rule        345

19.48 db:description        346

19.49 db:enable-sql92-check        346

19.50 db:encoding        346

19.51 db:escape-processing        346

19.52 db:extension        347

19.53 db:field        347

19.54 db:hostname        347

19.55 db:ignore-driver-privileges        347

19.56 db:is-ascending        348

19.57 db:is-autoincrement        348

19.58 db:is-clustered        348

19.59 db:is-empty-allowed        348

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

19.61 db:login-timeout        349

19.62 db:is-nullable        349

19.63 db:is-password-required        349

19.64 db:is-unique        350

19.65 db:precision        350

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

19.67 db:local-socket        350

19.68 db:max-row-count        351

19.69 db:media-type        351

19.70 db:name        351

19.70.1 General        351

19.70.2 <db:column>        351

19.70.3 <db:column-definition>        351

19.70.4 <db:component>        352

19.70.5 <db:component-collection>        352

19.70.6 <db:index>        352

19.70.7 <db:index-column>        352

19.70.8 <db:key>        352

19.70.9 <db:key-column>        352

19.70.10 <db:query>        352

19.70.11 <db:query-collection>        353

19.70.12 <db:table-definition>        353

19.70.13 <db:table-representation>        353

19.70.14 <db:update-table>        353

19.71 db:parameter-name-substitution        353

19.72 db:port        354

19.73 db:referenced-table-name        354

19.74 db:related-column-name        354

19.75 db:row-retrieving-statement        354

19.76 db:scale        354

19.77 db:schema-name        354

19.78 db:show-deleted        355

19.79 db:string        355

19.80 db:style-name        355

19.80.1 General        355

19.80.2 <db:column>        355

19.80.3 <db:query>        355

19.80.4 <db:table-representation>        356

19.81 db:suppress-version-columns        356

19.82 db:system-driver-settings        356

19.83 db:thousand        356

19.84 db:title        356

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

19.86 db:type-name        358

19.87 db:update-rule        358

19.88 db:use-catalog        358

19.89 db:use-system-user        359

19.90 db:user-name        359

19.91 db:visible        359

19.92 dr3d:ambient-color        359

19.93 dr3d:center        360

19.94 dr3d:diffuse-color        360

19.95 dr3d:direction        360

19.96 dr3d:distance        360

19.97 dr3d:enabled        360

19.98 dr3d:focal-length        360

19.99 dr3d:lighting-mode        361

19.99.1 General        361

19.99.2 <chart:plot-area>        361

19.99.3 <dr3d:scene>        361

19.100 dr3d:max-edge         361

19.101 dr3d:min-edge        362

19.102 dr3d:projection        362

19.103 dr3d:shade-mode        362

19.104 dr3d:shadow-slant        362

19.105 dr3d:size        363

19.106 dr3d:specular        363

19.107 dr3d:transform        363

19.108 dr3d:vpn        363

19.109 dr3d:vrp        364

19.110 dr3d:vup        364

19.111 draw:align        364

19.112 draw:angle        365

19.113 draw:archive        365

19.114 draw:border        365

19.115 draw:caption-id        365

19.116 draw:caption-point-x        366

19.117 draw:caption-point-y        366

19.118 draw:chain-next-name        366

19.119 draw:class-id        366

19.120 draw:class-names        366

19.121 draw:code        367

19.122 draw:color        367

19.122.1 General        367

19.122.2 <draw:hatch>        367

19.122.3 <presentation:dim>        367

19.123 draw:concave        367

19.124 draw:concentric-gradient-fill-allowed        368

19.125 draw:control        368

19.126 draw:copy-of        368

19.127 draw:corner-radius        368

19.128 draw:corners        369

19.129 draw:cx        369

19.130 draw:cy        369

19.131 draw:data        369

19.132 draw:display        369

19.133 draw:display-name        370

19.133.1 General        370

19.133.2 <draw:fill-image>        370

19.133.3 <draw:gradient>        370

19.133.4 <draw:hatch>        370

19.133.5 <draw:marker>         370

19.133.6 <draw:opacity>        371

19.133.7 <draw:stroke-dash>        371

19.133.8 <svg:linearGradient>        371

19.133.9 <svg:radialGradient>        371

19.134 draw:distance        371

19.134.1 General        371

19.134.2 <draw:hatch>        371

19.134.3 <draw:stroke-dash>        372

19.135 draw:dots1        372

19.136 draw:dots1-length        372

19.137 draw:dots2        372

19.138 draw:dots2-length        372

19.139 draw:end        373

19.140 draw:end-angle        373

19.141 draw:end-color        373

19.142 draw:end-glue-point        373

19.143 draw:end-intensity        373

19.144 draw:end-shape        374

19.145 draw:enhanced-path        374

19.146 draw:engine        376

19.147 draw:escape-direction        376

19.148 draw:extrusion        377

19.149 draw:extrusion-allowed        377

19.150 draw:extrusion-brightness        377

19.151 draw:extrusion-color        378

19.152 draw:extrusion-depth        378

19.153 draw:extrusion-diffusion        378

19.154 draw:extrusion-first-light-direction        378

19.155 draw:extrusion-first-light-harsh        379

19.156 draw:extrusion-first-light-level        379

19.157 draw:extrusion-light-face        379

19.158 draw:extrusion-metal        379

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

19.160 draw:extrusion-origin        380

19.161 draw:extrusion-rotation-angle        381

19.162 draw:extrusion-rotation-center        381

19.163 draw:extrusion-second-light-direction        381

19.164 draw:extrusion-second-light-harsh        381

19.165 draw:extrusion-second-light-level        382

19.166 draw:extrusion-shininess        382

19.167 draw:extrusion-skew        382

19.168 draw:extrusion-specularity        382

19.169 draw:extrusion-viewpoint        383

19.170 draw:filter-name        383

19.171 draw:formula        383

19.172 draw:frame-name        385

19.173 draw:glue-point-leaving-directions        385

19.174 draw:glue-point-type        385

19.175 draw:glue-points        386

19.176 draw:handle-mirror-horizontal        386

19.177 draw:handle-mirror-vertical        387

19.178 draw:handle-polar        387

19.179 draw:handle-position        387

19.180 draw:handle-radius-range-maximum        389

19.181 draw:handle-radius-range-minimum        389

19.182 draw:handle-range-x-maximum        389

19.183 draw:handle-range-x-minimum        389

19.184 draw:handle-range-y-maximum        389

19.185 draw:handle-range-y-minimum        390

19.186 draw:handle-switched        390

19.187 draw:id        390

19.187.1 General        390

19.187.2 <draw:glue-point>        390

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

19.188 draw:kind        391

19.189 draw:layer        392

19.190 draw:line-skew        392

19.191 draw:mime-type        392

19.192 draw:mirror-horizontal        392

19.193 draw:mirror-vertical        393

19.194 draw:master-page-name        393

19.195 draw:may-script        393

19.196 draw:modifiers        393

19.197 draw:name        394

19.197.1 General        394

19.197.2 <draw:caption>        394

19.197.3 <draw:circle>        394

19.197.4 <draw:connector>        394

19.197.5 <draw:control>        394

19.197.6 <draw:custom-shape>        395

19.197.7 <draw:ellipse>        395

19.197.8 <draw:equation>        395

19.197.9 <draw:fill-image>        395

19.197.10 <draw:frame>        395

19.197.11 <draw:g>        395

19.197.12 <draw:gradient>        396

19.197.13 <draw:hatch>        396

19.197.14 <draw:layer>        396

19.197.15 <draw:line>        396

19.197.16 <draw:marker>        396

19.197.17 <draw:measure>        396

19.197.18 <draw:opacity>        397

19.197.19 <draw:page>        397

19.197.20 <draw:page-thumbnail>        397

19.197.21 <draw:param>        397

19.197.22 <draw:path>        397

19.197.23 <draw:polygon>        397

19.197.24 <draw:polyline>        398

19.197.25 <draw:rect>        398

19.197.26 <draw:regular-polygon>        398

19.197.27 <draw:stroke-dash>        398

19.197.28 <office:annotation> (deprecated)        398

19.197.29 <svg:linearGradient>        398

19.197.30 <svg:radialGradient>        399

19.198 draw:nav-order        399

19.199 draw:nohref        399

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

19.201 draw:object        400

19.202 draw:opacity        400

19.203 draw:page-number        400

19.204 draw:path-stretchpoint-x        400

19.205 draw:path-stretchpoint-y        401

19.206 draw:points        401

19.207 draw:protected        401

19.208 draw:recreate-on-edit        402

19.209 draw:rotation        402

19.210 draw:shape-id        402

19.211 draw:sharpness        402

19.212 draw:start        403

19.213 draw:start-angle        403

19.214 draw:start-color        403

19.215 draw:start-glue-point        403

19.216 draw:start-intensity        403

19.217 draw:start-shape        404

19.218 draw:style        404

19.218.1 General        404

19.218.2 <draw:gradient>        404

19.218.3 <draw:hatch>        405

19.218.4 <draw:opacity>        405

19.218.5 <draw:stroke-dash>        405

19.219 draw:style-name        406

19.219.1 General        406

19.219.2 <dr3d:cube>        406

19.219.3 <dr3d:extrude>        406

19.219.4 <dr3d:rotate>        406

19.219.5 <dr3d:scene>        406

19.219.6 <dr3d:sphere>        406

19.219.7 <draw:caption>        407

19.219.8 <draw:circle>        407

19.219.9 <draw:connector>        407

19.219.10 <draw:control>        407

19.219.11 <draw:custom-shape>        407

19.219.12 <draw:ellipse>        407

19.219.13 <draw:frame>        408

19.219.14 <draw:g>        408

19.219.15 <draw:line>        408

19.219.16 <draw:measure>        408

19.219.17 <draw:page>        408

19.219.18 <draw:page-thumbnail>        409

19.219.19 <draw:path>        409

19.219.20 <draw:polygon>        409

19.219.21 <draw:polyline>        409

19.219.22 <draw:rect>        409

19.219.23 <draw:regular-polygon>        409

19.219.24 <office:annotation>        410

19.219.25 <presentation:notes>        410

19.219.26 <style:handout-master>        410

19.219.27 <style:master-page>        410

19.220 draw:text-areas        410

19.221 draw:text-path        411

19.222 draw:text-path-allowed        412

19.223 draw:text-path-mode        412

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

19.225 draw:text-path-scale        413

19.226 draw:text-rotate-angle        413

19.227 draw:text-style-name        413

19.228 draw:transform        413

19.229 draw:type        414

19.229.1 General        414

19.229.2 <draw:connector>        414

19.229.3 <draw:enhanced-geometry>        415

19.230 draw:value        415

19.231 draw:z-index        415

19.232 fo:column-count        415

19.233 fo:column-gap        416

19.234 fo:country        416

19.234.1 <text:alphabetical-index-source>        416

19.234.2 <text:bibliography-configuration>        416

19.235 fo:end-indent        416

19.236 fo:language        417

19.236.1 General        417

19.236.2 <text:alphabetical-index-source>        417

19.236.3 <text:bibliography-configuration>        417

19.237 fo:margin-left        417

19.238 fo:max-height        417

19.239 fo:max-width        418

19.240 fo:min-height        418

19.241 fo:min-width        418

19.242 fo:script        419

19.242.1 General        419

19.242.2 <text:alphabetical-index-source>        419

19.242.3 <text:bibliography-configuration>        419

19.243 fo:space-after        419

19.244 fo:space-before        420

19.245 fo:start-indent        420

19.246 fo:text-indent        420

19.247 form:allow-deletes        420

19.248 form:allow-inserts        421

19.249 form:allow-updates        421

19.250 form:apply-design-mode        421

19.251 form:apply-filter        421

19.252 form:auto-complete        422

19.253 form:automatic-focus        422

19.254 form:bound-column        422

19.255 form:button-type        423

19.256 form:command        423

19.257 form:command-type        423

19.258 form:control-implementation        424

19.259 form:convert-empty-to-null        424

19.260 form:current-selected        424

19.261 form:current-state        425

19.262 form:current-value        425

19.263 form:data-field        425

19.264 form:datasource        426

19.265 form:default-button        426

19.266 form:delay-for-repeat        427

19.267 form:detail-fields        427

19.268 form:disabled        427

19.269 form:dropdown        427

19.270 form:echo-char        428

19.271 form:enctype        428

19.272 form:escape-processing        428

19.273 form:filter        429

19.274 form:focus-on-click        429

19.275 form:for        429

19.276 form:id (deprecated)         429

19.277 form:ignore-result        430

19.278 form:image-align        430

19.279 form:image-data        430

19.280 form:image-position        431

19.281 form:is-tristate        431

19.282 form:label        431

19.283 form:linked-cell        432

19.284 form:list-linkage-type        432

19.285 form:list-source        432

19.286 form:list-source-type        433

19.287 form:master-fields        434

19.288 form:max-length        434

19.289 form:max-value        434

19.289.1 General        434

19.289.2 <form:date>        434

19.289.3 <form:formatted-text>        435

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

19.289.5 <form:time>        435

19.290 form:min-value        435

19.290.1 General        435

19.290.2 <form:date>        435

19.290.3 <form:formatted-text>        435

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

19.290.5 <form:time>        436

19.291 form:method        436

19.292 form:multi-line        436

19.293 form:multiple        436

19.294 form:name        437

19.295 form:navigation-mode        437

19.296 form:order        437

19.297 form:orientation        438

19.298 form:page-step-size        438

19.299 form:printable        438

19.300 form:property-name        438

19.301 form:readonly        439

19.302 form:repeat        439

19.303 form:selected        439

19.304 form:size        440

19.305 form:source-cell-range        440

19.306 form:spin-button        440

19.307 form:state        440

19.308 form:step-size        441

19.309 form:tab-cycle        441

19.310 form:tab-index        441

19.311 form:tab-stop        442

19.312 form:text-style-name        442

19.313 form:title        443

19.314 form:toggle        443

19.315 form:validation        443

19.316 form:value        444

19.316.1 General         444

19.316.2 <form:button>        444

19.316.3 <form:date>        444

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

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

19.316.6 <form:time>        444

19.317 form:visual-effect        445

19.318 form:xforms-list-source        445

19.319 form:xforms-submission        445

19.320 grddl:transformation        445

19.321 meta:cell-count        446

19.322 meta:character-count        446

19.323 meta:date        446

19.324 meta:delay        446

19.325 meta:draw-count        446

19.326 meta:frame-count        447

19.327 meta:image-count        447

19.328 meta:name        447

19.329 meta:non-whitespace-character-count        447

19.330 meta:object-count        447

19.331 meta:ole-object-count        448

19.332 meta:page-count        448

19.333 meta:paragraph-count        448

19.334 meta:row-count        448

19.335 meta:sentence-count        448

19.336 meta:syllable-count        449

19.337 meta:table-count        449

19.338 meta:value-type        449

19.339 meta:word-count        449

19.340 number:automatic-order        450

19.341 number:calendar        450

19.342 number:country        451

19.343 number:decimal-places        451

19.343.1 General        451

19.343.2 <number:number>        451

19.343.3 <number:seconds>         451

19.343.4 <number:scientific-number>        451

19.344 number:decimal-replacement        452

19.345 number:denominator-value        452

19.346 number:display-factor        452

19.347 number:format-source        452

19.348 number:grouping        453

19.349 number:language        453

19.350 number:min-denominator-digits        453

19.351 number:min-exponent-digits        454

19.352 number:min-integer-digits        454

19.353 number:min-numerator-digits        454

19.354 number:position        454

19.355 number:possessive-form        455

19.356 number:rfc-language-tag        455

19.357 number:script        455

19.358 number:style        456

19.358.1 General        456

19.358.2 <number:day>        456

19.358.3 <number:day-of-week>        456

19.358.4 <number:era>        456

19.358.5 <number:hours>        456

19.358.6 <number:minutes>        457

19.358.7 <number:month>        457

19.358.8 <number:quarter>        457

19.358.9 <number:seconds>        457

19.358.10 <number:year>        458

19.359 number:textual        458

19.360 number:title        458

19.361 number:transliteration-country        458

19.362 number:transliteration-format        459

19.363 number:transliteration-language        459

19.364 number:transliteration-style        459

19.365 number:truncate-on-overflow        460

19.366 office:automatic-update        460

19.367 office:boolean-value        460

19.368 office:conversion-mode        461

19.369 office:currency        461

19.370 office:date-value        462

19.371 office:dde-application        462

19.372 office:dde-item        462

19.373 office:dde-topic        462

19.374 office:display        462

19.375 office:mimetype        463

19.376 office:name        463

19.376.1 General        463

19.376.2 <draw:a>        463

19.376.3 <draw:area-circle>        463

19.376.4 <draw:area-rectangle>        463

19.376.5 <draw:area-polygon>        464

19.376.6 <office:annotation>        464

19.376.7 <office:annotation-end>        464

19.376.8 <office:dde-source>        464

19.376.9 <text:a>        464

19.376.10 <text:dde-connection-decl>        465

19.377 office:process-content (deprecated)        465

19.378 office:server-map        465

19.379 office:string-value        465

19.380 office:target-frame        466

19.381 office:target-frame-name        466

19.382 office:time-value        467

19.383 office:title        467

19.384 office:value        467

19.385 office:value-type        468

19.386 office:version        469

19.387 presentation:action        469

19.388 presentation:animations        470

19.389 presentation:class        470

19.390 presentation:class-names        471

19.391 presentation:delay        471

19.392 presentation:direction        472

19.393 presentation:endless        473

19.394 presentation:effect        473

19.395 presentation:force-manual        474

19.396 presentation:full-screen        474

19.397 presentation:group-id        475

19.398 presentation:master-element        475

19.399 presentation:mouse-as-pen        475

19.400 presentation:mouse-visible        476

19.401 presentation:name        476

19.402 presentation:node-type        476

19.403 presentation:object        477

19.404 presentation:pages        477

19.405 presentation:path-id        477

19.406 presentation:pause        477

19.407 presentation:placeholder        478

19.408 presentation:play-full        478

19.409 presentation:presentation-page-layout-name        478

19.410 presentation:preset-class        478

19.411 presentation:preset-id        479

19.412 presentation:preset-sub-type        479

19.413 presentation:show        479

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

19.415 presentation:show-logo        480

19.416 presentation:source        480

19.417 presentation:speed        480

19.418 presentation:start-scale        481

19.419 presentation:start-page        481

19.420 presentation:start-with-navigator        481

19.421 presentation:stay-on-top        482

19.422 presentation:style-name        482

19.423 presentation:transition-on-click        482

19.424 presentation:use-date-time-name        483

19.425 presentation:use-footer-name        483

19.426 presentation:use-header-name        483

19.427 presentation:user-transformed        483

19.428 presentation:verb        484

19.429 script:event-name        484

19.430 script:language        485

19.431 script:macro-name        485

19.432 smil:accelerate        485

19.433 smil:accumulate        485

19.434 smil:additive        486

19.435 smil:attributeName        486

19.436 smil:autoReverse        487

19.437 smil:begin        487

19.438 smil:by        487

19.439 smil:calcMode        487

19.440 smil:decelerate        488

19.441 smil:direction        488

19.442 smil:dur        488

19.443 smil:end        488

19.444 smil:endsync        489

19.445 smil:fadeColor        489

19.446 smil:fill        489

19.447 smil:fillDefault        489

19.448 smil:from        489

19.449 smil:keySplines        490

19.450 smil:keyTimes        490

19.451 smil:mode        490

19.452 smil:repeatCount        490

19.453 smil:repeatDur        490

19.454 smil:restart        491

19.455 smil:restartDefault        491

19.456 smil:subtype        491

19.457 smil:targetElement        491

19.458 smil:to        492

19.459 smil:type        492

19.460 smil:values        492

19.461 style:adjustment        492

19.462 style:apply-style-name        493

19.463 style:auto-update        493

19.464 style:base-cell-address        493

19.465 style:char        494

19.466 style:class        494

19.467 style:color        494

19.468 style:condition        494

19.469 style:data-style-name        496

19.469.1 General        496

19.469.2 <presentation:date-time-decl>        496

19.469.3 <style:style>        496

19.469.4 <text:creation-date>        496

19.469.5 <text:creation-time>        496

19.469.6 <text:database-display>        496

19.469.7 <text:date>        497

19.469.8 <text:editing-duration>        497

19.469.9 <text:expression>        497

19.469.10 <text:meta-field>        497

19.469.11 <text:modification-date>        497

19.469.12 <text:modification-time>        497

19.469.13 <text:print-date>        498

19.469.14 <text:print-time>        498

19.469.15 <text:table-formula>        498

19.469.16 <text:time>        498

19.469.17 <text:user-defined>        498

19.469.18 <text:user-field-get>        499

19.469.19 <text:user-field-input>        499

19.469.20 <text:variable-get>        499

19.469.21 <text:variable-input>        499

19.469.22 <text:variable-set>        499

19.470 style:default-outline-level        500

19.471 style:display        500

19.472 style:display-name        500

19.473 style:distance        501

19.474 style:distance-before-sep        501

19.475 style:distance-after-sep        501

19.476 style:family        501

19.477 style:filter-name        502

19.478 style:font-adornments        502

19.479 style:font-charset        502

19.480 style:font-family-generic        503

19.481 style:font-pitch        503

19.482 style:height        503

19.483 style:leader-char        503

19.484 style:leader-color        504

19.485 style:leader-style        504

19.486 style:leader-text        504

19.487 style:leader-text-style        505

19.488 style:leader-type        505

19.489 style:leader-width        505

19.490 style:legend-expansion        506

19.491 style:legend-expansion-aspect-ratio        506

19.492 style:length        506

19.493 style:line-style        507

19.494 style:lines        507

19.495 style:list-level        507

19.496 style:list-style-name        507

19.497 style:master-page-name        508

19.498 style:name        508

19.498.1 General        508

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

19.498.3 <style:font-face>        509

19.499 style:next-style-name        509

19.499.1 General        509

19.499.2 <style:master-page>        509

19.499.3 <style:style>        509

19.500 style:num-format        510

19.501 style:num-letter-sync        510

19.502 style:num-prefix        511

19.503 style:num-suffix        511

19.504 style:page-layout-name        511

19.505 style:page-usage        511

19.506 style:parent-style-name        512

19.507 style:percentage-data-style-name        512

19.508 style:position        512

19.508.1 General        512

19.508.2 <style:background-image>        512

19.508.3 <style:tab-stop>        513

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

19.509 style:rel-height        513

19.510 style:rel-width        514

19.510.1 General        514

19.510.2 <draw:frame>        514

19.510.3 <style:column>        514

19.510.4 <style:footnote-sep>        515

19.511 style:repeat        515

19.512 style:rfc-language-tag        515

19.513 style:style        515

19.514 style:style-name        516

19.515 style:type        516

19.515.1 General        516

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

19.515.3 <style:tab-stop>        516

19.516 style:vertical-align        517

19.517 style:volatile        517

19.518 style:width        517

19.518.1 General        517

19.518.2 <style:column-sep>        518

19.518.3 <style:footnote-sep>        518

19.519 svg:accent-height        518

19.520 svg:alphabetic        518

19.521 svg:ascent        518

19.522 svg:bbox        518

19.523 svg:cap-height        518

19.524 svg:cx        519

19.524.1 <draw:area-circle>        519

19.524.2 <draw:circle>        519

19.524.3 <draw:ellipse>        519

19.524.4 <svg:radialGradient>        519

19.525 svg:cy        519

19.525.1 <draw:area-circle>        519

19.525.2 <draw:circle>        520

19.525.3 <draw:ellipse>        520

19.525.4 <svg:radialGradient>        520

19.526 svg:d        520

19.527 svg:descent        520

19.528 svg:font-family        520

19.529 svg:font-size        521

19.530 svg:font-stretch        521

19.531 svg:font-style        521

19.532 svg:font-variant        521

19.533 svg:font-weight        521

19.534 svg:fx        521

19.535 svg:fy        522

19.536 svg:gradientTransform        522

19.537 svg:gradientUnits        522

19.538 svg:hanging        522

19.539 svg:height        522

19.539.1 <chart:chart>        522

19.539.2 <chart:plot-area>        523

19.539.3 <dr3d:scene>        523

19.539.4 <draw:area-polygon>        523

19.539.5 <draw:area-rectangle>        523

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

19.539.7 <draw:fill-image>        523

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

19.539.9 <office:annotation>        524

19.539.10 <presentation:placeholder>        524

19.540 svg:ideographic        524

19.541 svg:mathematical        524

19.542 svg:name        525

19.543 svg:offset        525

19.544 svg:origin        525

19.545 svg:overline-position        525

19.546 svg:overline-thickness        525

19.547 svg:panose-1        525

19.548 svg:path        526

19.549 svg:r        526

19.549.1 <draw:area-circle>        526

19.549.2 <draw:circle>        526

19.549.3 <svg:radialGradient>        526

19.550 svg:rx        526

19.551 svg:ry        527

19.552 svg:slope        527

19.553 svg:spreadMethod        527

19.554 svg:stemh        527

19.555 svg:stemv        528

19.556 svg:stop-color        528

19.557 svg:stop-opacity        528

19.558 svg:strikethrough-position        528

19.559 svg:strikethrough-thickness        528

19.560 svg:string        528

19.561 svg:type        529

19.562 svg:underline-position        529

19.563 svg:underline-thickness        529

19.564 svg:unicode-range        529

19.565 svg:units-per-em        529

19.566 svg:v-alphabetic        529

19.567 svg:v-hanging        530

19.568 svg:v-ideographic        530

19.569 svg:v-mathematical        530

19.570 svg:viewBox        530

19.571 svg:width        530

19.571.1 <chart:chart>        530

19.571.2 <chart:floor>        531

19.571.3 <chart:plot-area>        531

19.571.4 <chart:wall>        531

19.571.5 <dr3d:scene>        531

19.571.6 <draw:area-polygon>        531

19.571.7 <draw:area-rectangle>        531

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

19.571.9 <draw:fill-image>        532

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

19.571.11 <office:annotation>        532

19.571.12 <presentation:placeholder>        532

19.572 svg:widths        533

19.573 svg:x        533

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

19.573.2 <draw:area-polygon>        533

19.573.3 <draw:area-rectangle>        533

19.573.4 <dr3d:scene>        533

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

19.573.6 <draw:glue-point>        534

19.573.7 <office:annotation>        534

19.573.8 <presentation:placeholder>        534

19.574 svg:x1        534

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

19.574.2 <svg:linearGradient>        535

19.575 svg:x2         535

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

19.575.2 <svg:linearGradient>        535

19.576 svg:x-height        535

19.577 svg:y        536

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

19.577.2 <draw:area-polygon>        536

19.577.3 <draw:area-rectangle>        536

19.577.4 <dr3d:scene>        536

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

19.577.6 <draw:glue-point>        537

19.577.7 <office:annotation>        537

19.577.8 <presentation:placeholder>        537

19.578 svg:y1        537

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

19.578.2 <svg:linearGradient>        537

19.579 svg:y2        538

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

19.579.2 <svg:linearGradient>        538

19.580 table:acceptance-state        538

19.581 table:algorithm        539

19.582 table:add-empty-lines        539

19.583 table:allow-empty-cell        539

19.584 table:application-data        539

19.585 table:automatic-find-labels        540

19.586 table:base-cell-address        540

19.587 table:bind-styles-to-content        540

19.588 table:border-color        541

19.589 table:buttons        541

19.590 table:case-sensitive        541

19.591 table:cell-address        541

19.592 table:cell-range        542

19.593 table:cell-range-address        542

19.593.1 General        542

19.593.2 <chart:categories>        542

19.593.3 <chart:domain> - bubble        542

19.593.4 <chart:domain>- scatter        542

19.593.5 <chart:domain> - surface        543

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

19.593.7 <table:highlighted-range>        543

19.593.8 <table:named-range>        543

19.593.9 <table:source-cell-range>        544

19.594 table:column        544

19.595 table:comment        544

19.596 table:condition        544

19.597 table:condition-source        546

19.598 table:condition-source-range-address        546

19.599 table:contains-error        546

19.600 table:contains-header        546

19.601 table:content-validation-name        547

19.602 table:copy-back        547

19.603 table:copy-formulas        547

19.604 table:copy-styles        548

19.605 table:count        548

19.606 table:country        548

19.607 table:data-field        548

19.608 table:data-cell-range-address        548

19.609 table:database-name        549

19.610 table:database-table-name        549

19.611 table:data-type        549

19.611.1 General        549

19.611.2 <table:filter-condition>        549

19.611.3 <table:sort-by>        549

19.611.4 <table:sort-groups>        550

19.612 table:date-end        550

19.613 table:date-start        551

19.614 table:date-value        551

19.615 table:default-cell-style-name        551

19.616 table:direction        551

19.617 table:display        552

19.618 table:display-border        552

19.619 table:display-duplicates        552

19.620 table:display-filter-buttons        553

19.621 table:display-list        553

19.622 table:display-member-mode        553

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

19.624 table:embedded-number-behavior        554

19.625 table:enabled        555

19.626 table:end        556

19.627 table:end-cell-address        556

19.628 table:end-column        556

19.629 table:end-position        556

19.630 table:end-row        557

19.631 table:end-table        557

19.632 table:end-x         557

19.633 table:end-y        557

19.634 table:execute        557

19.635 table:expression        558

19.636 table:field-name        558

19.637 table:field-number        558

19.638 table:filter-name        559

19.639 table:filter-options        559

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

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

19.642 table:formula        560

19.643 table:function        561

19.643.1 General        561

19.643.2 <table:consolidation>        561

19.643.3 <table:data-pilot-field>        561

19.643.4 <table:data-pilot-subtotal>        562

19.643.5 <table:subtotal-field>        562

19.644 table:grand-total        562

19.645 table:group-by-field-number        563

19.646 table:grouped-by        563

19.647 table:has-persistent-data        563

19.648 table:id        564

19.649 table:identify-categories        564

19.650 table:ignore-empty-rows        564

19.651 table:index        565

19.652 table:is-active        565

19.653 table:is-data-layout-field        565

19.654 table:is-selection        565

19.655 table:is-sub-table        566

19.656 table:label-cell-range-address        566

19.657 table:language        566

19.658 table:last-column-spanned        566

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

19.660 table:last-row-spanned        567

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

19.662 table:layout-mode        567

19.663 table:link-to-source-data        568

19.664 table:marked-invalid        568

19.665 table:matrix-covered        568

19.666 table:maximum-difference        569

19.667 table:member-count        569

19.668 table:member-name        569

19.669 table:member-type        569

19.670 table:message-type        570

19.671 table:mode        570

19.672 table:multi-deletion-spanned        570

19.673 table:name        571

19.673.1 General        571

19.673.2 <table:cell-range-source>        571

19.673.3 <table:content-validation>        571

19.673.4 <table:data-pilot-group>        571

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

19.673.6 <table:data-pilot-member>        571

19.673.7 <table:data-pilot-table>        572

19.673.8 <table:database-range>        572

19.673.9 <table:named-expression>        572

19.673.10 <table:named-range>        572

19.673.11 <table:operation>        572

19.673.12 <table:source-service>        573

19.673.13 <table:table>        573

19.673.14 <table:table-template>        573

19.674 table:null-year        573

19.675 table:number-columns-repeated        574

19.675.1 General        574

19.675.2 <table:covered-table-cell>        574

19.675.3 <table:table-cell>        574

19.675.4 <table:table-column>        574

19.676 table:number-columns-spanned        575

19.677 table:number-rows-repeated        575

19.678 table:number-rows-spanned        575

19.679 table:number-matrix-columns-spanned        575

19.680 table:number-matrix-rows-spanned        576

19.681 table:object-name        576

19.682 table:on-update-keep-size        576

19.683 table:on-update-keep-styles        576

19.684 table:operator        577

19.685 table:order        578

19.686 table:orientation        578

19.686.1 General        578

19.686.2 <table:data-pilot-field>        578

19.686.3 <table:database-range>        579

19.686.4 <table:label-range>        579

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

19.688 table:paragraph-style-name        579

19.689 table:parse-sql-statement        580

19.690 table:password        580

19.691 table:position        580

19.692 table:precision-as-shown        581

19.693 table:print        581

19.694 table:print-ranges        581

19.695 table:protect (deprecated)         581

19.696 table:protected        582

19.696.1 General        582

19.696.2 <table:covered-table-cell>         582

19.696.3 <table:scenario>        582

19.696.4 <table:table>        583

19.696.5 <table:table-cell>         583

19.697 table:protection-key        583

19.698 table:protection-key-digest-algorithm        583

19.699 table:query-name        584

19.700 table:range-usable-as        584

19.701 table:refresh-delay        584

19.702 table:rejecting-change-id        585

19.703 table:rfc-language-tag        585

19.704 table:row        585

19.705 table:scenario-ranges        586

19.706 table:script        586

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

19.708 table:selected-page        586

19.709 table:show-details        587

19.710 table:show-empty        587

19.711 table:show-filter-button        587

19.712 table:sort-mode        588

19.713 table:source-cell-range-addresses        588

19.714 table:source-field-name        588

19.715 table:source-name        588

19.716 table:sql-statement        589

19.717 table:start        589

19.718 table:start-column        589

19.719 table:start-position        589

19.720 table:start-row        589

19.721 table:start-table        590

19.722 table:status        590

19.723 table:step        590

19.724 table:steps        590

19.725 table:structure-protected        590

19.726 table:style-name        591

19.726.1 General        591

19.726.2 <table:background>        591

19.726.3 <table:body>        591

19.726.4 <table:covered-table-cell>        591

19.726.5 <table:even-columns>        592

19.726.6 <table:even-rows>        592

19.726.7 <table:first-column>        592

19.726.8 <table:first-row>        592

19.726.9 <table:last-column>        592

19.726.10 <table:last-row>        592

19.726.11 <table:odd-columns>        593

19.726.12 <table:odd-rows>        593

19.726.13 <table:table-cell>        593

19.726.14 <table:table-column>        593

19.726.15 <table:table-row>        593

19.726.16 <table:table>        593

19.727 table:table        594

19.728 table:table-background        594

19.729 table:table-name        594

19.730 table:target-cell-address        594

19.731 table:target-range-address        595

19.731.1 General        595

19.731.2 <table:data-pilot-table>        595

19.731.3 <table:database-range>        595

19.731.4 <table:filter>        595

19.731.5 <table:sort>        595

19.732 table:template-name        595

19.733 table:title        596

19.734 table:track-changes        596

19.735 table:type        596

19.735.1 General        596

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

19.735.3 <table:deletion>         597

19.735.4 <table:insertion>        597

19.736 table:use-banding-columns-styles        598

19.737 table:use-banding-rows-styles        598

19.738 table:use-first-column-styles        598

19.739 table:use-first-row-styles        599

19.740 table:use-last-column-styles        599

19.741 table:use-last-row-styles        599

19.742 table:use-labels        600

19.743 table:use-regular-expressions        600

19.744 table:use-wildcards        600

19.745 table:used-hierarchy        601

19.746 table:user-name        601

19.747 table:value        601

19.747.1 <table:filter-condition>        601

19.747.2 <table:filter-set-item>        602

19.748 table:value-type        602

19.749 table:visibility        602

19.750 text:active        602

19.751 text:address        603

19.752 text:alphabetical-separators        603

19.753 text:anchor-page-number        603

19.754 text:anchor-type        604

19.755 text:annote        605

19.756 text:author        605

19.757 text:bibliography-data-field        605

19.758 text:bibliography-type        606

19.759 text:booktitle        607

19.760 text:bullet-char        608

19.761 text:bullet-relative-size        608

19.762 text:capitalize-entries        608

19.763 text:c        609

19.764 text:caption-sequence-format        609

19.765 text:caption-sequence-name        609

19.766 text:change-id        609

19.767 text:chapter        610

19.768 text:citation-body-style-name        610

19.769 text:citation-style-name        610

19.770 text:class-names        610

19.770.1 General        610

19.770.2 <text:h>        610

19.770.3 <text:p>        611

19.770.4 <text:span>        611

19.771 text:column-name        611

19.772 text:combine-entries        611

19.773 text:combine-entries-with-dash        611

19.774 text:combine-entries-with-pp        612

19.775 text:comma-separated        612

19.776 text:cond-style-name        613

19.777 text:condition        613

19.777.1 General        613

19.777.2 <text:conditional-text>        613

19.777.3 <text:database-next>        613

19.777.4 <text:database-row-select>        613

19.777.5 <text:hidden-paragraph>        614

19.777.6 <text:hidden-text>        614

19.777.7 <text:section>        614

19.778 text:connection-name        614

19.779 text:consecutive-numbering        614

19.780 text:continue-list        615

19.781 text:continue-numbering        615

19.782 text:copy-outline-levels        615

19.783 text:count-empty-lines        616

19.784 text:count-in-text-boxes        616

19.785 text:current-value        616

19.786 text:custom1        616

19.787 text:custom2        617

19.788 text:custom3        617

19.789 text:custom4        617

19.790 text:custom5        617

19.791 text:database-name        617

19.792 text:date-adjust        617

19.793 text:date-value        618

19.794 text:default-style-name        618

19.795 text:description        618

19.796 text:display        618

19.796.1 General        618

19.796.2 <text:chapter>        618

19.796.3 <text:expression>        619

19.796.4 <text:file-name>        619

19.796.5 <text:index-entry-chapter>        620

19.796.6 <text:section>        620

19.796.7 <text:table-formula>        620

19.796.8 <text:template-name>        621

19.796.9 <text:user-field-get>        621

19.796.10 <text:variable-get>        621

19.796.11 <text:variable-input>        622

19.796.12 <text:variable-set>        622

19.797 text:display-levels        622

19.798 text:display-outline-level        622

19.799 text:duration        623

19.800 text:edition        623

19.801 text:editor        623

19.802 text:filter-name        623

19.803 text:fixed        623

19.804 text:footnotes-position        624

19.805 text:formula        624

19.806 text:global (deprecated)        624

19.807 text:howpublished        625

19.808 text:increment        625

19.809 text:id        625

19.809.1 General        625

19.809.2 <draw:text-box>        625

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

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

19.809.5 <text:changed-region>        626

19.809.6 <text:h>        626

19.809.7 <text:note>        627

19.809.8 <text:p>        627

19.809.9 <text:toc-mark-end>        627

19.809.10 <text:toc-mark-start>        627

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

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

19.810 text:identifier        628

19.811 text:index-name        628

19.812 text:index-scope        628

19.813 text:ignore-case        629

19.814 text:institution        629

19.815 text:is-hidden        629

19.816 text:is-list-header        630

19.817 text:isbn        630

19.818 text:issn        630

19.819 text:journal        630

19.820 text:key        631

19.821 text:key1        632

19.822 text:key2        632

19.823 text:key1-phonetic        632

19.824 text:key2-phonetic        632

19.825 text:kind        633

19.826 text:label        633

19.827 text:label-followed-by        633

19.828 text:level        633

19.829 text:list-id        634

19.830 text:list-tab-stop-position        634

19.831 text:main-entry        635

19.832 text:main-entry-style-name        635

19.833 text:master-page-name        635

19.834 text:month        635

19.835 text:name        636

19.835.1 General        636

19.835.2 <text:alphabetical-index>        636

19.835.3 <text:bibliography>        636

19.835.4 <text:bookmark>        636

19.835.5 <text:bookmark-end>        636

19.835.6 <text:bookmark-start>        636

19.835.7 <text:execute-macro>        636

19.835.8 <text:illustration-index>        637

19.835.9 <text:index-title>        637

19.835.10 <text:object-index>        637

19.835.11 <text:reference-mark>        637

19.835.12 <text:reference-mark-end>        637

19.835.13 <text:reference-mark-start>        637

19.835.14 <text:section>        638

19.835.15 <text:sequence>        638

19.835.16 <text:sequence-decl>        638

19.835.17 <text:table-of-content>        638

19.835.18 <text:table-index>        638

19.835.19 <text:user-defined>        638

19.835.20 <text:user-field-decl>        639

19.835.21 <text:user-field-get>        639

19.835.22 <text:user-field-input>        639

19.835.23 <text:user-index>        639

19.835.24 <text:variable-set>        639

19.835.25 <text:variable-decl>         639

19.835.26 <text:variable-get>        640

19.835.27 <text:variable-input>        640

19.836 text:note        640

19.837 text:note-class        640

19.838 text:number        640

19.839 text:number-lines        640

19.840 text:number-position        641

19.841 text:numbered-entries        641

19.842 text:offset        641

19.843 text:organizations        642

19.844 text:outline-level        642

19.844.1 General        642

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

19.844.3 <text:chapter>        642

19.844.4 <text:h>        643

19.844.5 <text:index-entry-chapter>        643

19.844.6 <text:index-source-styles>        643

19.844.7 <text:user-index-mark>        643

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

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

19.844.10 <text:toc-mark>        644

19.844.11 <text:toc-mark-start>         644

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

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

19.845 text:page-adjust        644

19.845.1 General        644

19.845.2 <text:page-number>        644

19.845.3 <text:page-variable-set>        645

19.846 text:pages        645

19.847 text:placeholder-type        645

19.848 text:prefix        645

19.849 text:protected        646

19.850 text:protection-key        646

19.851 text:protection-key-digest-algorithm        646

19.852 text:publisher        647

19.853 text:ref-name        647

19.853.1 General        647

19.853.2 <text:bookmark-ref>        647

19.853.3 <text:note-ref>        647

19.853.4 <text:reference-ref>        647

19.853.5 <text:sequence>        648

19.853.6 <text:sequence-ref>        648

19.854 text:reference-format        648

19.855 text:relative-tab-stop-position        649

19.856 text:report-type        650

19.857 text:restart-numbering        650

19.858 text:restart-on-page        650

19.859 text:row-number        650

19.860 text:school        651

19.861 text:section-name        651

19.862 text:series        651

19.863 text:select-page        651

19.863.1 General        651

19.863.2 <text:page-continuation>        651

19.863.3 <text:page-number>        652

19.864 text:separation-character        652

19.865 text:sort-algorithm        652

19.866 text:sort-ascending        653

19.867 text:sort-by-position        653

19.868 text:start-value        653

19.868.1 General        653

19.868.2 <text:h>        653

19.868.3 <text:list-item>        654

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

19.868.5 <text:notes-configuration>        654

19.868.6 <text:numbered-paragraph>        654

19.868.7 <text:outline-level-style>        654

19.869 text:start-numbering-at        655

19.870 text:string-value-phonetic        655

19.871 text:string-value        655

19.871.1 General        655

19.871.2 <text:alphabetical-index-mark>        655

19.871.3 <text:hidden-text>        655

19.871.4 <text:page-continuation>        656

19.871.5 <text:toc-mark>        656

19.871.6 <text:user-index-mark>        656

19.872 text:string-value-if-false        656

19.873 text:string-value-if-true        656

19.874 text:style-name        657

19.874.1 General        657

19.874.2 <text:a>        657

19.874.3 <text:alphabetical-index>        657

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

19.874.5 <text:bibliography>        657

19.874.6 <text:bibliography-entry-template>        657

19.874.7 <text:h>        658

19.874.8 <text:illustration-index>        658

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

19.874.10 <text:index-entry-bibliography>        658

19.874.11 <text:index-entry-chapter>        658

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

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

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

19.874.15 <text:index-entry-span>        659

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

19.874.17 <text:index-entry-text>        659

19.874.18 <text:index-source-style>        659

19.874.19 <text:index-title>        660

19.874.20 <text:index-title-template>        660

19.874.21 <text:linenumbering-configuration>        660

19.874.22 <text:list>        660

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

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

19.874.25 <text:numbered-paragraph>        661

19.874.26 <text:object-index>        661

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

19.874.28 <text:outline-level-style>        662

19.874.29 <text:p>        662

19.874.30 <text:ruby>        662

19.874.31 <text:ruby-text>        662

19.874.32 <text:section>        662

19.874.33 <text:span>        662

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

19.874.35 <text:table-of-content>        663

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

19.874.37 <text:table-index>        663

19.874.38 <text:user-index>        663

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

19.875 text:style-override        664

19.876 text:suffix        664

19.877 text:tab-ref        664

19.878 text:table-name        664

19.879 text:table-type        665

19.880 text:time-adjust        665

19.881 text:time-value        665

19.882 text:title        665

19.883 text:track-changes        665

19.884 text:url        666

19.885 text:use-caption        666

19.886 text:use-chart-objects        666

19.887 text:use-draw-objects        667

19.888 text:use-floating-frames        667

19.889 text:use-graphics        667

19.890 text:use-index-marks        668

19.891 text:use-index-source-styles        668

19.892 text:use-keys-as-entries        668

19.893 text:use-math-objects        669

19.894 text:use-objects        669

19.895 text:use-other-objects        669

19.896 text:use-outline-level        670

19.897 text:use-soft-page-breaks        670

19.898 text:use-spreadsheet-objects        671

19.899 text:use-tables        671

19.900 text:value        671

19.901 text:visited-style-name        672

19.902 text:volume        672

19.903 text:year        672

19.904 xforms:bind        672

19.905 xhtml:about        673

19.906 xhtml:content        673

19.907 xhtml:datatype        673

19.908 xhtml:property        674

19.909 xlink:actuate        674

19.910 xlink:href        675

19.910.1 General        675

19.910.2 <anim:audio>        675

19.910.3 <chart:chart>        675

19.910.4 <chart:symbol-image>        675

19.910.5 <db:component>        675

19.910.6 <db:connection-resource>        676

19.910.7 <db:file-based-database>        676

19.910.8 <draw:a>        676

19.910.9 <draw:applet>        676

19.910.10 <draw:area-circle>        676

19.910.11 <draw:area-polygon>        676

19.910.12 <draw:area-rectangle>        677

19.910.13 <draw:fill-image>        677

19.910.14 <draw:floating-frame>        677

19.910.15 <draw:image>        677

19.910.16 <draw:object>        677

19.910.17 <draw:object-ole>        677

19.910.18 <draw:plugin>        678

19.910.19 <form:button>        678

19.910.20 <form:connection-resource>        678

19.910.21 <form:image>        678

19.910.22 <form:form>        678

19.910.23 <meta:auto-reload>        678

19.910.24 <meta:template>        678

19.910.25 <presentation:event-listener>        679

19.910.26 <presentation:sound>        679

19.910.27 <script:event-listener>        679

19.910.28 <style:background-image>        679

19.910.29 <svg:definition-src>        679

19.910.30 <svg:font-face-uri>        679

19.910.31 <table:cell-range-source>        680

19.910.32 <table:table-source>        680

19.910.33 <text:a>        680

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

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

19.910.36 <text:script>        680

19.910.37 <text:section-source>        681

19.911 xlink:show        681

19.912 xlink:title        681

19.913 xlink:type        682

19.914 xml:id        682

20 Formatting Attributes        684

20.1 General        684

20.2 chart:angle-offset        684

20.3 chart:auto-position        684

20.4 chart:auto-size        684

20.5 chart:axis-label-position        685

20.6 chart:axis-position        685

20.7 chart:connect-bars        686

20.8 chart:data-label-number        686

20.9 chart:data-label-symbol        687

20.10 chart:data-label-text        687

20.11 chart:deep        687

20.12 chart:display-label        688

20.13 chart:error-category        688

20.14 chart:error-lower-indicator        689

20.15 chart:error-lower-limit        689

20.16 chart:error-lower-range        689

20.17 chart:error-margin        689

20.18 chart:error-percentage        690

20.19 chart:error-upper-indicator        690

20.20 chart:error-upper-limit        690

20.21 chart:error-upper-range        690

20.22 chart:gap-width        691

20.23 chart:group-bars-per-axis        691

20.24 chart:hole-size        691

20.25 chart:include-hidden-cells        691

20.26 chart:interpolation        692

20.27 chart:interval-major        694

20.28 chart:interval-minor-divisor        694

20.29 chart:japanese-candle-stick        695

20.30 chart:label-arrangement        695

20.31 chart:label-position        695

20.32 chart:label-position-negative        696

20.33 chart:lines (deprecated)        697

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

20.35 chart:logarithmic        698

20.36 chart:maximum        698

20.37 chart:mean-value        698

20.38 chart:minimum        699

20.39 chart:origin        699

20.40 chart:overlap        699

20.41 chart:pie-offset        699

20.42 chart:percentage        700

20.43 chart:regression-type        700

20.44 chart:reverse-direction        701

20.45 chart:right-angled-axes        701

20.46 chart:scale-text        701

20.47 chart:series-source (deprecated)        702

20.48 chart:sort-by-x-values        702

20.49 chart:solid-type        702

20.50 chart:spline-order        703

20.51 chart:spline-resolution        703

20.52 chart:stacked        703

20.53 chart:symbol-height        704

20.54 chart:symbol-name        704

20.55 chart:symbol-type        704

20.56 chart:symbol-width        705

20.57 chart:text-overlap        705

20.58 chart:three-dimensional        705

20.59 chart:tick-marks-major-inner        706

20.60 chart:tick-marks-major-outer        706

20.61 chart:tick-marks-minor-inner        706

20.62 chart:tick-marks-minor-outer        707

20.63 chart:tick-mark-position        707

20.64 chart:treat-empty-cells        708

20.65 chart:vertical        708

20.66 chart:visible        708

20.67 dr3d:ambient-color        709

20.68 dr3d:back-scale        709

20.69 dr3d:backface-culling        709

20.70 dr3d:close-back        709

20.71 dr3d:close-front        710

20.72 dr3d:depth        710

20.73 dr3d:diffuse-color        710

20.74 dr3d:edge-rounding        710

20.75 dr3d:edge-rounding-mode        710

20.76 dr3d:emissive-color        711

20.77 dr3d:end-angle        711

20.78 dr3d:horizontal-segments        711

20.79 dr3d:lighting-mode        712

20.80 dr3d:normals-direction        712

20.81 dr3d:normals-kind        712

20.82 dr3d:shadow        713

20.83 dr3d:shininess        713

20.84 dr3d:specular-color        713

20.85 dr3d:texture-filter        713

20.86 dr3d:texture-kind        713

20.87 dr3d:texture-mode        714

20.88 dr3d:texture-generation-mode-x        714

20.89 dr3d:texture-generation-mode-y        714

20.90 dr3d:vertical-segments        715

20.91 draw:auto-grow-height        715

20.92 draw:auto-grow-width        715

20.93 draw:background-size        716

20.94 draw:blue        716

20.95 draw:caption-angle        716

20.96 draw:caption-angle-type        717

20.97 draw:caption-escape        717

20.98 draw:caption-escape-direction        717

20.99 draw:caption-fit-line-length        717

20.100 draw:caption-gap        718

20.101 draw:caption-line-length        718

20.102 draw:caption-type        718

20.103 draw:color-inversion        718

20.104 draw:color-mode        719

20.105 draw:contrast        719

20.106 draw:decimal-places        719

20.107 draw:draw-aspect        720

20.108 draw:end-guide        720

20.109 draw:end-line-spacing-horizontal        720

20.110 draw:end-line-spacing-vertical        720

20.111 draw:fill        721

20.112 draw:fill-color        721

20.113 draw:fill-gradient-name        721

20.114 draw:fill-hatch-name        721

20.115 draw:fill-hatch-solid        722

20.116 draw:fill-image-height        722

20.117 draw:fill-image-name        722

20.118 draw:fill-image-ref-point        722

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

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

20.121 draw:fill-image-width        723

20.122 draw:fit-to-contour        724

20.123 draw:fit-to-size        724

20.124 draw:frame-display-border        724

20.125 draw:frame-margin-horizontal        725

20.126 draw:frame-display-scrollbar        725

20.127 draw:frame-margin-vertical        725

20.128 draw:gamma        725

20.129 draw:green        726

20.130 draw:gradient-step-count        726

20.131 draw:guide-distance        726

20.132 draw:guide-overhang        726

20.133 draw:image-opacity        726

20.134 draw:line-distance        727

20.135 draw:luminance        727

20.136 draw:marker-end        727

20.137 draw:marker-end-center        727

20.138 draw:marker-end-width        727

20.139 draw:marker-start        728

20.140 draw:marker-start-center        728

20.141 draw:marker-start-width        728

20.142 draw:measure-align        728

20.143 draw:measure-vertical-align        729

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

20.145 draw:opacity        729

20.146 draw:opacity-name        730

20.147 draw:parallel        730

20.148 draw:placing        730

20.149 draw:red        730

20.150 draw:secondary-fill-color        731

20.151 draw:shadow        731

20.152 draw:shadow-color        731

20.153 draw:shadow-offset-x        731

20.154 draw:shadow-offset-y        732

20.155 draw:shadow-opacity        732

20.156 draw:show-unit        732

20.157 draw:start-guide        732

20.158 draw:start-line-spacing-horizontal        732

20.159 draw:start-line-spacing-vertical        733

20.160 draw:stroke        733

20.161 draw:stroke-dash        733

20.162 draw:stroke-dash-names        733

20.163 draw:stroke-linejoin        734

20.164 svg:stroke-linecap        734

20.165 draw:symbol-color        734

20.166 draw:textarea-horizontal-align        734

20.167 draw:textarea-vertical-align        735

20.168 draw:tile-repeat-offset        735

20.169 draw:visible-area-height        736

20.170 draw:visible-area-left        736

20.171 draw:visible-area-top        736

20.172 draw:visible-area-width        737

20.173 draw:unit        737

20.174 draw:wrap-influence-on-position        737

20.175 fo:background-color        739

20.176 fo Border Properties        739

20.176.1 General        739

20.176.2 fo:border        739

20.176.3 fo:border-bottom        740

20.176.4 fo:border-left        740

20.176.5 fo:border-right        740

20.176.6 fo:border-top        740

20.177 fo:break-after        740

20.178 fo:break-before        741

20.179 fo:clip        741

20.180 fo:color        741

20.181 fo:country        741

20.182 fo:font-family        742

20.183 fo:font-size        742

20.184 fo:font-style        742

20.185 fo:font-variant        743

20.186 fo:font-weight        743

20.187 fo:height        743

20.188 fo:hyphenate        743

20.189 fo:hyphenation-keep        744

20.190 fo:hyphenation-ladder-count        744

20.191 fo:hyphenation-push-char-count        744

20.192 fo:hyphenation-remain-char-count        744

20.193 fo:keep-together        744

20.194 fo:keep-with-next        745

20.195 fo:language        745

20.196 fo:letter-spacing        745

20.197 fo:line-height        745

20.198 fo:margin        746

20.199 fo:margin-bottom        746

20.200 fo:margin-left        746

20.201 fo:margin-right        747

20.202 fo:margin-top        747

20.203 fo:max-height        747

20.204 fo:max-width        748

20.205 fo:min-height        748

20.205.1 <style:graphic-properties>        748

20.205.2 <style:header-footer-properties>        748

20.206 fo:min-width        748

20.207 fo:orphans        748

20.208 fo:page-height        749

20.209 fo:page-width        749

20.210 fo:padding        749

20.211 fo:padding-bottom        749

20.212 fo:padding-left        749

20.213 fo:padding-right        750

20.214 fo:padding-top        750

20.215 fo:script        750

20.216 fo:text-align        750

20.216.1 <style:paragraph-properties>        751

20.216.2 <style:list-level-properties>        751

20.217 fo:text-align-last        751

20.218 fo:text-indent        752

20.219 fo:text-shadow        752

20.220 fo:text-transform        752

20.221 fo:widows        752

20.222 fo:width        753

20.223 fo:wrap-option        753

20.224 presentation:background-objects-visible        753

20.225 presentation:background-visible        753

20.226 presentation:display-date-time        754

20.227 presentation:display-footer        754

20.228 presentation:display-header        754

20.229 presentation:display-page-number        755

20.230 presentation:duration        755

20.231 presentation:transition-speed        755

20.232 presentation:transition-style        756

20.233 presentation:transition-type        759

20.234 presentation:visibility        759

20.235 smil:direction        760

20.236 smil:fadeColor        760

20.237 smil:subtype        760

20.238 smil:type        760

20.239 style:auto-text-indent        760

20.240 style:background-transparency        761

20.241 style:border-line-width        761

20.242 style:border-line-width-bottom        761

20.243 style:border-line-width-left        762

20.244 style:border-line-width-right        762

20.245 style:border-line-width-top        762

20.246 style:cell-protect        763

20.247 style:column-width        763

20.248 style:country-asian        763

20.249 style:country-complex        764

20.250 style:decimal-places        764

20.251 style:diagonal-bl-tr        764

20.252 style:diagonal-bl-tr-widths        764

20.253 style:diagonal-tl-br        765

20.254 style:diagonal-tl-br-widths        765

20.255 style:direction        765

20.256 style:dynamic-spacing        765

20.257 style:editable        766

20.258 style:first-page-number        766

20.259 style:flow-with-text        766

20.260 style:font-charset        767

20.261 style:font-charset-asian        767

20.262 style:font-charset-complex        768

20.263 style:font-family-asian        768

20.264 style:font-family-complex        769

20.265 style:font-family-generic        769

20.266 style:font-family-generic-asian        770

20.267 style:font-family-generic-complex        770

20.268 style:font-independent-line-spacing        771

20.269 style:font-name        771

20.270 style:font-name-asian        771

20.271 style:font-name-complex        771

20.272 style:font-pitch        772

20.273 style:font-pitch-asian        772

20.274 style:font-pitch-complex        772

20.275 style:font-relief        773

20.276 style:font-size-asian        773

20.277 style:font-size-complex        773

20.278 style:font-size-rel        774

20.279 style:font-size-rel-asian        774

20.280 style:font-size-rel-complex        774

20.281 style:font-style-asian        775

20.282 style:font-style-complex        775

20.283 style:font-style-name        775

20.284 style:font-style-name-asian        776

20.285 style:font-style-name-complex        776

20.286 style:font-weight-asian        776

20.287 style:font-weight-complex        776

20.288 style:footnote-max-height        777

20.289 style:glyph-orientation-vertical        777

20.290 style:horizontal-pos        777

20.291 style:horizontal-rel        779

20.292 style:join-border        780

20.293 style:justify-single-word        781

20.294 style:language-asian        781

20.295 style:language-complex        781

20.296 style:layout-grid-base-height        781

20.297 style:layout-grid-base-width        782

20.298 style:layout-grid-color        782

20.299 style:layout-grid-display        782

20.300 style:layout-grid-lines        782

20.301 style:layout-grid-mode        782

20.302 style:layout-grid-print        783

20.303 style:layout-grid-ruby-below        783

20.304 style:layout-grid-ruby-height        783

20.305 style:layout-grid-snap-to        784

20.306 style:layout-grid-standard-mode        784

20.307 style:line-break        785

20.308 style:letter-kerning        785

20.309 style:line-height-at-least        785

20.310 style:line-spacing        785

20.311 style:may-break-between-rows        786

20.312 style:min-row-height        786

20.313 style:mirror        786

20.314 style:num-format        786

20.315 style:num-letter-sync        787

20.316 style:num-prefix        787

20.317 style:num-suffix        788

20.318 style:number-wrapped-paragraphs        788

20.319 style:overflow-behavior        788

20.320 style:page-number        789

20.321 style:paper-tray-name        789

20.322 style:print        789

20.323 style:print-content        790

20.323.1 General        790

20.323.2 <style:graphic-properties>        790

20.323.3 <style:table-cell-properties>        790

20.324 style:print-page-order        790

20.325 style:print-orientation        791

20.326 style:protect        791

20.326.1 General        791

20.326.2 <style:graphic-properties>        791

20.326.3 <style:section-properties>        791

20.327 style:punctuation-wrap        792

20.328 style:register-true        792

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

20.330 style:rel-column-width        793

20.331 style:rel-height        793

20.332 style:rel-width        793

20.332.1 <style:graphic-properties>        793

20.332.2 <style:table-properties>        794

20.333 style:repeat        794

20.334 style:repeat-content        794

20.335 style:rfc-language-tag        795

20.336 style:rfc-language-tag-asian        795

20.337 style:rfc-language-tag-complex        795

20.338 style:rotation-align        796

20.339 style:rotation-angle        796

20.340 style:row-height        796

20.341 style:ruby-align        797

20.342 style:ruby-position        797

20.343 style:run-through        798

20.344 style:scale-to        798

20.345 style:scale-to-pages        798

20.346 style:script-asian        798

20.347 style:script-complex        799

20.348 style:script-type        799

20.349 style:shadow        800

20.350 style:shrink-to-fit        800

20.351 style:snap-to-layout-grid        801

20.352 style:tab-stop-distance        801

20.353 style:table-centering        801

20.354 style:text-align-source        802

20.355 style:text-autospace        802

20.356 style:text-blinking        802

20.357 style:text-combine        802

20.358 style:text-combine-start-char        803

20.359 style:text-combine-end-char        803

20.360 style:text-emphasize        803

20.361 style:text-line-through-color        804

20.362 style:text-line-through-mode        804

20.363 style:text-line-through-style        804

20.364 style:text-line-through-text        805

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

20.366 style:text-line-through-type        805

20.367 style:text-line-through-width        806

20.368 style:text-outline        806

20.369 style:text-overline-color        807

20.370 style:text-overline-mode        807

20.371 style:text-overline-style        807

20.372 style:text-overline-type        808

20.373 style:text-overline-width        808

20.374 style:text-position        809

20.375 style:text-rotation-angle        809

20.376 style:text-rotation-scale        809

20.377 style:text-scale        810

20.378 style:text-underline-color        810

20.379 style:text-underline-mode        810

20.380 style:text-underline-style        810

20.381 style:text-underline-type        811

20.382 style:text-underline-width        811

20.383 style:use-optimal-column-width        812

20.384 style:use-optimal-row-height        812

20.385 style:use-window-font-color        812

20.386 style:vertical-align        813

20.386.1 <style:paragraph-properties>        813

20.386.2 <style:table-cell-properties>        813

20.387 style:vertical-pos        814

20.388 style:vertical-rel        814

20.389 style:width        815

20.390 style:wrap        815

20.391 style:wrap-contour        816

20.392 style:wrap-contour-mode        816

20.393 style:wrap-dynamic-threshold        816

20.394 style:writing-mode        817

20.394.1 General        817

20.394.2 <style:graphic-properties>        817

20.394.3 <style:page-layout-properties>        817

20.394.4 <style:paragraph-properties>        817

20.394.5 <style:section-properties>        817

20.394.6 <style:table-cell-properties>        818

20.394.7 <style:table-properties>        818

20.395 style:writing-mode-automatic        818

20.396 svg:fill-rule        819

20.397 svg:height        819

20.397.1 <style:graphic-properties>        819

20.397.2 <style:header-footer-properties>        819

20.398 svg:stroke-color        819

20.399 svg:stroke-opacity        819

20.400 svg:stroke-width        820

20.401 svg:x        820

20.402 svg:y        820

20.402.1 <style:graphic-properties>        820

20.402.2 <style:list-level-properties>        820

20.403 svg:width        820

20.404 table:align        820

20.405 table:border-model        821

20.406 table:display        821

20.407 text:anchor-page-number        821

20.408 text:anchor-type        822

20.409 text:animation        823

20.410 text:animation-delay        823

20.411 text:animation-direction        823

20.412 text:animation-repeat        824

20.413 text:animation-start-inside        824

20.414 text:animation-steps        824

20.415 text:animation-stop-inside        824

20.416 text:condition        825

20.417 text:display        825

20.418 text:dont-balance-text-columns        825

20.419 text:line-break        825

20.420 text:line-number        826

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

20.422 text:min-label-distance        826

20.423 text:min-label-width        827

20.424 text:number-lines        827

20.425 text:space-before        827

Appendix A.  OpenDocument Relax NG Schema        829

Appendix B.  OpenDocument Metadata Manifest Ontology        830

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

Appendix D.  Accessibility Guidelines (Non Normative)        833

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

D.1.1. Guidance for authors        833

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

D.2. Hyperlink Titles        834

D.3. Tables in Presentations        834

D.4. Further Guidelines        834

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

E.1. Paragraph and Layout Direction        835

E.2. Numeric Digits Presentation and Calendars        836

Appendix F.  Recommended Usage of SMIL        837

F.1. Slide Animation        837

F.2. Main Sequence        837

F.3. Interactive Sequence        838

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

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

Table of Contents Part 2

1 Introduction        20

1.1 Introduction        20

1.2 Terminology        20

1.3 Purpose        20

1.4 Normative References        20

1.5 Non-Normative References        21

2 Expressions and Evaluators        22

2.1 Introduction        22

2.2 OpenDocument Formula Expression        22

2.3 Evaluators        22

2.3.1 OpenDocument Formula Evaluator        22

2.3.2 OpenDocument Formula Small Group Evaluator        22

2.3.3 OpenDocument Formula Medium Group Evaluator        23

2.3.4 OpenDocument Formula Large Group Evaluator        24

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

3 Formula Processing Model        26

3.1 General        26

3.2 Expression Evaluation        26

3.2.1 General        26

3.2.2 Expression Calculation         26

3.2.3 Operator and Function Evaluation        26

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

3.4 Host-Defined Behaviors        29

3.5 When recalculation occurs        30

3.6 Numerical Models        30

3.7 Basic Limits        30

4 Types        32

4.1 General        32

4.2 Text (String)        32

4.3 Number        32

4.3.1 General        32

4.3.2 Time        33

4.3.3 Date        33

4.3.4 DateTime        33

4.3.5 Percentage        33

4.3.6 Currency        33

4.3.7 Logical (Number)        33

4.4 Complex Number        34

4.5 Logical (Boolean)        34

4.6 Error        34

4.7 Empty Cell        35

4.8 Reference        35

4.9 ReferenceList        35

4.10 Array        35

4.11 Pseudotypes        36

4.11.1 General        36

4.11.2 Scalar        36

4.11.3 DateParam        36

4.11.4 TimeParam        36

4.11.5 Integer        36

4.11.6  TextOrNumber        36

4.11.7 Basis        36

4.11.8 Criterion        38

4.11.9 Database        39

4.11.10 Field        39

4.11.11 Criteria        39

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

4.11.13 Any        40

5 Expression Syntax        41

5.1 General        41

5.2 Basic Expressions        41

5.3 Constant Numbers        42

5.4 Constant Strings        42

5.5 Operators        42

5.6 Functions and Function Parameters        43

5.7 Nonstandard Function Names        44

5.8 References        44

5.9 Reference List        45

5.10 Quoted Label        45

5.10.1 General        45

5.10.2 Lookup of Defined Labels        46

5.10.3 Automatic Lookup of Labels        46

5.10.4 Implicit Intersection        47

5.10.5 Automatic Range        47

5.10.6 Automatic Intersection        48

5.11 Named Expressions        48

5.12 Constant Errors        49

5.13 Inline Arrays        50

5.14 Whitespace        50

6 Standard Operators and Functions        51

6.1 General        51

6.2 Common Template for Functions and Operators        51

6.3 Implicit Conversion Operators        52

6.3.1 General        52

6.3.2 Conversion to Scalar        52

6.3.3 Implied intersection        52

6.3.4 Force to array context (ForceArray)        52

6.3.5 Conversion to Number        53

6.3.6 Conversion to Integer        53

6.3.7 Conversion to NumberSequence        53

6.3.8 Conversion to NumberSequenceList        54

6.3.9 Conversion to DateSequence        54

6.3.10 Conversion to Complex Number        54

6.3.11 Conversion to ComplexSequence        54

6.3.12 Conversion to Logical        55

6.3.13 Conversion to LogicalSequence        55

6.3.14 Conversion to Text        55

6.3.15 Conversion to DateParam        55

6.3.16 Conversion to TimeParam        55

6.4 Standard Operators        56

6.4.1 General        56

6.4.2 Infix Operator "+"        56

6.4.3 Infix Operator "-"        56

6.4.4 Infix Operator "*"        56

6.4.5 Infix Operator "/"        57

6.4.6 Infix Operator "^"        57

6.4.7 Infix Operator "="        57

6.4.8 Infix Operator "<>"        57

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

6.4.10 Infix Operator "&"        58

6.4.11 Infix Operator Reference Range (":")        58

6.4.12 Infix Operator Reference Intersection ("!")        59

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

6.4.14 Postfix Operator "%"        60

6.4.15 Prefix Operator "+"        60

6.4.16 Prefix Operator "-"        60

6.5 Matrix Functions        61

6.5.1 General        61

6.5.2 MDETERM        61

6.5.3 MINVERSE        61

6.5.4 MMULT        62

6.5.5 MUNIT        62

6.5.6 TRANSPOSE        62

6.6 Bit operation functions        63

6.6.1 General        63

6.6.2 BITAND        63

6.6.3 BITLSHIFT        63

6.6.4 BITOR        63

6.6.5 BITRSHIFT        64

6.6.6 BITXOR        64

6.7 Byte-position text functions        64

6.7.1 General        64

6.7.2 FINDB        64

6.7.3 LEFTB        65

6.7.4 LENB        65

6.7.5 MIDB        65

6.7.6 REPLACEB        65

6.7.7 RIGHTB        66

6.7.8 SEARCHB        66

6.8 Complex Number Functions        66

6.8.1 General        66

6.8.2 COMPLEX        66

6.8.3 IMABS        66

6.8.4 IMAGINARY        67

6.8.5 IMARGUMENT        67

6.8.6 IMCONJUGATE        67

6.8.7 IMCOS        67

6.8.8 IMCOSH         68

6.8.9 IMCOT        68

6.8.10 IMCSC        68

6.8.11 IMCSCH        68

6.8.12 IMDIV        69

6.8.13 IMEXP        69

6.8.14 IMLN        69

6.8.15 IMLOG10        69

6.8.16 IMLOG2        70

6.8.17 IMPOWER        70

6.8.18 IMPRODUCT        70

6.8.19 IMREAL        70

6.8.20 IMSIN        71

6.8.21 IMSINH        71

6.8.22 IMSEC        71

6.8.23 IMSECH        71

6.8.24 IMSQRT        72

6.8.25 IMSUB        72

6.8.26 IMSUM        72

6.8.27 IMTAN        72

6.9 Database Functions        73

6.9.1 General        73

6.9.2 DAVERAGE        73

6.9.3 DCOUNT        73

6.9.4 DCOUNTA        73

6.9.5 DGET        74

6.9.6 DMAX        74

6.9.7 DMIN        74

6.9.8 DPRODUCT        74

6.9.9 DSTDEV        75

6.9.10 DSTDEVP        75

6.9.11 DSUM        75

6.9.12 DVAR        75

6.9.13 DVARP        76

6.10 Date and Time Functions        76

6.10.1 General        76

6.10.2 DATE        76

6.10.3 DATEDIF        76

6.10.4 DATEVALUE        77

6.10.5 DAY        77

6.10.6 DAYS        77

6.10.7 DAYS360        78

6.10.8 EDATE        78

6.10.9 EOMONTH        79

6.10.10 HOUR        79

6.10.11 ISOWEEKNUM        79

6.10.12 MINUTE        80

6.10.13 MONTH        80

6.10.14 NETWORKDAYS        80

6.10.15 NOW        81

6.10.16 SECOND        81

6.10.17 TIME        81

6.10.18 TIMEVALUE        82

6.10.19 TODAY        82

6.10.20 WEEKDAY        82

6.10.21 WEEKNUM        83

6.10.22 WORKDAY        83

6.10.23 YEAR        84

6.10.24 YEARFRAC        84

6.11 External Access Functions        85

6.11.1 General        85

6.11.2 DDE        85

6.11.3 HYPERLINK        85

6.12 Financial Functions        86

6.12.1 General        86

6.12.2 ACCRINT        86

6.12.3 ACCRINTM        87

6.12.4 AMORLINC        87

6.12.5 COUPDAYBS        88

6.12.6 COUPDAYS        88

6.12.7 COUPDAYSNC        89

6.12.8 COUPNCD        89

6.12.9 COUPNUM        90

6.12.10 COUPPCD        91

6.12.11 CUMIPMT        91

6.12.12 CUMPRINC        92

6.12.13 DB        92

6.12.14 DDB        93

6.12.15 DISC        95

6.12.16 DOLLARDE        95

6.12.17 DOLLARFR        95

6.12.18 DURATION        96

6.12.19 EFFECT        96

6.12.20 FV        97

6.12.21 FVSCHEDULE        97

6.12.22 INTRATE        97

6.12.23 IPMT        98

6.12.24 IRR        98

6.12.25 ISPMT        99

6.12.26 MDURATION        99

6.12.27 MIRR        100

6.12.28 NOMINAL        100

6.12.29 NPER        101

6.12.30 NPV        101

6.12.31 ODDFPRICE        102

6.12.32 ODDFYIELD        102

6.12.33 ODDLPRICE        103

6.12.34 ODDLYIELD        103

6.12.35 PDURATION        104

6.12.36 PMT        104

6.12.37 PPMT        105

6.12.38 PRICE        105

6.12.39 PRICEDISC        106

6.12.40 PRICEMAT        106

6.12.41 PV        107

6.12.42 RATE        107

6.12.43 RECEIVED        108

6.12.44 RRI        109

6.12.45 SLN        109

6.12.46 SYD        109

6.12.47 TBILLEQ        110

6.12.48 TBILLPRICE        110

6.12.49 TBILLYIELD        111

6.12.50 VDB        111

6.12.51 XIRR        112

6.12.52 XNPV        112

6.12.53 YIELD        113

6.12.54 YIELDDISC        113

6.12.55 YIELDMAT        114

6.13 Information Functions        114

6.13.1 General        114

6.13.2 AREAS        114

6.13.3 CELL        115

6.13.4 COLUMN        116

6.13.5 COLUMNS        117

6.13.6 COUNT        117

6.13.7 COUNTA        117

6.13.8 COUNTBLANK        118

6.13.9 COUNTIF        118

6.13.10 COUNTIFS        118

6.13.11 ERROR.TYPE        119

6.13.12 FORMULA        119

6.13.13 INFO        119

6.13.14 ISBLANK        120

6.13.15 ISERR        121

6.13.16 ISERROR        121

6.13.17 ISEVEN        121

6.13.18 ISFORMULA        121

6.13.19 ISLOGICAL        122

6.13.20 ISNA        122

6.13.21 ISNONTEXT        122

6.13.22 ISNUMBER        123

6.13.23 ISODD        123

6.13.24 ISREF        123

6.13.25 ISTEXT        123

6.13.26 N        124

6.13.27 NA        124

6.13.28 NUMBERVALUE        124

6.13.29 ROW        125

6.13.30 ROWS        125

6.13.31 SHEET        125

6.13.32 SHEETS        126

6.13.33 TYPE        126

6.13.34 VALUE        127

6.14 Lookup Functions        128

6.14.1 General        128

6.14.2 ADDRESS        128

6.14.3 CHOOSE        129

6.14.4 GETPIVOTDATA        129

6.14.5 HLOOKUP        130

6.14.6 INDEX        131

6.14.7 INDIRECT        131

6.14.8 LOOKUP        132

6.14.9 MATCH        133

6.14.10 MULTIPLE.OPERATIONS        134

6.14.11 OFFSET        135

6.14.12 VLOOKUP        136

6.15 Logical Functions        136

6.15.1 General        136

6.15.2 AND        137

6.15.3 FALSE        137

6.15.4 IF        137

6.15.5 IFERROR        137

6.15.6 IFNA        138

6.15.7 NOT        138

6.15.8 OR        138

6.15.9 TRUE        139

6.15.10 XOR        139

6.16 Mathematical Functions        139

6.16.1 General        139

6.16.2 ABS        139

6.16.3 ACOS        140

6.16.4 ACOSH        140

6.16.5 ACOT        140

6.16.6 ACOTH        140

6.16.7 ASIN        141

6.16.8 ASINH        141

6.16.9 ATAN        141

6.16.10 ATAN2        142

6.16.11 ATANH        142

6.16.12 BESSELI        142

6.16.13 BESSELJ        143

6.16.14 BESSELK        143

6.16.15 BESSELY        143

6.16.16 COMBIN        143

6.16.17 COMBINA        144

6.16.18 CONVERT        144

6.16.19 COS        152

6.16.20 COSH        152

6.16.21 COT        153

6.16.22 COTH        153

6.16.23 CSC        153

6.16.24 CSCH        154

6.16.25 DEGREES        154

6.16.26 DELTA        154

6.16.27 ERF        154

6.16.28 ERFC        155

6.16.29 EUROCONVERT        155

6.16.30 EVEN        156

6.16.31 EXP        157

6.16.32 FACT        157

6.16.33 FACTDOUBLE        157

6.16.34 GAMMA        157

6.16.35 GAMMALN        158

6.16.36 GCD        158

6.16.37 GESTEP        158

6.16.38 LCM        159

6.16.39 LN        159

6.16.40 LOG        159

6.16.41 LOG10        159

6.16.42 MOD        160

6.16.43 MULTINOMIAL        160

6.16.44 ODD        160

6.16.45 PI        160

6.16.46 POWER        161

6.16.47 PRODUCT        161

6.16.48 QUOTIENT        161

6.16.49 RADIANS        161

6.16.50 RAND        162

6.16.51 RANDBETWEEN        162

6.16.52 SEC        162

6.16.53 SERIESSUM        162

6.16.54 SIGN        163

6.16.55 SIN        163

6.16.56 SINH        164

6.16.57 SECH        164

6.16.58 SQRT        164

6.16.59 SQRTPI        164

6.16.60 SUBTOTAL        165

6.16.61 SUM        165

6.16.62 SUMIF        166

6.16.63 SUMIFS        166

6.16.64 SUMPRODUCT        167

6.16.65 SUMSQ        167

6.16.66 SUMX2MY2        167

6.16.67 SUMX2PY2        167

6.16.68 SUMXMY2        168

6.16.69 TAN        168

6.16.70 TANH        168

6.17 Rounding Functions        169

6.17.1 CEILING        169

6.17.2 INT        169

6.17.3 FLOOR        169

6.17.4 MROUND        170

6.17.5 ROUND        170

6.17.6 ROUNDDOWN        170

6.17.7 ROUNDUP        171

6.17.8 TRUNC        171

6.18 Statistical Functions        171

6.18.1 General        171

6.18.2 AVEDEV        171

6.18.3 AVERAGE        172

6.18.4 AVERAGEA        172

6.18.5 AVERAGEIF        172

6.18.6 AVERAGEIFS        173

6.18.7 BETADIST        173

6.18.8 BETAINV        174

6.18.9 BINOM.DIST.RANGE        174

6.18.10 BINOMDIST        175

6.18.11 LEGACY.CHIDIST        175

6.18.12 CHISQDIST        175

6.18.13 LEGACY.CHIINV        176

6.18.14 CHISQINV        176

6.18.15 LEGACY.CHITEST        176

6.18.16 CONFIDENCE        177

6.18.17 CORREL        177

6.18.18 COVAR        178

6.18.19 CRITBINOM        178

6.18.20 DEVSQ        178

6.18.21 EXPONDIST        179

6.18.22 FDIST        179

6.18.23 LEGACY.FDIST        180

6.18.24 FINV        180

6.18.25 LEGACY.FINV        180

6.18.26 FISHER        181

6.18.27 FISHERINV        181

6.18.28 FORECAST        181

6.18.29 FREQUENCY        182

6.18.30 FTEST        182

6.18.31 GAMMADIST        182

6.18.32 GAMMAINV        183

6.18.33 GAUSS        183

6.18.34 GEOMEAN        183

6.18.35 GROWTH        184

6.18.36 HARMEAN        185

6.18.37 HYPGEOMDIST        185

6.18.38 INTERCEPT        186

6.18.39 KURT        186

6.18.40 LARGE        186

6.18.41 LINEST        187

6.18.42 LOGEST        189

6.18.43 LOGINV        191

6.18.44 LOGNORMDIST        191

6.18.45 MAX        192

6.18.46 MAXA        192

6.18.47 MEDIAN        192

6.18.48 MIN        193

6.18.49 MINA        193

6.18.50 MODE        194

6.18.51 NEGBINOMDIST        194

6.18.52 NORMDIST        194

6.18.53 NORMINV        195

6.18.54 LEGACY.NORMSDIST        195

6.18.55 LEGACY.NORMSINV        195

6.18.56 PEARSON        196

6.18.57 PERCENTILE        196

6.18.58 PERCENTRANK        197

6.18.59 PERMUT        198

6.18.60 PERMUTATIONA        198

6.18.61 PHI        199

6.18.62 POISSON        199

6.18.63 PROB        199

6.18.64 QUARTILE        200

6.18.65 RANK        200

6.18.66 RSQ        201

6.18.67 SKEW        202

6.18.68 SKEWP        202

6.18.69 SLOPE        203

6.18.70 SMALL        203

6.18.71 STANDARDIZE        204

6.18.72 STDEV        204

6.18.73 STDEVA        204

6.18.74 STDEVP        205

6.18.75 STDEVPA        205

6.18.76 STEYX        206

6.18.77 LEGACY.TDIST        206

6.18.78 TINV        207

6.18.79 TREND        207

6.18.80 TRIMMEAN        208

6.18.81 TTEST        208

6.18.82 VAR        210

6.18.83 VARA        210

6.18.84 VARP        211

6.18.85 VARPA        211

6.18.86 WEIBULL        212

6.18.87 ZTEST        212

6.19 Number Representation Conversion Functions        213

6.19.1 General        213

6.19.2 ARABIC        213

6.19.3 BASE        214

6.19.4 BIN2DEC        214

6.19.5 BIN2HEX        214

6.19.6 BIN2OCT        215

6.19.7 DEC2BIN        215

6.19.8 DEC2HEX        216

6.19.9 DEC2OCT        216

6.19.10 DECIMAL        217

6.19.11 HEX2BIN        217

6.19.12 HEX2DEC        217

6.19.13 HEX2OCT        218

6.19.14 OCT2BIN        218

6.19.15 OCT2DEC        219

6.19.16 OCT2HEX        219

6.19.17 ROMAN        219

6.20 Text Functions        221

6.20.1 General        221

6.20.2 ASC        221

6.20.3 CHAR        223

6.20.4 CLEAN        223

6.20.5 CODE        224

6.20.6 CONCATENATE        224

6.20.7 DOLLAR        224

6.20.8 EXACT        224

6.20.9 FIND        225

6.20.10 FIXED        225

6.20.11 JIS        225

6.20.12 LEFT        227

6.20.13 LEN        228

6.20.14 LOWER        228

6.20.15 MID        228

6.20.16 PROPER        229

6.20.17 REPLACE        229

6.20.18 REPT        229

6.20.19 RIGHT        230

6.20.20 SEARCH        230

6.20.21 SUBSTITUTE        230

6.20.22 T        231

6.20.23 TEXT        231

6.20.24 TRIM        231

6.20.25 UNICHAR        232

6.20.26 UNICODE        232

6.20.27 UPPER        232

7 Other Capabilities        233

7.1 General        233

7.2 Inline constant arrays        233

7.3 Inline non-constant arrays        233

7.4 Year 1583        233

8 Non-portable Features        234

8.1 General        234

8.2 Distinct Logical        234

Table of Contents Part 3

1 Introduction        8

1.1 Introduction        8

1.2 Terminology        8

1.3 Normative References        8

1.4 Non Normative References        9

1.5 Namespaces        9

2 Packages, Package Consumers and Package Producers        11

2.1 Introduction        11

2.2 Packages        11

2.2.1 OpenDocument Package        11

2.2.2 OpenDocument Extended Package        12

2.3 Producers        12

2.3.1 OpenDocument Package Producer        12

2.3.2 OpenDocument Package Extended Producer        12

2.4 OpenDocument Package Consumer        12

3 Packages        13

3.1 General        13

3.2 Manifest        13

3.3 MIME Media Type        13

3.4 Encryption        14

3.4.1 General        14

3.4.2 Encryption Process        14

3.5 Digital Signatures        15

3.6 Metadata        15

3.7 Usage of IRIs Within Packages        15

3.8 Preview Image        17

4 Manifest File        18

4.1 Introduction        18

4.2 <manifest:manifest>        18

4.3 <manifest:file-entry>        18

4.4 <manifest:encryption-data>        18

4.5 <manifest:algorithm>        19

4.6 <manifest:start-key-generation>        19

4.7 <manifest:key-derivation>        19

4.8 Manifest Attributes        20

4.8.1 manifest:algorithm-name        20

4.8.2 manifest:checksum        20

4.8.3 manifest:checksum-type        20

4.8.4 manifest:full-path        21

4.8.5 manifest:initialisation-vector        21

4.8.6 manifest:start-key-generation-name        22

4.8.7 manifest:key-size        22

4.8.8 manifest:iteration-count        22

4.8.9 manifest:key-derivation-name        23

4.8.10 manifest:media-type        23

4.8.11 manifest:preferred-view-mode        23

4.8.12 manifest:salt        24

4.8.13 manifest:size        24

4.8.14 manifest:version        24

5 Digital Signatures File        26

5.1 Introduction        26

5.2 <dsig:document-signatures>        26

5.3 <ds:Signature>        26

5.4 Digital Signatures Attributes        28

5.4.1 dsig:version        28

6 Metadata Manifest Files        29

6.1 General        29

6.2 pkg:Document        29

6.3 pkg:File        29

6.4 pkg:MetadataFile        29

6.5 pkg:Element        29

6.6 pkg:hasPart        29

6.7 pkg:mimeType        30

7 Datatypes        31

7.1 Introduction        31

7.2 W3C Schema Datatypes        31

7.3 Other Datatypes        31

7.3.1 namespacedToken        31

Appendix A. Schemas        32

A.1. OpenDocument Manifest Schema        32

A.2. OpenDocument Digital Signature Schema        32

Appendix B. OpenDocument Metadata Manifest Ontology        33

Appendix C. Zip File Structure (Non normative)        34

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

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

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. (C1)A conforming OpenDocument Document shall meet the requirements defined in part 1  section 2.2.1 and chapters 3 to 20 for OpenDocument documents.. 

  2. (C2)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. (C3)A conforming OpenDocument Text Document shall meet the requirements defined in part 1 section 2.2.3 and chapters 3 to 20 for OpenDocument Text documents. 

  4. (C4)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. (C5)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. (C6)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. (C7)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. (C8)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. (C9)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. (C10)A conforming OpenDocument Database Front End Document shall meet the requirements defined in part 1 section 2.2.10 and chapters 3 to 20 for OpenDocument Database Front End documents. 

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

  12. (C12)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. (C13)A Conforming OpenDocument Consumer shall meet the requirements defined in part 1 section 2.4 and chapters 3 to 20 for OpenDocument consumers. 

  14. (C14)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. (C15)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. (C16)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. (C17)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. (C18)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. (C19)A conforming OpenDocument Package shall meet the requirements defined in part 3 section 2.2.1 and chapters 3 to 7 for OpenDocument packages. 

  20. (C20)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. (C21)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. (C22)A Conforming OpenDocument Package Extended Producer shall meet the requirements defined in part 3 section 2.3.2 and chapters 3 to 7 for OpenDocument package extended producers. 

  23. (C23)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. Appendix A. Changes From Previous Specification Versions (Non Normative) 

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

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

  1. Appendix B. Acknowledgments (Non Normative) 

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

Participants:

Chieko Asakawa, IBM

Waldo Bastian, Intel Corporation

Thorsten Behrens, Novell

Nathaniel Borenstein, IBM

Michael Brauer, Oracle Corporation

Pete Brunet, IBM

Manuel Cano
Suresh Chande, Nokia Corporation

Robin Cover, 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