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-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 1 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 2 of 102 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.oasisopen.org/office/v1.2/os/OpenDocument-v1.2-os.html. OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 3 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 4 of 102 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. OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 5 of 102 Table of Contents 1 Introduction................................................................................................................................ 96 1.1 Scope.................................................................................................................................. 96 1.2 Terminology......................................................................................................................... 96 1.3 Normative References........................................................................................................ 96 1.4 Non Normative References................................................................................................. 97 2 Conformance............................................................................................................................. 98 Appendix A. Changes From Previous Specification Versions (Non Normative)..........................100 A.1. Changes from “Open Document Format for Office Applications (OpenDocument) v1.1”.....100 Appendix B. Acknowledgments (Non Normative).......................................................................101 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 6 of 102 3 Document Structure................................................................................................................... 90 3.1 Document Representation ................................................................................................. 90 3.1.1 General........................................................................................................................ 90 3.1.2 (Single OpenDocument XML Files)................................................90 3.1.3 Package OpenDocument Files....................................................................................90 3.1.3.1 General................................................................................................................................. 90 3.1.3.2 ...................................................................................................90 3.1.3.3 ......................................................................................................91 3.1.3.4 .......................................................................................................91 3.1.3.5 ..................................................................................................91 3.1.4 Summary of Document Representation.......................................................................91 3.2 ...................................................................................................................... 92 3.3 ...................................................................................................................... 92 3.4 ........................................................................................................................ 93 3.5 .................................................................................................................. 93 3.6 .......................................................................................................... 93 3.7 .......................................................................................................... 94 3.8 ...................................................................................................................... 94 3.9 .................................................................................................................... 94 3.10 ................................................................................................................ 95 3.10.1 General...................................................................................................................... 95 3.10.2 ............................................................................................ 95 3.10.3 .................................................................................................. 95 3.10.4 .............................................................................96 3.10.5 .................................................................................96 3.10.6 ..............................................................................96 3.11 Cursor Position Setting...................................................................................................... 96 3.12 .................................................................................................................. 97 3.13 .................................................................................................................... 97 3.14 ..................................................................................................... 97 3.15 Styles................................................................................................................................ 97 3.15.1 General...................................................................................................................... 97 3.15.2 ............................................................................................................ 98 3.15.3 ........................................................................................... 98 3.15.4 ................................................................................................ 98 3.16 Document Signatures....................................................................................................... 99 3.17 Foreign Elements and Attributes.......................................................................................99 3.18 White Space Processing and EOL Handling...................................................................100 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 7 of 102 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 ...............................................................................................................103 4.3.2.2 ............................................................................................................................. 103 4.3.2.3 .................................................................................................................103 4.3.2.4 ....................................................................................................................... 104 4.3.2.5 .................................................................................................................104 4.3.2.6 ..........................................................................................................104 4.3.2.7 ....................................................................................................................... 104 4.3.2.8 ..............................................................................................................104 4.3.2.9 .........................................................................................................105 4.3.2.10 .......................................................................................................................... 105 4.3.2.11 .............................................................................................................105 4.3.2.12 ...............................................................................................................105 4.3.2.13 ..........................................................................................................106 4.3.2.14 .............................................................................................106 4.3.2.15 .................................................................................................................. 106 4.3.2.16 ......................................................................................................106 4.3.2.17 ...................................................................................................107 4.3.2.18 ...............................................................................................107 4.3.3 .................................................................................................. 107 5 Text Content............................................................................................................................. 108 5.1 Headings, Paragraphs and Basic Text Structure...............................................................108 5.1.1 General...................................................................................................................... 108 5.1.2 ...................................................................................................................... 108 5.1.3 ...................................................................................................................... 109 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 8 of 102 5.2 ....................................................................................................... 111 5.2.1 General...................................................................................................................... 111 5.2.2 ................................................................................................................ 111 5.3 Lists................................................................................................................................... 111 5.3.1 .................................................................................................................... 111 5.3.2 Default List Style ....................................................................................................... 112 5.3.3 ....................................................................................................... 112 5.3.4 ............................................................................................................ 112 5.3.5 List Item Style Rules.................................................................................................. 113 5.3.6 ......................................................................................113 5.3.7 Numbered Paragraph Style Rules..............................................................................113 5.4 .................................................................................................................... 114 5.4.1 General...................................................................................................................... 114 5.4.2 ................................................................................................. 115 5.5 Change Tracking............................................................................................................... 115 5.5.1 ............................................................................................. 115 5.5.2 ............................................................................................... 115 5.5.3 .......................................................................................................... 116 5.5.4 ........................................................................................................... 116 5.5.5 ................................................................................................. 117 5.5.6 .................................................................................................. 117 5.5.7 Change Marks............................................................................................................ 117 5.5.7.1 General............................................................................................................................... 117 5.5.7.2 .............................................................................................................118 5.5.7.3 ..............................................................................................................118 5.5.7.4 ..................................................................................................................... 118 5.6 ...................................................................................................... 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 ...................................................................................................................... 121 6.1.4 ................................................................................................................... 121 6.1.5 ........................................................................................................ 121 6.1.6 Soft Hyphens, Hyphens, and Non-breaking Spaces..................................................121 6.1.7 ................................................................................................................ 122 6.1.8 ...................................................................................................................... 123 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 9 of 102 6.1.9 ................................................................................................................ 124 6.1.10 ......................................................................................................... 125 6.2 Bookmarks and References.............................................................................................. 126 6.2.1 Bookmarks................................................................................................................ 126 6.2.1.1 General............................................................................................................................... 126 6.2.1.2 .................................................................................................................126 6.2.1.3 .........................................................................................................126 6.2.1.4 ..........................................................................................................126 6.2.2 References................................................................................................................ 127 6.2.2.1 General............................................................................................................................... 127 6.2.2.2 ........................................................................................................127 6.2.2.3 ................................................................................................127 6.2.2.4 .................................................................................................128 6.3 Notes................................................................................................................................ 128 6.3.1 General...................................................................................................................... 128 6.3.2 ................................................................................................................. 128 6.3.3 .................................................................................................... 128 6.3.4 ........................................................................................................ 128 6.4 ........................................................................................................................ 129 6.4.1 General...................................................................................................................... 129 6.4.2 ........................................................................................................ 129 6.4.3 .......................................................................................................... 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 ................................................................................................................. 132 7.3.3 ................................................................................................................. 133 7.3.4 .................................................................................................. 133 7.3.5 ........................................................................................... 133 7.3.6 Subsequent Author Fields.......................................................................................... 134 7.3.6.1 General............................................................................................................................... 134 7.3.6.2 ......................................................................................................134 7.3.6.3 ......................................................................................................134 7.3.6.4 ..........................................................................................................134 7.3.6.5 ...............................................................................................................135 7.3.6.6 ........................................................................................................135 7.3.6.7 ............................................................................................................135 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 10 of 102 7.3.6.8 ..............................................................................................135 7.3.6.9 ................................................................................................................136 7.3.6.10 ....................................................................................................136 7.3.6.11 ................................................................................................136 7.3.6.12 .........................................................................................................136 7.3.6.13 .............................................................................................................137 7.3.6.14 ................................................................................................137 7.3.6.15 .......................................................................................................137 7.3.6.16 .......................................................................................137 7.3.7 Author Fields.............................................................................................................. 138 7.3.7.1 ............................................................................................................138 7.3.7.2 ...........................................................................................................138 7.3.8 ............................................................................................................ 138 7.3.9 ......................................................................................................... 139 7.3.10 .............................................................................................. 139 7.3.11 ................................................................................................... 139 7.4 Variable Fields.................................................................................................................. 139 7.4.1 General...................................................................................................................... 139 7.4.2 .................................................................................................. 140 7.4.3 ................................................................................................... 140 7.4.4 ..................................................................................................... 141 7.4.5 ..................................................................................................... 141 7.4.6 .................................................................................................. 141 7.4.7 ............................................................................................... 142 7.4.8 ................................................................................................. 142 7.4.9 ................................................................................................... 142 7.4.10 .............................................................................................. 142 7.4.11 ............................................................................................. 143 7.4.12 .............................................................................................. 143 7.4.13 ...................................................................................................... 143 7.4.14 .................................................................................................... 144 7.4.15 ....................................................................................................... 144 7.5 Metadata Fields................................................................................................................ 144 7.5.1 General...................................................................................................................... 144 7.5.2 ................................................................................................... 144 7.5.3 ................................................................................................... 145 7.5.4 ................................................................................................... 145 7.5.5 ...................................................................................................... 145 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 11 of 102 7.5.6 .................................................................................................... 146 7.5.7 ......................................................................................................... 146 7.5.8 ......................................................................................................... 146 7.5.9 ........................................................................................................ 146 7.5.10 ................................................................................................................ 147 7.5.11 ........................................................................................................... 147 7.5.12 ....................................................................................................... 147 7.5.13 ................................................................................................ 148 7.5.14 ............................................................................................. 148 7.5.15 ........................................................................................... 148 7.5.16 .......................................................................................... 148 7.5.17 ........................................................................................................... 149 7.5.18 Document Statistics Fields.......................................................................................149 7.5.18.1 General.............................................................................................................................149 7.5.18.2 .............................................................................................................149 7.5.18.3 ....................................................................................................149 7.5.18.4 .............................................................................................................150 7.5.18.5 ......................................................................................................150 7.5.18.6 .............................................................................................................150 7.5.18.7 ...........................................................................................................151 7.5.18.8 ...........................................................................................................151 7.5.19 ...................................................................................................... 151 7.6 Database Fields................................................................................................................ 152 7.6.1 General...................................................................................................................... 152 7.6.2 ......................................................................................153 7.6.3 ............................................................................................. 153 7.6.4 ................................................................................................. 153 7.6.5 ........................................................................................ 154 7.6.6 .....................................................................................154 7.6.7 ............................................................................................... 154 7.7 More Fields....................................................................................................................... 155 7.7.1 Page Variable Fields.................................................................................................. 155 7.7.1.1 General............................................................................................................................... 155 7.7.1.2 .....................................................................................................155 7.7.1.3 .....................................................................................................155 7.7.2 ..................................................................................................... 155 7.7.3 ................................................................................................ 156 7.7.4 ...................................................................................................... 156 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 12 of 102 7.7.5 .................................................................................................. 156 7.7.6 .................................................................................................. 157 7.7.7 ........................................................................................................... 157 7.7.8 ................................................................................................... 157 7.7.9 ............................................................................................................... 158 7.7.10 .............................................................................................. 158 7.7.11 .......................................................................................... 158 7.7.12 ............................................................................................. 159 7.7.13 ........................................................................................................ 159 7.7.14 (deprecated)............................................................................159 8 Text Indexes............................................................................................................................. 161 8.1 Index Marks...................................................................................................................... 161 8.1.1 General...................................................................................................................... 161 8.1.2 ................................................................................................. 161 8.1.3 .................................................................................................. 161 8.1.4 .......................................................................................................... 162 8.1.5 ......................................................................................162 8.1.6 .......................................................................................162 8.1.7 .............................................................................................. 162 8.1.8 ..........................................................................163 8.1.9 ...........................................................................163 8.1.10 ................................................................................163 8.1.11 .......................................................................................... 163 8.2 Index Structure.................................................................................................................. 164 8.2.1 General...................................................................................................................... 164 8.2.2 ...................................................................................................... 164 8.2.3 ........................................................................................................ 165 8.3 ...................................................................................................... 165 8.3.1 General...................................................................................................................... 165 8.3.2 ...................................................................................166 8.3.3 .......................................................................166 8.4 ..................................................................................................... 166 8.4.1 General...................................................................................................................... 166 8.4.2 ..................................................................................167 8.4.3 ......................................................................167 8.5 ............................................................................................................. 167 8.5.1 General...................................................................................................................... 167 8.5.2 .......................................................................................... 168 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 13 of 102 8.5.3 ..............................................................................168 8.6 ............................................................................................................ 168 8.6.1 General...................................................................................................................... 168 8.6.2 ........................................................................................ 169 8.6.3 .............................................................................169 8.7 .............................................................................................................. 169 8.7.1 General...................................................................................................................... 169 8.7.2 ........................................................................................... 170 8.7.3 ...............................................................................170 8.8 .................................................................................................. 170 8.8.1 General...................................................................................................................... 170 8.8.2 ...............................................................................171 8.8.3 ....................................................................171 8.8.4 ...................................................................171 8.9 ............................................................................................................ 172 8.9.1 General...................................................................................................................... 172 8.9.2 ......................................................................................... 172 8.9.3 .............................................................................172 8.10 .............................................................................................. 173 8.11 ................................................................................................ 173 8.12 ............................................................................................... 173 8.13 Index Template Entries................................................................................................... 174 8.13.1 .......................................................................................174 8.13.2 ............................................................................................. 174 8.13.3 ..............................................................................174 8.13.4 ........................................................................................... 174 8.13.5 ................................................................................175 8.13.6 ......................................................................................175 8.13.7 .....................................................................................175 8.13.8 ......................................................................................176 9 Tables....................................................................................................................................... 177 9.1 Basic Tables...................................................................................................................... 177 9.1.1 General...................................................................................................................... 177 9.1.2 .............................................................................................................. 177 9.1.3 ....................................................................................................... 178 9.1.4 ....................................................................................................... 178 9.1.5 .......................................................................................... 178 9.1.6 ................................................................................................. 179 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 14 of 102 9.1.7 ......................................................................................... 179 9.1.8 ..................................................................................................... 180 9.1.9 ............................................................................................. 180 9.1.10 .....................................................................................180 9.1.11 .................................................................................181 9.1.12 ............................................................................................. 181 9.1.13 .............................................................................................................. 181 9.1.14 ............................................................................................................ 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 .................................................................................................. 183 9.2.7 ........................................................................................................ 184 9.2.8 .......................................................................................................... 184 9.3 Advanced Table Cells........................................................................................................ 185 9.3.1 .......................................................................................... 185 9.3.2 ....................................................................................................... 185 9.3.3 ....................................................................................................... 185 9.3.4 .......................................................................................... 185 9.4 Spreadsheet Document Content.......................................................................................186 9.4.1 .......................................................................................186 9.4.2 ........................................................................................................ 186 9.4.3 ......................................................................................................... 186 9.4.4 ........................................................................................ 187 9.4.5 .......................................................................................... 187 9.4.6 ............................................................................................... 187 9.4.7 .............................................................................................. 188 9.4.8 ................................................................................................... 188 9.4.9 .................................................................................................... 188 9.4.10 ................................................................................................ 189 9.4.11 .....................................................................................189 9.4.12 .............................................................................................. 189 9.4.13 ......................................................................................189 9.4.14 ......................................................................................... 190 9.4.15 ........................................................................................... 190 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 15 of 102 9.4.16 ...................................................................................190 9.4.17 ................................................................................191 9.4.18 ...............................................................................191 9.4.19 .............................................................................................................. 191 9.4.20 ......................................................................................................... 191 9.4.21 .............................................................................................. 192 9.4.22 .................................................................................................. 192 9.4.23 ................................................................................................ 192 9.4.24 ................................................................................................ 192 9.5 Filters................................................................................................................................ 193 9.5.1 General...................................................................................................................... 193 9.5.2 ............................................................................................................... 193 9.5.3 ........................................................................................................ 193 9.5.4 ........................................................................................................... 193 9.5.5 ................................................................................................ 193 9.5.6 ................................................................................................. 194 9.6 Data Pilot Tables............................................................................................................... 194 9.6.1 General...................................................................................................................... 194 9.6.2 ............................................................................................ 195 9.6.3 .............................................................................................. 195 9.6.4 Data Pilot Table Source............................................................................................. 195 9.6.5 .......................................................................................... 195 9.6.6 .............................................................................................. 196 9.6.7 ............................................................................................... 196 9.6.8 ............................................................................................... 196 9.6.9 ........................................................................................ 197 9.6.10 .......................................................................................197 9.6.11 .....................................................................................197 9.6.12 .......................................................................................197 9.6.13 ..................................................................................197 9.6.14 .......................................................................................198 9.6.15 ....................................................................................198 9.6.16 .............................................................................198 9.6.17 ......................................................................................... 198 9.6.18 ........................................................................................... 199 9.6.19 ............................................................................199 9.7 ........................................................................................................ 199 9.8 ............................................................................................................... 200 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 16 of 102 9.9 Change Tracking in Spreadsheets....................................................................................200 9.9.1 General ..................................................................................................................... 200 9.9.2 ........................................................................................... 200 9.9.3 ........................................................................................................ 200 9.9.4 ................................................................................................ 201 9.9.5 .................................................................................................. 201 9.9.6 ....................................................................................................... 201 9.9.7 ......................................................................................201 9.9.8 ............................................................................................ 202 9.9.9 ......................................................................................................... 202 9.9.10 ........................................................................................................ 202 9.9.11 ........................................................................................... 202 9.9.12 ........................................................................................ 203 9.9.13 ................................................................................................... 203 9.9.14 .................................................................................203 9.9.15 ..................................................................................203 9.9.16 ................................................................................204 9.9.17 .....................................................................................204 9.9.18 ................................................................................................ 204 9.9.19 ...................................................................................................... 204 10 Graphic Content..................................................................................................................... 206 10.1 General........................................................................................................................... 206 10.2 Enhanced Page Features for Graphical Applications......................................................206 10.2.1 ........................................................................................... 206 10.2.2 ...................................................................................................... 206 10.2.3 ............................................................................................................ 207 10.2.4 ............................................................................................................ 207 10.2.5 ...................................................................................................... 208 10.3 Drawing Shapes.............................................................................................................. 208 10.3.1 General.................................................................................................................... 208 10.3.2 .............................................................................................................. 208 10.3.3 .............................................................................................................. 208 10.3.4 ........................................................................................................ 209 10.3.5 ....................................................................................................... 209 10.3.6 ........................................................................................... 210 10.3.7 ............................................................................................................. 210 10.3.8 ............................................................................................................ 211 10.3.9 .......................................................................................................... 211 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 17 of 102 10.3.10 .................................................................................................. 212 10.3.11 ....................................................................................................... 213 10.3.12 .................................................................................................... 213 10.3.13 ....................................................................................................... 214 10.3.14 ......................................................................................... 215 10.3.15 ................................................................................................................ 215 10.3.16 .................................................................................................. 216 10.3.17 .............................................................................................................. 216 10.3.18 ............................................................................................................ 216 10.3.19 .......................................................................................... 217 10.4 Frames............................................................................................................................ 217 10.4.1 General.................................................................................................................... 217 10.4.2 .......................................................................................................... 218 10.4.3 ....................................................................................................... 218 10.4.4 .......................................................................................................... 219 10.4.5 ................................................................................................. 219 10.4.6 Objects.................................................................................................................... 219 10.4.6.1 General.............................................................................................................................219 10.4.6.2 ...................................................................................................................220 10.4.6.3 .............................................................................................................220 10.4.7 .......................................................................................................... 220 10.4.8 .......................................................................................................... 221 10.4.9 .......................................................................................................... 221 10.4.10 ............................................................................................ 221 10.4.11 Contours................................................................................................................ 222 10.4.11.1 General...........................................................................................................................222 10.4.11.2 .................................................................................................222 10.4.11.3 .......................................................................................................222 10.4.12 ................................................................................................................ 222 10.4.13 Client Side Image Maps......................................................................................... 223 10.4.13.1 General........................................................................................................................... 223 10.4.13.2 .........................................................................................................223 10.4.13.3 ...................................................................................................223 10.4.13.4 ..........................................................................................................224 10.4.13.5 ......................................................................................................224 10.5 3D Shapes...................................................................................................................... 224 10.5.1 General.................................................................................................................... 224 10.5.2 ........................................................................................................... 225 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 18 of 102 10.5.3 .............................................................................................................. 225 10.5.4 ............................................................................................................. 225 10.5.5 ......................................................................................................... 226 10.5.6 ........................................................................................................ 226 10.5.7 ........................................................................................................... 226 10.6 Custom Shape................................................................................................................ 227 10.6.1 ............................................................................................. 227 10.6.2 ....................................................................................227 10.6.3 ......................................................................................................... 228 10.7 Presentation Shapes....................................................................................................... 228 10.8 Presentation Animations................................................................................................. 228 10.8.1 .......................................................................................228 10.8.2 .............................................................................................. 229 10.8.3 .....................................................................................229 10.8.4 ......................................................................................... 229 10.8.5 ......................................................................................230 10.8.6 .......................................................................................... 230 10.8.7 .................................................................................................. 230 10.8.8 ................................................................................................. 230 10.8.9 ..............................................................................231 10.9 SMIL Presentation Animations........................................................................................ 231 10.9.1 General.................................................................................................................... 231 10.9.2 ..................................................................................231 10.9.3 Presentation Document Content..............................................................................232 10.9.3.1 .....................................................................................................232 10.9.3.2 .............................................................................................232 10.9.3.3 .......................................................................................................232 10.9.3.4 ...............................................................................................233 10.9.3.5 .................................................................................................233 10.9.3.6 ..........................................................................................233 10.9.3.7 ....................................................................................................233 10.9.3.8 ........................................................................................................234 11 Chart Content......................................................................................................................... 235 11.1 ................................................................................................................... 235 11.2 Title, Subtitle and Footer................................................................................................. 235 11.2.1 .............................................................................................................. 235 11.2.2 ........................................................................................................ 235 11.2.3 ........................................................................................................... 236 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 19 of 102 11.3 ................................................................................................................ 236 11.4 ............................................................................................................. 237 11.5 3D Plot Area.................................................................................................................... 237 11.6 ..................................................................................................................... 237 11.7 .................................................................................................................... 237 11.8 ..................................................................................................................... 238 11.9 ........................................................................................................... 238 11.10 ................................................................................................................... 238 11.11 ................................................................................................................ 238 11.12 ............................................................................................................. 239 11.13 ......................................................................................................... 239 11.14 ......................................................................................................... 239 11.15 ...................................................................................................... 240 11.16 ................................................................................................... 240 11.17 .............................................................................................. 240 11.18 ........................................................................................................... 240 11.19 ............................................................................................ 241 11.20 ............................................................................................. 241 11.21 ................................................................................................ 241 12 Database Front-end Document Content.................................................................................242 12.1 ........................................................................................................... 242 12.2 ............................................................................................................ 242 12.3 ..................................................................................................... 242 12.4 .............................................................................................. 242 12.5 ............................................................................................... 243 12.6 ..................................................................................................... 243 12.7 .............................................................................................. 243 12.8 ....................................................................................................................... 243 12.9 ........................................................................................................ 244 12.10 ..................................................................................................... 244 12.11 ............................................................................................................... 244 12.12 ........................................................................................................ 244 12.13 ........................................................................................................ 245 12.14 ......................................................................................................... 245 12.15 ............................................................................245 12.16 ............................................................................................................. 245 12.17 ................................................................................................. 246 12.18 ................................................................................................ 246 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 20 of 102 12.19 ................................................................................................. 246 12.20 ..................................................................................................... 246 12.21 ............................................................................................................. 247 12.22 ............................................................................................ 247 12.23 .............................................................................................. 247 12.24 .....................................................................................247 12.25 Forms and Reports....................................................................................................... 248 12.25.1 General.................................................................................................................. 248 12.25.2 ............................................................................................................ 248 12.25.3 .......................................................................................................... 248 12.25.4 ....................................................................................248 12.25.5 .................................................................................................... 248 12.26 ................................................................................................................. 249 12.27 .................................................................................................... 249 12.28 .................................................................................................................... 249 12.29 ................................................................................................... 249 12.30 ..................................................................................................... 250 12.31 ......................................................................................................... 250 12.32 ........................................................................................... 250 12.33 ............................................................................................. 250 12.34 ............................................................................................................... 251 12.35 ................................................................................................................. 251 12.36 ................................................................................................. 251 12.37 .................................................................................................... 251 12.38 ...................................................................................................... 252 12.39 ................................................................................................ 252 12.40 .................................................................................................. 252 12.41 ..................................................................................................................... 252 12.42 ....................................................................................................................... 253 12.43 ......................................................................................................... 253 12.44 .......................................................................................................... 253 12.45 .................................................................................................................. 253 12.46 .................................................................................................................... 253 12.47 ...................................................................................................... 254 12.48 ....................................................................................................... 254 13 Form Content......................................................................................................................... 255 13.1 General........................................................................................................................... 255 13.2 ................................................................................................................. 255 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 21 of 102 13.3 .................................................................................................................... 255 13.4 .............................................................................................................. 256 13.5 Controls.......................................................................................................................... 256 13.5.1 General.................................................................................................................... 256 13.5.2 .............................................................................................................. 256 13.5.3 ....................................................................................................... 257 13.5.4 ..................................................................................................... 257 13.5.5 ................................................................................................................ 258 13.5.6 .............................................................................................. 258 13.5.7 ........................................................................................................ 258 13.5.8 ............................................................................................................. 259 13.5.9 ............................................................................................................. 259 13.5.10 .................................................................................................... 259 13.5.11 .................................................................................................. 260 13.5.12 ........................................................................................................... 260 13.5.13 ........................................................................................................ 260 13.5.14 ......................................................................................................... 260 13.5.15 ........................................................................................................ 261 13.5.16 ........................................................................................................ 261 13.5.17 ................................................................................................... 261 13.5.18 .......................................................................................................... 262 13.5.19 ......................................................................................................... 262 13.5.20 .............................................................................................. 262 13.5.21 ........................................................................................................ 263 13.5.22 ............................................................................................................ 263 13.5.23 ....................................................................................................... 263 13.5.24 ............................................................................................... 264 13.5.25 ........................................................................................... 264 13.6 Event Listeners............................................................................................................... 264 13.7 ............................................................................................................ 266 13.8 .............................................................................................................. 266 13.9 ......................................................................................................... 266 13.10 ........................................................................................................... 267 14 Common Content................................................................................................................... 268 14.1 .......................................................................................................... 268 14.2 .................................................................................................. 268 14.3 .......................................................................................................... 268 14.4 Event Listener Tables...................................................................................................... 269 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 22 of 102 14.4.1 General.................................................................................................................... 269 14.4.2 .............................................................................................. 269 14.4.3 Event Types............................................................................................................. 269 14.4.4 Macro Name and Location.......................................................................................269 14.5 ................................................................................................................... 270 14.6 DDE Connections........................................................................................................... 270 14.6.1 General.................................................................................................................... 270 14.6.2 ....................................................................................270 14.6.3 ......................................................................................270 14.6.4 ....................................................................................................... 271 14.6.5 ................................................................................................. 271 15 SMIL Animations.................................................................................................................... 272 15.1 General........................................................................................................................... 272 15.2 Basic Animation Elements............................................................................................... 272 15.2.1 General ................................................................................................................... 272 15.2.2 ....................................................................................................... 272 15.2.3 .......................................................................................272 15.2.4 ............................................................................................................... 273 15.2.5 ............................................................................................ 273 15.2.6 .............................................................................................. 273 15.2.7 ............................................................................................. 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 .............................................................................................................. 274 15.4.3 .............................................................................................................. 275 15.4.4 .......................................................................................................... 275 15.5 .................................................................................................................. 276 15.6 Animation Command Elements.......................................................................................276 15.6.1 .................................................................................................... 276 15.6.2 ......................................................................................................... 277 16 Styles..................................................................................................................................... 278 16.1 General........................................................................................................................... 278 16.2 .................................................................................................................... 278 16.3 .................................................................................................................... 279 16.4 ........................................................................................................ 280 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 23 of 102 16.5 ......................................................................................................... 280 16.6 ........................................................................................................ 280 16.7 .......................................................................................................... 280 16.8 ............................................................................................. 281 16.9 ....................................................................................................... 281 16.10 .............................................................................................................. 282 16.11 ................................................................................................................. 282 16.12 ........................................................................................................ 283 16.13 .......................................................................................................... 283 16.14 .......................................................................................................... 283 16.15 .................................................................................................... 284 16.16 ....................................................................................................... 284 16.17 .................................................................................................... 284 16.18 .................................................................................................. 285 16.19 Cell Styles..................................................................................................................... 285 16.19.1 General.................................................................................................................. 285 16.19.2 ..................................................................................................... 285 16.19.3 ..................................................................................................... 286 16.19.4 ............................................................................................... 286 16.19.5 ............................................................................................... 286 16.19.6 .......................................................................................................... 286 16.19.7 ................................................................................................. 286 16.19.8 ................................................................................................... 287 16.19.9 ............................................................................................ 287 16.19.10 ........................................................................................... 287 16.20 ...................................................................................................... 287 16.21 ............................................................................................................ 288 16.22 ....................................................................................................... 288 16.23 ................................................................................................... 289 16.24 ........................................................................................................ 289 16.25 ....................................................................................................... 289 16.26 .................................................................................................. 289 16.27 Data Styles.................................................................................................................... 289 16.27.1 General.................................................................................................................. 289 16.27.2 ......................................................................................... 290 16.27.3 ................................................................................................. 290 16.27.4 .....................................................................................290 16.27.5 ..................................................................................290 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 24 of 102 16.27.6 .................................................................................................. 291 16.27.7 .......................................................................................291 16.27.8 ...................................................................................291 16.27.9 ...................................................................................292 16.27.10 ............................................................................................ 292 16.27.11 ...................................................................................................... 292 16.27.12 ................................................................................................. 293 16.27.13 .................................................................................................... 293 16.27.14 ...................................................................................................... 293 16.27.15 ........................................................................................ 293 16.27.16 .......................................................................................294 16.27.17 ................................................................................................ 294 16.27.18 ............................................................................................ 294 16.27.19 .................................................................................................. 294 16.27.20 ............................................................................................... 295 16.27.21 .............................................................................................. 295 16.27.22 ................................................................................................ 295 16.27.23 ......................................................................................295 16.27.24 ............................................................................................... 296 16.27.25 ............................................................................................. 296 16.27.26 ...................................................................................................... 296 16.27.27 ......................................................................................... 296 16.27.28 ......................................................................................... 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 ........................................................................298 16.29.2 .............................................................................299 16.29.3 .....................................................................................299 16.29.4 .................................................................299 16.29.5 .............................................................299 16.29.6 ...........................................................................300 16.29.7 ....................................................................................................... 300 16.30 .............................................................................................................. 300 16.31 ............................................................................................ 301 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 25 of 102 16.32 ........................................................................................ 301 16.33 ........................................................................................... 301 16.34 ........................................................................................................ 302 16.35 ................................................................................................ 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 ..................................................................................................... 303 16.40.2 .............................................................................................. 304 16.40.3 .............................................................................................. 304 16.40.4 ............................................................................................................. 305 16.40.5 ......................................................................................................... 305 16.40.6 ................................................................................................... 305 16.40.7 ....................................................................................................... 305 16.40.8 ...................................................................................................... 306 16.40.9 ............................................................................................... 306 16.41 ..................................................................................307 16.42 ........................................................................................... 307 16.43 Chart Styles.................................................................................................................. 307 17 Formatting Elements.............................................................................................................. 308 17.1 General........................................................................................................................... 308 17.2 ........................................................................................ 308 17.3 .............................................................................................. 308 17.4 ........................................................................................................ 309 17.5 .....................................................................................309 17.6 .......................................................................................... 310 17.7 ............................................................................................................. 310 17.8 ............................................................................................................... 310 17.9 .............................................................................................................. 311 17.10 .................................................................................................. 311 17.11 .............................................................................................. 311 17.12 ............................................................................................................ 311 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 26 of 102 17.13 .............................................................................................................. 312 17.14 ....................................................................................................... 312 17.15 ................................................................................................. 312 17.16 ....................................................................................313 17.17 .......................................................................................... 313 17.18 .......................................................................................... 313 17.19 ............................................................................................ 314 17.20 ...................................................................................314 17.21 ............................................................................................. 314 17.22 ................................................................................................ 316 17.23 ................................................................................................... 317 17.24 ................................................................................................. 317 17.25 ...................................................................................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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 27 of 102 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 , .................................................................................329 19.15.2 ............................................................................................................ 336 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 28 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 29 of 102 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 .......................................................................................................... 351 19.70.3 ........................................................................................... 351 19.70.4 .................................................................................................... 352 19.70.5 ....................................................................................352 19.70.6 ............................................................................................................. 352 19.70.7 ................................................................................................ 352 19.70.8 ................................................................................................................ 352 19.70.9 ................................................................................................... 352 19.70.10 ........................................................................................................... 352 19.70.11 ........................................................................................... 353 19.70.12 ............................................................................................ 353 19.70.13 ....................................................................................353 19.70.14 ................................................................................................ 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 30 of 102 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 .......................................................................................................... 355 19.80.3 ............................................................................................................. 355 19.80.4 ......................................................................................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 ................................................................................................................ 357 19.85.3 ............................................................................................ 357 19.85.4 .............................................................................................. 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 ................................................................................................... 361 19.99.3 ......................................................................................................... 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 31 of 102 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 ....................................................................................................... 367 19.122.3 .............................................................................................. 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 ................................................................................................. 370 19.133.3 ................................................................................................... 370 19.133.4 ....................................................................................................... 370 19.133.5 .................................................................................................... 370 19.133.6 ..................................................................................................... 371 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 32 of 102 19.133.7 ............................................................................................. 371 19.133.8 ............................................................................................ 371 19.133.9 ............................................................................................ 371 19.134 draw:distance.............................................................................................................. 371 19.134.1 General................................................................................................................ 371 19.134.2 ....................................................................................................... 371 19.134.3 ............................................................................................. 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 33 of 102 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 ................................................................................................ 390 19.187.3 , , , , , , , , , , , , , , , , , , , , , and ................................................................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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 34 of 102 19.197.1 General................................................................................................................ 394 19.197.2 .................................................................................................... 394 19.197.3 ....................................................................................................... 394 19.197.4 ................................................................................................ 394 19.197.5 ..................................................................................................... 394 19.197.6 ......................................................................................... 395 19.197.7 ...................................................................................................... 395 19.197.8 .................................................................................................. 395 19.197.9 ................................................................................................. 395 19.197.10 ..................................................................................................... 395 19.197.11 ............................................................................................................ 395 19.197.12 ................................................................................................. 396 19.197.13 ..................................................................................................... 396 19.197.14 ...................................................................................................... 396 19.197.15 ........................................................................................................ 396 19.197.16 ................................................................................................... 396 19.197.17 ................................................................................................ 396 19.197.18 ................................................................................................... 397 19.197.19 ...................................................................................................... 397 19.197.20 .....................................................................................397 19.197.21 .................................................................................................... 397 19.197.22 ....................................................................................................... 397 19.197.23 ................................................................................................. 397 19.197.24 .................................................................................................. 398 19.197.25 ........................................................................................................ 398 19.197.26 .....................................................................................398 19.197.27 ........................................................................................... 398 19.197.28 (deprecated).......................................................................398 19.197.29 .......................................................................................... 398 19.197.30 .......................................................................................... 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 35 of 102 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 ................................................................................................... 404 19.218.3 ....................................................................................................... 405 19.218.4 ..................................................................................................... 405 19.218.5 ............................................................................................. 405 19.219 draw:style-name.......................................................................................................... 406 19.219.1 General................................................................................................................ 406 19.219.2 ......................................................................................................... 406 19.219.3 .................................................................................................... 406 19.219.4 ....................................................................................................... 406 19.219.5 ....................................................................................................... 406 19.219.6 ..................................................................................................... 406 19.219.7 .................................................................................................... 407 19.219.8 ....................................................................................................... 407 19.219.9 ................................................................................................ 407 19.219.10 ................................................................................................... 407 19.219.11 ........................................................................................ 407 19.219.12 .................................................................................................... 407 19.219.13 ..................................................................................................... 408 19.219.14 ............................................................................................................ 408 19.219.15 ........................................................................................................ 408 19.219.16 ................................................................................................ 408 19.219.17 ...................................................................................................... 408 19.219.18 .....................................................................................409 19.219.19 ....................................................................................................... 409 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 36 of 102 19.219.20 ................................................................................................. 409 19.219.21 .................................................................................................. 409 19.219.22 ........................................................................................................ 409 19.219.23 .....................................................................................409 19.219.24 ............................................................................................ 410 19.219.25 ......................................................................................... 410 19.219.26 .....................................................................................410 19.219.27 .......................................................................................... 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 ................................................................................................ 414 19.229.3 ................................................................................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 .........................................................................416 19.234.2 .........................................................................416 19.235 fo:end-indent............................................................................................................... 416 19.236 fo:language................................................................................................................. 417 19.236.1 General................................................................................................................ 417 19.236.2 .........................................................................417 19.236.3 .........................................................................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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 37 of 102 19.242 fo:script....................................................................................................................... 419 19.242.1 General................................................................................................................ 419 19.242.2 .........................................................................419 19.242.3 .........................................................................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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 38 of 102 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 ......................................................................................................... 434 19.289.3 .......................................................................................... 435 19.289.4 and .............................................................435 19.289.5 ......................................................................................................... 435 19.290 form:min-value............................................................................................................ 435 19.290.1 General................................................................................................................ 435 19.290.2 ......................................................................................................... 435 19.290.3 .......................................................................................... 435 19.290.4 and .............................................................435 19.290.5 ......................................................................................................... 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 39 of 102 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 ...................................................................................................... 444 19.316.3 ......................................................................................................... 444 19.316.4 and .............................................................444 19.316.5 , , , , , , , , , , .................................................................................................................. 444 19.316.6 ......................................................................................................... 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 40 of 102 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 ............................................................................................... 451 19.343.3 ............................................................................................. 451 19.343.4 ................................................................................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 ...................................................................................................... 456 19.358.3 ........................................................................................ 456 19.358.4 ...................................................................................................... 456 19.358.5 .................................................................................................. 456 19.358.6 ............................................................................................... 457 19.358.7 ................................................................................................. 457 19.358.8 ................................................................................................ 457 19.358.9 .............................................................................................. 457 19.358.10 ................................................................................................... 458 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 41 of 102 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 .............................................................................................................. 463 19.376.3 ............................................................................................... 463 19.376.4 ......................................................................................... 463 19.376.5 ........................................................................................... 464 19.376.6 .............................................................................................. 464 19.376.7 .......................................................................................464 19.376.8 ............................................................................................. 464 19.376.9 ................................................................................................................ 464 19.376.10 ................................................................................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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 42 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 43 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 44 of 102 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 .............................................................................496 19.469.3 ......................................................................................................... 496 19.469.4 ............................................................................................. 496 19.469.5 ............................................................................................. 496 19.469.6 .......................................................................................496 19.469.7 ........................................................................................................... 497 19.469.8 ......................................................................................... 497 19.469.9 ................................................................................................ 497 19.469.10 ................................................................................................ 497 19.469.11 .....................................................................................497 19.469.12 .....................................................................................497 19.469.13 ................................................................................................. 498 19.469.14 ................................................................................................. 498 19.469.15 ........................................................................................... 498 19.469.16 ......................................................................................................... 498 19.469.17 ............................................................................................ 498 19.469.18 ........................................................................................... 499 19.469.19 ........................................................................................ 499 19.469.20 ............................................................................................. 499 19.469.21 .......................................................................................... 499 19.469.22 ............................................................................................. 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 45 of 102 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 , , , , , , , , , , , , ...............................................................508 19.498.3 .................................................................................................. 509 19.499 style:next-style-name.................................................................................................. 509 19.499.1 General................................................................................................................ 509 19.499.2 ............................................................................................ 509 19.499.3 ......................................................................................................... 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 46 of 102 19.508.1 General................................................................................................................ 512 19.508.2 ...................................................................................512 19.508.3 ................................................................................................... 513 19.508.4 ..................................................................................513 19.509 style:rel-height............................................................................................................. 513 19.510 style:rel-width.............................................................................................................. 514 19.510.1 General................................................................................................................ 514 19.510.2 ....................................................................................................... 514 19.510.3 ..................................................................................................... 514 19.510.4 ............................................................................................ 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 ..................................................................................516 19.515.3 ................................................................................................... 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 .............................................................................................. 518 19.518.3 ............................................................................................ 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 ............................................................................................... 519 19.524.2 ....................................................................................................... 519 19.524.3 ...................................................................................................... 519 19.524.4 ............................................................................................ 519 19.525 svg:cy.......................................................................................................................... 519 19.525.1 ............................................................................................... 519 19.525.2 ....................................................................................................... 520 19.525.3 ...................................................................................................... 520 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 47 of 102 19.525.4 ............................................................................................ 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 ........................................................................................................ 522 19.539.2 ................................................................................................. 523 19.539.3 ....................................................................................................... 523 19.539.4 ........................................................................................... 523 19.539.5 ......................................................................................... 523 19.539.6 , ....................................................523 19.539.7 ................................................................................................. 523 19.539.8 , , , , , , , , , , , ................................................524 19.539.9 .............................................................................................. 524 19.539.10 ................................................................................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 ............................................................................................... 526 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 48 of 102 19.549.2 ....................................................................................................... 526 19.549.3 ............................................................................................ 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 ........................................................................................................ 530 19.571.2 ......................................................................................................... 531 19.571.3 ................................................................................................. 531 19.571.4 ......................................................................................................... 531 19.571.5 ....................................................................................................... 531 19.571.6 ........................................................................................... 531 19.571.7 ......................................................................................... 531 19.571.8 , ....................................................532 19.571.9 ................................................................................................. 532 19.571.10 , , , , , , , , , , , ................................................532 19.571.11 ............................................................................................. 532 19.571.12 ................................................................................532 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 49 of 102 19.572 svg:widths................................................................................................................... 533 19.573 svg:x........................................................................................................................... 533 19.573.1 , , , , , , ...................................................................................533 19.573.2 ........................................................................................... 533 19.573.3 ......................................................................................... 533 19.573.4 ....................................................................................................... 533 19.573.5 , , , , , , , , , , , ................................................534 19.573.6 ................................................................................................ 534 19.573.7 .............................................................................................. 534 19.573.8 ..................................................................................534 19.574 svg:x1......................................................................................................................... 534 19.574.1 , and .........................................534 19.574.2 ............................................................................................ 535 19.575 svg:x2 ........................................................................................................................ 535 19.575.1 , and .........................................535 19.575.2 ............................................................................................ 535 19.576 svg:x-height................................................................................................................. 535 19.577 svg:y............................................................................................................................ 536 19.577.1 , , , , , , ...................................................................................536 19.577.2 ........................................................................................... 536 19.577.3 ......................................................................................... 536 19.577.4 ....................................................................................................... 536 19.577.5 , , , , , , , , , , , , ...........................536 19.577.6 ................................................................................................ 537 19.577.7 .............................................................................................. 537 19.577.8 ..................................................................................537 19.578 svg:y1.......................................................................................................................... 537 19.578.1 , and .........................................537 19.578.2 ............................................................................................ 537 19.579 svg:y2.......................................................................................................................... 538 19.579.1 , and .........................................538 19.579.2 ............................................................................................ 538 19.580 table:acceptance-state................................................................................................ 538 19.581 table:algorithm............................................................................................................ 539 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 50 of 102 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 ............................................................................................... 542 19.593.3 - bubble......................................................................................542 19.593.4 - scatter.......................................................................................542 19.593.5 - surface.....................................................................................543 19.593.6 (deprecated)............................................................................543 19.593.7 ....................................................................................543 19.593.8 ........................................................................................... 543 19.593.9 ....................................................................................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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 51 of 102 19.611 table:data-type............................................................................................................. 549 19.611.1 General................................................................................................................ 549 19.611.2 .......................................................................................... 549 19.611.3 ..................................................................................................... 549 19.611.4 .............................................................................................. 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 52 of 102 19.643.2 ........................................................................................... 561 19.643.3 ......................................................................................... 561 19.643.4 ....................................................................................562 19.643.5 ............................................................................................ 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 ....................................................................................571 19.673.3 ....................................................................................571 19.673.4 .......................................................................................571 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 53 of 102 19.673.5 ........................................................................571 19.673.6 ...................................................................................571 19.673.7 ........................................................................................ 572 19.673.8 .......................................................................................572 19.673.9 ..................................................................................572 19.673.10 ......................................................................................... 572 19.673.11 ............................................................................................... 572 19.673.12 .......................................................................................573 19.673.13 ...................................................................................................... 573 19.673.14 .......................................................................................573 19.674 table:null-year.............................................................................................................. 573 19.675 table:number-columns-repeated.................................................................................574 19.675.1 General................................................................................................................ 574 19.675.2 ....................................................................................574 19.675.3 .................................................................................................. 574 19.675.4 ........................................................................................... 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 ......................................................................................... 578 19.686.3 .......................................................................................579 19.686.4 .............................................................................................. 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 54 of 102 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 ...................................................................................582 19.696.3 .................................................................................................. 582 19.696.4 ........................................................................................................ 583 19.696.5 ................................................................................................. 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 55 of 102 19.726.1 General................................................................................................................ 591 19.726.2 ............................................................................................. 591 19.726.3 ........................................................................................................ 591 19.726.4 ....................................................................................591 19.726.5 .......................................................................................... 592 19.726.6 ............................................................................................... 592 19.726.7 ............................................................................................. 592 19.726.8 ................................................................................................... 592 19.726.9 ............................................................................................. 592 19.726.10 ................................................................................................. 592 19.726.11 .......................................................................................... 593 19.726.12 ............................................................................................... 593 19.726.13 ................................................................................................ 593 19.726.14 ......................................................................................... 593 19.726.15 ............................................................................................... 593 19.726.16 ...................................................................................................... 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 ........................................................................................ 595 19.731.3 .......................................................................................595 19.731.4 ......................................................................................................... 595 19.731.5 .......................................................................................................... 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 .........................................................................596 19.735.3 .................................................................................................. 597 19.735.4 .................................................................................................. 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 56 of 102 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 .......................................................................................... 601 19.747.2 ........................................................................................... 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 ................................................................................................................ 610 19.770.3 ................................................................................................................ 611 19.770.4 .......................................................................................................... 611 19.771 text:column-name........................................................................................................ 611 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 57 of 102 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 .......................................................................................... 613 19.777.3 ........................................................................................... 613 19.777.4 ..................................................................................613 19.777.5 ......................................................................................614 19.777.6 ................................................................................................ 614 19.777.7 ...................................................................................................... 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 ...................................................................................................... 618 19.796.3 ................................................................................................ 619 19.796.4 ................................................................................................... 619 19.796.5 ...................................................................................620 19.796.6 ...................................................................................................... 620 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 58 of 102 19.796.7 ............................................................................................. 620 19.796.8 .......................................................................................... 621 19.796.9 ............................................................................................. 621 19.796.10 ............................................................................................. 621 19.796.11 ........................................................................................... 622 19.796.12 ............................................................................................. 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 ................................................................................................... 625 19.809.3 ....................................................................626 19.809.4 ....................................................................626 19.809.5 ......................................................................................... 626 19.809.6 ................................................................................................................ 626 19.809.7 ........................................................................................................... 627 19.809.8 ................................................................................................................ 627 19.809.9 ............................................................................................. 627 19.809.10 .......................................................................................... 627 19.809.11 ...............................................................................628 19.809.12 ..............................................................................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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 59 of 102 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 .....................................................................................636 19.835.3 ............................................................................................... 636 19.835.4 .................................................................................................. 636 19.835.5 ........................................................................................... 636 19.835.6 .......................................................................................... 636 19.835.7 .......................................................................................... 636 19.835.8 ........................................................................................ 637 19.835.9 ................................................................................................... 637 19.835.10 ............................................................................................. 637 19.835.11 ........................................................................................ 637 19.835.12 ................................................................................637 19.835.13 ...............................................................................637 19.835.14 .................................................................................................... 638 19.835.15 ................................................................................................ 638 19.835.16 ......................................................................................... 638 19.835.17 .......................................................................................638 19.835.18 .............................................................................................. 638 19.835.19 ............................................................................................ 638 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 60 of 102 19.835.20 ......................................................................................... 639 19.835.21 ........................................................................................... 639 19.835.22 ........................................................................................ 639 19.835.23 ............................................................................................... 639 19.835.24 ............................................................................................. 639 19.835.25 ........................................................................................... 639 19.835.26 ............................................................................................. 640 19.835.27 .......................................................................................... 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 .............................................................642 19.844.3 ...................................................................................................... 642 19.844.4 ................................................................................................................ 643 19.844.5 ...................................................................................643 19.844.6 ...................................................................................643 19.844.7 ........................................................................................ 643 19.844.8 .................................................................643 19.844.9 ............................................................................643 19.844.10 .................................................................................................. 644 19.844.11 ......................................................................................... 644 19.844.12 .......................................................................644 19.844.13 ..............................................................................644 19.845 text:page-adjust.......................................................................................................... 644 19.845.1 General................................................................................................................ 644 19.845.2 ............................................................................................ 644 19.845.3 ......................................................................................645 19.846 text:pages................................................................................................................... 645 19.847 text:placeholder-type................................................................................................... 645 19.848 text:prefix.................................................................................................................... 645 19.849 text:protected.............................................................................................................. 646 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 61 of 102 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 ............................................................................................ 647 19.853.3 ..................................................................................................... 647 19.853.4 ............................................................................................. 647 19.853.5 .................................................................................................. 648 19.853.6 ............................................................................................. 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 .....................................................................................651 19.863.3 ............................................................................................ 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 ................................................................................................................ 653 19.868.3 ..................................................................................................... 654 19.868.4 ...............................................................................654 19.868.5 ...................................................................................654 19.868.6 ................................................................................654 19.868.7 ......................................................................................654 19.869 text:start-numbering-at................................................................................................ 655 19.870 text:string-value-phonetic............................................................................................ 655 19.871 text:string-value........................................................................................................... 655 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 62 of 102 19.871.1 General................................................................................................................ 655 19.871.2 ............................................................................655 19.871.3 ................................................................................................ 655 19.871.4 .....................................................................................656 19.871.5 .................................................................................................... 656 19.871.6 ........................................................................................ 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 ................................................................................................................ 657 19.874.3 .....................................................................................657 19.874.4 .............................................................657 19.874.5 ............................................................................................... 657 19.874.6 .......................................................................657 19.874.7 ................................................................................................................ 658 19.874.8 ........................................................................................ 658 19.874.9 ................................................................658 19.874.10 ..........................................................................658 19.874.11 .................................................................................658 19.874.12 .................................................................................658 19.874.13 ................................................................................659 19.874.14 ........................................................................659 19.874.15 .....................................................................................659 19.874.16 ................................................................................659 19.874.17 .......................................................................................659 19.874.18 ...................................................................................659 19.874.19 ................................................................................................. 660 19.874.20 ..................................................................................660 19.874.21 ....................................................................660 19.874.22 ........................................................................................................... 660 19.874.23 .............................................................................660 19.874.24 .................................................................................661 19.874.25 ..............................................................................661 19.874.26 ............................................................................................. 661 19.874.27 .....................................................................661 19.874.28 ....................................................................................662 19.874.29 .............................................................................................................. 662 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 63 of 102 19.874.30 ......................................................................................................... 662 19.874.31 .................................................................................................. 662 19.874.32 .................................................................................................... 662 19.874.33 ........................................................................................................ 662 19.874.34 ......................................................................663 19.874.35 .......................................................................................663 19.874.36 ...............................................................663 19.874.37 .............................................................................................. 663 19.874.38 ............................................................................................... 663 19.874.39 .......................................................................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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 64 of 102 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 ....................................................................................................... 675 19.910.3 ........................................................................................................ 675 19.910.4 ......................................................................................... 675 19.910.5 .................................................................................................. 675 19.910.6 ...................................................................................676 19.910.7 ....................................................................................676 19.910.8 .............................................................................................................. 676 19.910.9 ...................................................................................................... 676 19.910.10 ............................................................................................. 676 19.910.11 ......................................................................................... 676 19.910.12 .......................................................................................677 19.910.13 ................................................................................................ 677 19.910.14 ........................................................................................ 677 19.910.15 .................................................................................................... 677 19.910.16 .................................................................................................... 677 19.910.17 .............................................................................................. 677 19.910.18 .................................................................................................... 678 19.910.19 .................................................................................................... 678 19.910.20 ..............................................................................678 19.910.21 .................................................................................................... 678 19.910.22 ....................................................................................................... 678 19.910.23 ............................................................................................ 678 19.910.24 ................................................................................................ 678 19.910.25 .............................................................................679 19.910.26 ........................................................................................ 679 19.910.27 ........................................................................................ 679 19.910.28 .................................................................................679 19.910.29 ............................................................................................ 679 19.910.30 ............................................................................................. 679 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 65 of 102 19.910.31 ..................................................................................680 19.910.32 .......................................................................................... 680 19.910.33 .............................................................................................................. 680 19.910.34 ............................................................680 19.910.35 ................................................................................680 19.910.36 ....................................................................................................... 680 19.910.37 ......................................................................................... 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 66 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 67 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 68 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 69 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 70 of 102 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 ....................................................................................748 20.205.2 ..........................................................................748 20.206 fo:min-width................................................................................................................. 748 20.207 fo:orphans................................................................................................................... 748 20.208 fo:page-height............................................................................................................. 749 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 71 of 102 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 ...............................................................................751 20.216.2 ..................................................................................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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 72 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 73 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 74 of 102 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 ....................................................................................790 20.323.3 .................................................................................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 ....................................................................................791 20.326.3 ....................................................................................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 ....................................................................................793 20.332.2 ........................................................................................ 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 75 of 102 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 ...............................................................................813 20.386.2 .................................................................................813 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 76 of 102 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 ....................................................................................817 20.394.3 .............................................................................817 20.394.4 ...............................................................................817 20.394.5 ....................................................................................817 20.394.6 .................................................................................818 20.394.7 ........................................................................................ 818 20.395 style:writing-mode-automatic.......................................................................................818 20.396 svg:fill-rule................................................................................................................... 819 20.397 svg:height.................................................................................................................... 819 20.397.1 ....................................................................................819 20.397.2 ..........................................................................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 ....................................................................................820 20.402.2 ..................................................................................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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 77 of 102 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 and 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 78 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 79 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 80 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 81 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 82 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 83 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 84 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 85 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 86 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 87 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 88 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 89 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 90 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 91 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 92 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 93 of 102 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 ........................................................................................................... 18 4.3 ........................................................................................................... 18 4.4 ................................................................................................. 18 4.5 .......................................................................................................... 19 4.6 ......................................................................................... 19 4.7 ................................................................................................... 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 ............................................................................................... 26 5.3 .................................................................................................................... 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 94 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 95 of 102 1 Introduction 1.1 Scope 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.2 Terminology 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.3 Normative 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. OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 96 of 102 The individual parts of the OpenDocument specification each defines its own set of normative references. 1.4 Non Normative References [ODF11] OASIS Standard, Open Document Format for Office Applications (OpenDocument) v1.1, February 2007, http://docs.oasis-open.org/office/v1.1/OS/OpenDocumentv1.1.pdf. The individual parts of the OpenDocument specification each contains further non normative references. OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 97 of 102 2 Conformance The OpenDocument specification defines conformance for documents, consumers, producers, packages, package consumer, package producers, formula expressions and formula evaluators, with multiple conformance classes. (C1) A conforming OpenDocument Document shall meet the requirements defined in part 1 section 2.2.1 and chapters 3 to 20 for OpenDocument documents.. (C2) A conforming OpenDocument extended Document shall meet the requirements defined in part 1 section 2.2.2 and chapters 3 to 20 for OpenDocument extended documents. (C3) A conforming OpenDocument Text Document shall meet the requirements defined in part 1 section 2.2.3 and chapters 3 to 20 for OpenDocument Text documents. (C4) A conforming OpenDocument Spreadsheet Document shall meet the requirements defined in part 1 section 2.2.4 and chapters 3 to 20 for OpenDocument Spreadsheet documents. (C5) A conforming OpenDocument Drawing Document shall meet the requirements defined in part 1 section 2.2.5 and chapters 3 to 20 for OpenDocument Drawing documents. (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. (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. (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. (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. (C10) A conforming OpenDocument Database Front End Document shall meet the requirements defined in part 1 section 2.2.10 and chapters 3 to 20 for OpenDocument Database Front End documents. (C11) A Conforming OpenDocument Producer shall meet the requirements defined in part 1 section 2.3.1 and chapters 3 to 20 for OpenDocument producers. (C12) A Conforming OpenDocument Extended Producer shall meet the requirements defined in part 1 section 2.3.2 and chapters 3 to 20 for OpenDocument extended producers. (C13) A Conforming OpenDocument Consumer shall meet the requirements defined in part 1 section 2.4 and chapters 3 to 20 for OpenDocument consumers. (C14) A conforming OpenDocument Formula Expression shall meet the requirements defined in part 2 section 2.2 and chapters 3 to 8 for OpenDocument formula expressions. (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. (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. (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. OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 98 of 102 (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. (C19) A conforming OpenDocument Package shall meet the requirements defined in part 3 section 2.2.1 and chapters 3 to 7 for OpenDocument packages. (C20) A conforming OpenDocument Extended Package shall meet the requirements defined in part 3 section 2.2.2 and chapters 3 to 7 for OpenDocument extended packages. (C21) A Conforming OpenDocument Package Producer shall meet the requirements defined in part 3 section 2.3.1 and chapters 3 to 7 for OpenDocument package producers. (C22) A Conforming OpenDocument Package Extended Producer shall meet the requirements defined in part 3 section 2.3.2 and chapters 3 to 7 for OpenDocument package extended producers. (C23) A Conforming OpenDocument Package Consumer shall meet the requirements defined in part 3 section 2.4 and chapters 3 to 7 for OpenDocument package consumers. OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 99 of 102 Appendix A. Changes From Previous Specification Versions (Non Normative) A.1. Changes from “Open Document Format for Office Applications (OpenDocument) v1.1” The OpenDocument specification has been divided into three parts and has been restructured. A more detailed list of changes is included in parts 1 and 3. Part 2 contains content that is new in OpenDocument v1.2. OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 100 of 102 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 OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 101 of 102 Svante Schubert, Oracle Corporation Charles Schulz, Ars Aperta Richard Schwerdtfeger, IBM Douglas Schepers Wei Guo Shi, IBM Michael Stahl, Oracle Corporation Yan Shi, Beijing Sursen International Information Technology Co., Ltd. Jomar Silva, OpenDocument Format Alliance Frank Stecher, Sun Microsystems Hironobu Takagi, IBM Malte Timmermann, Oracle Corporation John Tolbert, The Boeing Company Elias Torres, IBM Warren Turkal, Google Inc. Jos van den Oever, KDE e.V. Alex Wang, Beijing Sursen International Information Technology Co., Ltd. Robert Weir, IBM Oliver-Rainer Wittmann, Oracle Corporation David A. Wheeler Cheng XiuZhi, Beijing Redflag Chinese 2000 Software Co., Ltd. Panrong Yin, IBM Kohei Yoshida, Novell Helen Yue, IBM Jin YouBing, Beijing Redflag Chinese 2000 Software Co., Ltd. Thorsten Zachmann, Nokia Corporation Thomas Zander, Nokia Corporation Pine Zhang, UOML Alliance OpenDocument-v1.2-os Copyright © OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product 29 September 2011 Page 102 of 102