OASIS Openopen access

Open Document Format for Office Applications (OpenDocument) Version 1.2 (2011-09-30)

OASIS Open · OASIS Open

OASIS Open · Standards · License: Open Access

applications document format office open os v1 v1.2

oasis, standard, oasis open, specification, open standard, oasis_opendocument-v1.2-os, open, document, format, for, office, applications, opendocument, version, 1.2, opendocument-v1.2-os, v1, os

OASIS Open Document Format for Office Applications (OpenDocument) Version 1.2 @page { } table { border-collapse:collapse; border-spacing:0; empty-cells:show } td, th { vertical-align:top; font-size:12pt;} h1, h2, h3, h4, h5, h6 { clear:both } ol, ul { margin:0; padding:0;} li { list-style: none; margin:0; padding:0;} li span. { clear: both; line-height:0; width:0; height:0; margin:0; padding:0; } span.footnodeNumber { padding-right:1em; } span.annotation_style_by_filter { font-size:95%; font-family:Arial; background-color:#fff000; margin:0; border:0; padding:0; } * { margin:0;} .fr1 { font-size:12pt; text-align:left; vertical-align:top; writing-mode:lr-tb; } .Appendix_20_Heading_borderStart { border-left-style:none; border-right-style:none; border-top-width:0.0133cm; border-top-style:solid; border-top-color:#000000; color:#333399; font-size:18pt; font-weight:bold; margin-left:0in; margin-right:0in; margin-top:0.1945in; padding-left:0in; padding-right:0in; padding-top:0.0835in; text-indent:0in; font-family:Arial; writing-mode:page; padding-bottom:0.1945in; border-bottom-style:none; } .Appendix_20_Heading { border-left-style:none; border-right-style:none; color:#333399; font-size:18pt; font-weight:bold; margin-left:0in; margin-right:0in; padding-left:0in; padding-right:0in; text-indent:0in; font-family:Arial; writing-mode:page; padding-bottom:0.1945in; padding-top:0.1945in; border-top-style:none; border-bottom-style:none; } .Appendix_20_Heading_borderEnd { border-bottom-style:none; border-left-style:none; border-right-style:none; color:#333399; font-size:18pt; font-weight:bold; margin-bottom:0.1945in; margin-left:0in; margin-right:0in; padding-bottom:0in; padding-left:0in; padding-right:0in; text-indent:0in; font-family:Arial; writing-mode:page; padding-top:0.1945in; border-top-style:none;} .Appendix_20_Heading_20_1_borderStart { border-left-style:none; border-right-style:none; border-top-width:0.0133cm; border-top-style:solid; border-top-color:#000000; color:#333399; font-size:18pt; font-weight:bold; margin-left:0in; margin-right:0in; margin-top:0.1945in; padding-left:0in; padding-right:0in; padding-top:0.0835in; text-indent:0in; font-family:Arial; writing-mode:page; padding-bottom:0.1945in; border-bottom-style:none; } .Appendix_20_Heading_20_1 { border-left-style:none; border-right-style:none; color:#333399; font-size:18pt; font-weight:bold; margin-left:0in; margin-right:0in; padding-left:0in; padding-right:0in; text-indent:0in; font-family:Arial; writing-mode:page; padding-bottom:0.1945in; padding-top:0.1945in; border-top-style:none; border-bottom-style:none; } .Appendix_20_Heading_20_1_borderEnd { border-bottom-style:none; border-left-style:none; border-right-style:none; color:#333399; font-size:18pt; font-weight:bold; margin-bottom:0.1945in; margin-left:0in; margin-right:0in; padding-bottom:0in; padding-left:0in; padding-right:0in; text-indent:0in; font-family:Arial; writing-mode:page; padding-top:0.1945in; border-top-style:none;} .Appendix_20_Heading_20_2_borderStart { border-style:none; color:#000099; font-size:14pt; font-weight:bold; margin-left:0in; margin-right:0in; margin-top:0.1665in; padding:0in; text-indent:0in; font-family:Arial; writing-mode:page; padding-bottom:0.0835in; border-bottom-style:none; } .Appendix_20_Heading_20_2 { border-style:none; color:#000099; font-size:14pt; font-weight:bold; margin-left:0in; margin-right:0in; padding:0in; text-indent:0in; font-family:Arial; writing-mode:page; padding-bottom:0.0835in; padding-top:0.1665in; border-top-style:none; border-bottom-style:none; } .Appendix_20_Heading_20_2_borderEnd { border-style:none; color:#000099; font-size:14pt; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; padding:0in; text-indent:0in; font-family:Arial; writing-mode:page; padding-top:0.1665in; border-top-style:none;} .Bibliography_20_1_borderStart { font-size:10pt; margin-top:0.0555in; font-family:Arial; writing-mode:page; margin-left:0in; margin-right:0in; text-indent:0in; background-color:transparent; padding-bottom:0.0555in; border-bottom-style:none; } .Bibliography_20_1 { font-size:10pt; font-family:Arial; writing-mode:page; margin-left:0in; margin-right:0in; text-indent:0in; background-color:transparent; padding-bottom:0.0555in; padding-top:0.0555in; border-top-style:none; border-bottom-style:none; } .Bibliography_20_1_borderEnd { font-size:10pt; margin-bottom:0.0555in; font-family:Arial; writing-mode:page; margin-left:0in; margin-right:0in; text-indent:0in; background-color:transparent; padding-top:0.0555in; border-top-style:none;} .Contents_20_1 { font-size:10pt; margin-bottom:0.0417in; margin-top:0.0417in; font-family:Arial; writing-mode:page; } .Contents_20_10 { font-size:10pt; margin-bottom:0.0555in; margin-top:0.0555in; font-family:Arial; writing-mode:page; margin-left:1.7689in; margin-right:0in; text-indent:0in; } .Contents_20_2 { font-size:10pt; margin-bottom:0.0417in; margin-top:0.0417in; font-family:Arial; writing-mode:page; margin-left:0.1665in; margin-right:0in; text-indent:0.0008in; } .Contents_20_3 { font-size:10pt; margin-bottom:0.0417in; margin-top:0.0417in; font-family:Arial; writing-mode:page; margin-left:0.3335in; margin-right:0in; text-indent:0.0008in; } .Contents_20_4 { font-size:9pt; margin-bottom:0.0417in; margin-left:0.5in; margin-right:0in; margin-top:0.0417in; text-indent:0.0008in; font-family:Arial; writing-mode:page; } .Contents_20_5 { font-size:9pt; margin-bottom:0.0417in; margin-left:0.6665in; margin-right:0in; margin-top:0.0417in; text-indent:0.0008in; font-family:Arial; writing-mode:page; } .Contents_20_6 { font-size:9pt; margin-bottom:0.0555in; margin-top:0.0555in; font-family:Arial; writing-mode:page; margin-left:0.8335in; margin-right:0in; text-indent:0.0008in; } .Contents_20_7 { font-size:10pt; margin-bottom:0.0835in; margin-top:0in; font-family:Arial; writing-mode:page; margin-left:1in; margin-right:0in; text-indent:0.0008in; } .Contents_20_8 { font-size:10pt; margin-bottom:0.0555in; margin-top:0.0555in; font-family:Arial; writing-mode:page; margin-left:1.3756in; margin-right:0in; text-indent:0in; } .Contents_20_9 { font-size:10pt; margin-bottom:0.0555in; margin-top:0.0555in; font-family:Arial; writing-mode:page; margin-left:1.572in; margin-right:0in; text-indent:0in; } .Contents_20_Heading { color:#000099; font-size:16pt; font-weight:bold; margin-bottom:0.0835in; margin-top:0.1665in; font-family:Arial; writing-mode:page; margin-left:0in; margin-right:0in; text-indent:0in; } .Contributor { color:#000000; font-size:10pt; font-weight:normal; margin-bottom:0in; margin-left:0.5in; margin-right:0in; margin-top:0in; text-indent:0.0008in; font-family:Arial; writing-mode:page; } .Heading_20_1_borderStart { color:#000099; font-size:18pt; font-weight:bold; margin-top:0.3335in; font-family:Arial; writing-mode:page; margin-left:0in; margin-right:0in; text-indent:0in; padding-left:0in; padding-right:0in; padding-top:0.0835in; border-left-style:none; border-right-style:none; border-top-width:0.0133cm; border-top-style:solid; border-top-color:#000000; padding-bottom:0.0835in; border-bottom-style:none; } .Heading_20_1 { color:#000099; font-size:18pt; font-weight:bold; font-family:Arial; writing-mode:page; margin-left:0in; margin-right:0in; text-indent:0in; padding-left:0in; padding-right:0in; border-left-style:none; border-right-style:none; padding-bottom:0.0835in; padding-top:0.3335in; border-top-style:none; border-bottom-style:none; } .Heading_20_1_borderEnd { color:#000099; font-size:18pt; font-weight:bold; margin-bottom:0.0835in; font-family:Arial; writing-mode:page; margin-left:0in; margin-right:0in; text-indent:0in; padding-left:0in; padding-right:0in; padding-bottom:0in; border-left-style:none; border-right-style:none; border-bottom-style:none; padding-top:0.3335in; border-top-style:none;} .Heading_20_2_borderStart { color:#000099; font-size:14pt; font-weight:bold; margin-top:0.1665in; font-family:Arial; writing-mode:page; margin-left:0in; margin-right:0in; text-indent:0in; padding:0in; border-style:none; padding-bottom:0.0835in; border-bottom-style:none; } .Heading_20_2 { color:#000099; font-size:14pt; font-weight:bold; font-family:Arial; writing-mode:page; margin-left:0in; margin-right:0in; text-indent:0in; padding:0in; border-style:none; padding-bottom:0.0835in; padding-top:0.1665in; border-top-style:none; border-bottom-style:none; } .Heading_20_2_borderEnd { color:#000099; font-size:14pt; font-weight:bold; margin-bottom:0.0835in; font-family:Arial; writing-mode:page; margin-left:0in; margin-right:0in; text-indent:0in; padding:0in; border-style:none; padding-top:0.1665in; border-top-style:none;} .P1 { color:#000000; font-size:10pt; font-weight:normal; margin-bottom:0.0555in; margin-left:0.5in; margin-right:0in; margin-top:0in; text-indent:0.0008in; font-family:Arial; writing-mode:page; } .P10 { font-size:9pt; margin-bottom:0.0417in; margin-left:0.5in; margin-right:0in; margin-top:0.0417in; text-indent:0.0008in; font-family:Arial; writing-mode:page; } .P11 { font-size:10pt; margin-bottom:0.0417in; margin-left:0.3335in; margin-right:0in; margin-top:0.0417in; text-indent:0.0008in; font-family:Arial; writing-mode:page; } .P12 { color:#000000; font-size:10pt; font-weight:normal; margin-bottom:0.0555in; margin-left:0.5in; margin-right:0in; margin-top:0in; text-indent:0.0008in; font-family:Arial; writing-mode:page; } .P13 { color:#000000; font-size:10pt; font-weight:bold; margin-bottom:0.0555in; margin-left:0.5in; margin-right:0in; margin-top:0in; text-indent:0.0008in; font-family:Arial; writing-mode:page; } .P14 { color:#333399; font-size:12pt; font-weight:bold; margin-bottom:0in; margin-top:0.0835in; font-family:Arial; writing-mode:page; } .P15 { font-size:10pt; margin-bottom:0.0555in; margin-top:0.0555in; font-family:Arial; writing-mode:page; } .P16_borderStart { border-left-style:none; border-right-style:none; border-top-width:0.0133cm; border-top-style:solid; border-top-color:#000000; color:#000099; font-size:18pt; font-weight:bold; margin-left:0in; margin-right:0in; margin-top:0.3335in; padding-left:0in; padding-right:0in; padding-top:0.0835in; text-indent:0in; font-family:Arial; writing-mode:page; padding-bottom:0.0835in; border-bottom-style:none; } .P16 { border-left-style:none; border-right-style:none; color:#000099; font-size:18pt; font-weight:bold; margin-left:0in; margin-right:0in; padding-left:0in; padding-right:0in; text-indent:0in; font-family:Arial; writing-mode:page; padding-bottom:0.0835in; padding-top:0.3335in; border-top-style:none; border-bottom-style:none; } .P16_borderEnd { border-bottom-style:none; border-left-style:none; border-right-style:none; color:#000099; font-size:18pt; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; padding-bottom:0in; padding-left:0in; padding-right:0in; text-indent:0in; font-family:Arial; writing-mode:page; padding-top:0.3335in; border-top-style:none;} .P2 { color:#000000; font-size:10pt; font-weight:normal; margin-bottom:0.0555in; margin-left:0.7457in; margin-right:0in; margin-top:0in; text-indent:0.0008in; font-family:Arial; writing-mode:page; } .P3 { font-size:10pt; margin-bottom:0.0555in; margin-top:0.0555in; font-family:Arial; writing-mode:page; } .P4_borderStart { border-left-style:none; border-right-style:none; border-top-width:0.0133cm; border-top-style:solid; border-top-color:#000000; color:#333399; font-size:18pt; font-weight:bold; margin-top:0.1665in; padding-left:0in; padding-right:0in; padding-top:0.0138in; font-family:Arial; writing-mode:page; padding-bottom:0.25in; border-bottom-style:none; } .P4 { border-left-style:none; border-right-style:none; color:#333399; font-size:18pt; font-weight:bold; padding-left:0in; padding-right:0in; font-family:Arial; writing-mode:page; padding-bottom:0.25in; padding-top:0.1665in; border-top-style:none; border-bottom-style:none; } .P4_borderEnd { border-bottom-style:none; border-left-style:none; border-right-style:none; color:#333399; font-size:18pt; font-weight:bold; margin-bottom:0.25in; padding-bottom:0in; padding-left:0in; padding-right:0in; font-family:Arial; writing-mode:page; padding-top:0.1665in; border-top-style:none;} .P5_borderStart { border-left-style:none; border-right-style:none; border-top-width:0.0133cm; border-top-style:solid; border-top-color:#000000; color:#333399; font-size:18pt; font-weight:bold; margin-top:0.1665in; padding-left:0in; padding-right:0in; padding-top:0.0138in; font-family:Arial; writing-mode:page; padding-bottom:0.25in; border-bottom-style:none; } .P5 { border-left-style:none; border-right-style:none; color:#333399; font-size:18pt; font-weight:bold; padding-left:0in; padding-right:0in; font-family:Arial; writing-mode:page; padding-bottom:0.25in; padding-top:0.1665in; border-top-style:none; border-bottom-style:none; } .P5_borderEnd { border-bottom-style:none; border-left-style:none; border-right-style:none; color:#333399; font-size:18pt; font-weight:bold; margin-bottom:0.25in; padding-bottom:0in; padding-left:0in; padding-right:0in; font-family:Arial; writing-mode:page; padding-top:0.1665in; border-top-style:none;} .P6 { color:#000000; font-size:10pt; font-weight:normal; margin-bottom:0.0547in; margin-left:0in; margin-right:0in; margin-top:0.0547in; text-indent:0.0008in; font-family:Arial; writing-mode:page; } .P7 { font-size:10pt; margin-bottom:0.0417in; margin-top:0.0417in; font-family:Arial; writing-mode:page; } .P8 { font-size:10pt; margin-bottom:0.0417in; margin-left:0.1665in; margin-right:0in; margin-top:0.0417in; text-indent:0.0008in; font-family:Arial; writing-mode:page; } .P9_borderStart { background-color:transparent; font-size:10pt; margin-left:0in; margin-right:0in; margin-top:0.0555in; text-indent:0in; font-family:Arial; writing-mode:page; padding-bottom:0.0555in; border-bottom-style:none; } .P9 { background-color:transparent; font-size:10pt; margin-left:0in; margin-right:0in; text-indent:0in; font-family:Arial; writing-mode:page; padding-bottom:0.0555in; padding-top:0.0555in; border-top-style:none; border-bottom-style:none; } .P9_borderEnd { background-color:transparent; font-size:10pt; margin-bottom:0.0555in; margin-left:0in; margin-right:0in; text-indent:0in; font-family:Arial; writing-mode:page; padding-top:0.0555in; border-top-style:none;} .Subtitle_borderStart { border-left-style:none; border-right-style:none; border-top-width:0.0133cm; border-top-style:solid; border-top-color:#000000; color:#333399; font-size:18pt; font-weight:bold; margin-top:0.1665in; padding-left:0in; padding-right:0in; padding-top:0.0138in; font-family:Arial; writing-mode:page; padding-bottom:0.25in; border-bottom-style:none; } .Subtitle { border-left-style:none; border-right-style:none; color:#333399; font-size:18pt; font-weight:bold; padding-left:0in; padding-right:0in; font-family:Arial; writing-mode:page; padding-bottom:0.25in; padding-top:0.1665in; border-top-style:none; border-bottom-style:none; } .Subtitle_borderEnd { border-bottom-style:none; border-left-style:none; border-right-style:none; color:#333399; font-size:18pt; font-weight:bold; margin-bottom:0.25in; padding-bottom:0in; padding-left:0in; padding-right:0in; font-family:Arial; writing-mode:page; padding-top:0.1665in; border-top-style:none;} .Table_20_of_20_Contents_20_Sub_20_Title_borderStart { border-left-style:none; border-right-style:none; border-top-width:0.0133cm; border-top-style:solid; border-top-color:#000000; color:#333399; font-size:14pt; font-weight:bold; margin-top:0.1665in; padding-left:0in; padding-right:0in; padding-top:0.0138in; font-family:Arial; writing-mode:page; padding:0in; border-style:none; padding-bottom:0.25in; border-bottom-style:none; } .Table_20_of_20_Contents_20_Sub_20_Title { border-left-style:none; border-right-style:none; color:#333399; font-size:14pt; font-weight:bold; padding-left:0in; padding-right:0in; font-family:Arial; writing-mode:page; padding:0in; border-style:none; padding-bottom:0.25in; padding-top:0.1665in; border-top-style:none; border-bottom-style:none; } .Table_20_of_20_Contents_20_Sub_20_Title_borderEnd { border-bottom-style:none; border-left-style:none; border-right-style:none; color:#333399; font-size:14pt; font-weight:bold; margin-bottom:0.25in; padding-bottom:0in; padding-left:0in; padding-right:0in; font-family:Arial; writing-mode:page; padding:0in; border-style:none; padding-top:0.1665in; border-top-style:none;} .Text_20_body { font-size:10pt; margin-bottom:0.0555in; margin-top:0.0555in; font-family:Arial; writing-mode:page; } .Title_borderStart { font-size:24pt; margin-top:0.1665in; font-family:Arial; writing-mode:page; padding-left:0in; padding-right:0in; padding-top:0.0138in; border-left-style:none; border-right-style:none; border-top-width:0.0133cm; border-top-style:solid; border-top-color:#000000; color:#333399; font-weight:bold; padding-bottom:0.1665in; border-bottom-style:none; } .Title { font-size:24pt; font-family:Arial; writing-mode:page; padding-left:0in; padding-right:0in; border-left-style:none; border-right-style:none; color:#333399; font-weight:bold; padding-bottom:0.1665in; padding-top:0.1665in; border-top-style:none; border-bottom-style:none; } .Title_borderEnd { font-size:24pt; margin-bottom:0.1665in; font-family:Arial; writing-mode:page; padding-left:0in; padding-right:0in; padding-bottom:0in; border-left-style:none; border-right-style:none; border-bottom-style:none; color:#333399; font-weight:bold; padding-top:0.1665in; border-top-style:none;} .Title_20_page_20_info { font-size:10pt; margin-bottom:0in; margin-top:0.0835in; font-family:Arial; writing-mode:page; color:#333399; font-weight:bold; } .Title_20_page_20_info_20_description { color:#000000; font-size:10pt; font-weight:normal; margin-bottom:0.0555in; margin-top:0in; font-family:Arial; writing-mode:page; margin-left:0.5in; margin-right:0in; text-indent:0.0008in; } .Sect1 { background-color:transparent; } .Def { font-style:italic; background-color:transparent; } .Emphasis { font-style:italic; background-color:transparent; } .ISO_20_Keyword { background-color:transparent; } .Note_20_Label { background-color:transparent; font-weight:bold; } .Strong_20_Emphasis { font-weight:bold; background-color:transparent; } .T2 { font-style:normal; font-weight:normal; } .T3 { font-style:italic; font-weight:normal; } .T4 { color:#000000; font-family:Arial; letter-spacing:normal; font-style:normal; font-weight:normal; } .T5 { color:#0000ff; font-family:Arial; letter-spacing:normal; font-style:normal; text-decoration:none ! important; font-weight:normal; } .Sect2 .Definition .T1 { } 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 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 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 http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2.pdf http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2.html Technical Committee: OASIS Open Document Format for Office Applications (OpenDocument) TC Chairs: Rob Weir IBM Michael Brauer Oracle Corporation Editors: Patrick Durusau Michael Brauer Oracle Corporation Related work: This specification supersedes OASIS OpenDocument v1.1 [ODF11] This specification consists of this document as well as the following documents, schemas and ontologies: OpenDocument v1.2 part 1: OpenDocument Schema OpenDocument v1.2 part 2: Recalculated Formula (OpenFormula) Format OpenDocument v1.2 part 3: Packages OpenDocument v1.2 Relax NG Schema OpenDocument v1.2 Manifest Schema OpenDocument v1.2 Digital Signature Schema OpenDocument v1.2 Metadata Manifest Ontology OpenDocument v1.2 Package Metadata Manifest Ontology Declared XML namespaces: urn:oasis:names:tc:opendocument:xmlns:animation:1.0 http://docs.oasis-open.org/ns/office/1.2/meta/odf# http://docs.oasis-open.org/ns/office/1.2/meta/pkg# Abstract: This specification consists of this document as well as the following three parts: Part 1 defines an XML schema for office applications and its semantics. The schema is suitable for office documents, including text documents, spreadsheets, charts and graphical documents like drawings or presentations, but is not restricted to these kinds of documents. Part 2 defines a formula language to be used in OpenDocument documents. Part 3 defines a package format to be used for OpenDocument documents. Status: This document was last revised or approved by the OASIS Open Document Format for Office Applications (OpenDocument) TC on the above date. The level of approval is also listed above. Check the "Latest version" location noted above for possible later revisions of this document. Technical Committee members should send comments on this specification to the Technical Committee’s email list. Others should send comments to the Technical Committee by using the “ Send A Comment ” button on the Technical Committee’s web page at http://www.oasis-open.org/committees/office/ . For information on whether any patents have been disclosed that may be essential to implementing this specification, and any offers of patent licensing terms, please refer to the Intellectual Property Rights section of the Technical Committee web page ( http://www.oasis-open.org/committees/office/ipr.php ). Citation format: When referencing this specification the following citation format should be used: OpenDocument-v1.2 Open Document Format for Office Applications ( OpenDocument ) Version 1.2 . 29 September 2011 . OASIS Standard. http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os.html Notices Copyright © OASIS Open 2002–2011. All Rights Reserved. All capitalized terms in the following text have the meanings assigned to them in the OASIS Intellectual Property Rights Policy (the "OASIS IPR Policy"). The full Policy 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 http://www.oasis-open.org/who/trademark.php Table of Contents 1 Introduction 1.1 Scope 1.2 Terminology 1.3 Normative References 1.4 Non Normative References 2 Conformance Appendix A. Changes From Previous Specification Versions (Non Normative) A.1. Changes from “Open Document Format for Office Applications (OpenDocument) v1.1” Appendix B. Acknowledgments (Non Normative) Table of Contents Part 1 1 Introduction 1.1 Introduction 1.2 Terminology 1.3 Normative References 1.4 Non Normative References 1.5 Namespaces 2 OpenDocument Documents, Consumers and Producers 2.1 Introduction 2.2 Documents 2.2.1 OpenDocument Document 2.2.2 OpenDocument Extended Document 2.2.3 OpenDocument Text Document 2.2.4 OpenDocument Spreadsheet Document 2.2.5 OpenDocument Drawing Document 2.2.6 OpenDocument Presentation Document 2.2.7 OpenDocument Chart Document 2.2.8 OpenDocument Image Document 2.2.9 OpenDocument Formula Document 2.2.10 OpenDocument Database Front End Document 2.3 Producers 2.3.1 OpenDocument Producer 2.3.2 OpenDocument Extended Producer 2.4 Consumer 3 Document Structure 3.1 Document Representation 3.1.1 General 3.1.2 <office:document>(Single OpenDocument XML Files) 3.1.3 Package OpenDocument Files 3.1.3.1 General 3.1.3.2 <office:document-content> 3.1.3.3 <office:document-styles> 3.1.3.4 <office:document-meta> 3.1.3.5 <office:document-settings> 3.1.4 Summary of Document Representation 3.2 <office:meta> 3.3 <office:body> 3.4 <office:text> 3.5 <office:drawing> 3.6 <office:presentation> 3.7 <office:spreadsheet> 3.8 <office:chart> 3.9 <office:image> 3.10 <office:settings> 3.10.1 General 3.10.2 <config:config-item-set> 3.10.3 <config:config-item> 3.10.4 <config:config-item-map-indexed> 3.10.5 <config:config-item-map-entry> 3.10.6 <config:config-item-map-named> 3.11 Cursor Position Setting 3.12 <office:scripts> 3.13 <office:script> 3.14 <office:font-face-decls> 3.15 Styles 3.15.1 General 3.15.2 <office:styles> 3.15.3 <office:automatic-styles> 3.15.4 <office:master-styles> 3.16 Document Signatures 3.17 Foreign Elements and Attributes 3.18 White Space Processing and EOL Handling 3.19 MIME Types and File Name Extensions 4 Metadata 4.1 General 4.2 RDF Metadata 4.2.1 In Content Metadata (RDFa) 4.2.2 manifest.rdf 4.2.2.1 General 4.2.2.2 odf:ContentFile 4.2.2.3 odf:StylesFile 4.2.2.4 odf:Element 4.2.2.5 odf:prefix 4.2.2.6 odf:suffix 4.3 Non-RDF Metadata 4.3.1 General 4.3.2 Pre-Defined Metadata Elements 4.3.2.1 <meta:generator> 4.3.2.2 <dc:title> 4.3.2.3 <dc:description> 4.3.2.4 <dc:subject> 4.3.2.5 <meta:keyword> 4.3.2.6 <meta:initial-creator> 4.3.2.7 <dc:creator> 4.3.2.8 <meta:printed-by> 4.3.2.9 <meta:creation-date> 4.3.2.10 <dc:date> 4.3.2.11 <meta:print-date> 4.3.2.12 <meta:template> 4.3.2.13 <meta:auto-reload> 4.3.2.14 <meta:hyperlink-behaviour> 4.3.2.15 <dc:language> 4.3.2.16 <meta:editing-cycles> 4.3.2.17 <meta:editing-duration> 4.3.2.18 <meta:document-statistic> 4.3.3 <meta:user-defined> 5 Text Content 5.1 Headings, Paragraphs and Basic Text Structure 5.1.1 General 5.1.2 <text:h> 5.1.3 <text:p> 5.2 <text:page-sequence> 5.2.1 General 5.2.2 <text:page> 5.3 Lists 5.3.1 <text:list> 5.3.2 Default List Style 5.3.3 <text:list-header> 5.3.4 <text:list-item> 5.3.5 List Item Style Rules 5.3.6 <text:numbered-paragraph> 5.3.7 Numbered Paragraph Style Rules 5.4 <text:section> 5.4.1 General 5.4.2 <text:section-source> 5.5 Change Tracking 5.5.1 <text:tracked-changes> 5.5.2 <text:changed-region> 5.5.3 <text:insertion> 5.5.4 <text:deletion> 5.5.5 <text:format-change> 5.5.6 <office:change-info> 5.5.7 Change Marks 5.5.7.1 General 5.5.7.2 <text:change-start> 5.5.7.3 <text:change-end> 5.5.7.4 <text:change> 5.6 <text:soft-page-break> 5.7 Document Declarations 6 Paragraph Elements Content 6.1 Basic Text Content 6.1.1 General 6.1.2 White Space Characters 6.1.3 <text:s> 6.1.4 <text:tab> 6.1.5 <text:line-break> 6.1.6 Soft Hyphens, Hyphens, and Non-breaking Spaces 6.1.7 <text:span> 6.1.8 <text:a> 6.1.9 <text:meta> 6.1.10 <text:number> 6.2 Bookmarks and References 6.2.1 Bookmarks 6.2.1.1 General 6.2.1.2 <text:bookmark> 6.2.1.3 <text:bookmark-start> 6.2.1.4 <text:bookmark-end> 6.2.2 References 6.2.2.1 General 6.2.2.2 <text:reference-mark> 6.2.2.3 <text:reference-mark-start> 6.2.2.4 <text:reference-mark-end> 6.3 Notes 6.3.1 General 6.3.2 <text:note> 6.3.3 <text:note-citation> 6.3.4 <text:note-body> 6.4 <text:ruby> 6.4.1 General 6.4.2 <text:ruby-base> 6.4.3 <text:ruby-text> 7 Text Fields 7.1 General 7.2 Common Characteristics of Field Elements 7.3 Document Fields 7.3.1 General 7.3.2 <text:date> 7.3.3 <text:time> 7.3.4 <text:page-number> 7.3.5 <text:page-continuation> 7.3.6 Subsequent Author Fields 7.3.6.1 General 7.3.6.2 <text:sender-firstname> 7.3.6.3 <text:sender-lastname> 7.3.6.4 <text:sender-initials> 7.3.6.5 <text:sender-title> 7.3.6.6 <text:sender-position> 7.3.6.7 <text:sender-email> 7.3.6.8 <text:sender-phone-private> 7.3.6.9 <text:sender-fax> 7.3.6.10 <text:sender-company> 7.3.6.11 <text:sender-phone-work> 7.3.6.12 <text:sender-street> 7.3.6.13 <text:sender-city> 7.3.6.14 <text:sender-postal-code> 7.3.6.15 <text:sender-country> 7.3.6.16 <text:sender-state-or-province> 7.3.7 Author Fields 7.3.7.1 <text:author-name> 7.3.7.2 <text:author-initials> 7.3.8 <text:chapter> 7.3.9 <text:file-name> 7.3.10 <text:template-name> 7.3.11 <text:sheet-name> 7.4 Variable Fields 7.4.1 General 7.4.2 <text:variable-decls> 7.4.3 <text:variable-decl> 7.4.4 <text:variable-set> 7.4.5 <text:variable-get> 7.4.6 <text:variable-input> 7.4.7 <text:user-field-decls> 7.4.8 <text:user-field-decl> 7.4.9 <text:user-field-get> 7.4.10 <text:user-field-input> 7.4.11 <text:sequence-decls> 7.4.12 <text:sequence-decl> 7.4.13 <text:sequence> 7.4.14 <text:expression> 7.4.15 <text:text-input> 7.5 Metadata Fields 7.5.1 General 7.5.2 <text:initial-creator> 7.5.3 <text:creation-date> 7.5.4 <text:creation-time> 7.5.5 <text:description> 7.5.6 <text:user-defined> 7.5.7 <text:print-time> 7.5.8 <text:print-date> 7.5.9 <text:printed-by> 7.5.10 <text:title> 7.5.11 <text:subject> 7.5.12 <text:keywords> 7.5.13 <text:editing-cycles> 7.5.14 <text:editing-duration> 7.5.15 <text:modification-time> 7.5.16 <text:modification-date> 7.5.17 <text:creator> 7.5.18 Document Statistics Fields 7.5.18.1 General 7.5.18.2 <text:page-count> 7.5.18.3 <text:paragraph-count> 7.5.18.4 <text:word-count> 7.5.18.5 <text:character-count> 7.5.18.6 <text:table-count> 7.5.18.7 <text:image-count> 7.5.18.8 <text:object-count> 7.5.19 <text:meta-field> 7.6 Database Fields 7.6.1 General 7.6.2 <form:connection-resource> 7.6.3 <text:database-display> 7.6.4 <text:database-next> 7.6.5 <text:database-row-select> 7.6.6 <text:database-row-number> 7.6.7 <text:database-name> 7.7 More Fields 7.7.1 Page Variable Fields 7.7.1.1 General 7.7.1.2 <text:page-variable-set> 7.7.1.3 <text:page-variable-get> 7.7.2 <text:placeholder> 7.7.3 <text:conditional-text> 7.7.4 <text:hidden-text> 7.7.5 <text:reference-ref> 7.7.6 <text:bookmark-ref> 7.7.7 <text:note-ref> 7.7.8 <text:sequence-ref> 7.7.9 <text:script> 7.7.10 <text:execute-macro> 7.7.11 <text:hidden-paragraph> 7.7.12 <text:dde-connection> 7.7.13 <text:measure> 7.7.14 <text:table-formula> (deprecated) 8 Text Indexes 8.1 Index Marks 8.1.1 General 8.1.2 <text:toc-mark-start> 8.1.3 <text:toc-mark-end> 8.1.4 <text:toc-mark> 8.1.5 <text:user-index-mark-start> 8.1.6 <text:user-index-mark-end> 8.1.7 <text:user-index-mark> 8.1.8 <text:alphabetical-index-mark-start> 8.1.9 <text:alphabetical-index-mark-end> 8.1.10 <text:alphabetical-index-mark> 8.1.11 <text:bibliography-mark> 8.2 Index Structure 8.2.1 General 8.2.2 <text:index-body> 8.2.3 <text:index-title> 8.3 <text:table-of-content> 8.3.1 General 8.3.2 <text:table-of-content-source> 8.3.3 <text:table-of-content-entry-template> 8.4 <text:illustration-index> 8.4.1 General 8.4.2 <text:illustration-index-source> 8.4.3 <text:illustration-index-entry-template> 8.5 <text:table-index> 8.5.1 General 8.5.2 <text:table-index-source> 8.5.3 <text:table-index-entry-template> 8.6 <text:object-index> 8.6.1 General 8.6.2 <text:object-index-source> 8.6.3 <text:object-index-entry-template> 8.7 <text:user-index> 8.7.1 General 8.7.2 <text:user-index-source> 8.7.3 <text:user-index-entry-template> 8.8 <text:alphabetical-index> 8.8.1 General 8.8.2 <text:alphabetical-index-source> 8.8.3 <text:alphabetical-index-auto-mark-file> 8.8.4 <text:alphabetical-index-entry-template> 8.9 <text:bibliography> 8.9.1 General 8.9.2 <text:bibliography-source> 8.9.3 <text:bibliography-entry-template> 8.10 <text:index-source-styles> 8.11 <text:index-source-style> 8.12 <text:index-title-template> 8.13 Index Template Entries 8.13.1 <text:index-entry-chapter> 8.13.2 <text:index-entry-text> 8.13.3 <text:index-entry-page-number> 8.13.4 <text:index-entry-span> 8.13.5 <text:index-entry-bibliography> 8.13.6 <text:index-entry-tab-stop> 8.13.7 <text:index-entry-link-start> 8.13.8 <text:index-entry-link-end> 9 Tables 9.1 Basic Tables 9.1.1 General 9.1.2 <table:table> 9.1.3 <table:table-row> 9.1.4 <table:table-cell> 9.1.5 <table:covered-table-cell> 9.1.6 <table:table-column> 9.1.7 <table:table-header-rows> 9.1.8 <table:table-rows> 9.1.9 <table:table-row-group> 9.1.10 <table:table-column-group> 9.1.11 <table:table-header-columns> 9.1.12 <table:table-columns> 9.1.13 <table:title> 9.1.14 <table:desc> 9.2 Advanced Tables 9.2.1 Referencing Table Cells 9.2.2 Absolute and relative cell addressing 9.2.3 Cell Range Address 9.2.4 Column and Row Range Addresses 9.2.5 Cell Range Address List 9.2.6 <table:table-source> 9.2.7 <table:scenario> 9.2.8 <table:shapes> 9.3 Advanced Table Cells 9.3.1 <table:cell-range-source> 9.3.2 <table:detective> 9.3.3 <table:operation> 9.3.4 <table:highlighted-range> 9.4 Spreadsheet Document Content 9.4.1 <table:calculation-settings> 9.4.2 <table:null-date> 9.4.3 <table:iteration> 9.4.4 <table:content-validations> 9.4.5 <table:content-validation> 9.4.6 <table:help-message> 9.4.7 <table:error-message> 9.4.8 <table:error-macro> 9.4.9 <table:label-range> 9.4.10 <table:label-ranges> 9.4.11 <table:named-expressions> 9.4.12 <table:named-range> 9.4.13 <table:named-expression> 9.4.14 <table:database-ranges> 9.4.15 <table:database-range> 9.4.16 <table:database-source-sql> 9.4.17 <table:database-source-table> 9.4.18 <table:database-source-query> 9.4.19 <table:sort> 9.4.20 <table:sort-by> 9.4.21 <table:subtotal-rules> 9.4.22 <table:sort-groups> 9.4.23 <table:subtotal-rule> 9.4.24 <table:subtotal-field> 9.5 Filters 9.5.1 General 9.5.2 <table:filter> 9.5.3 <table:filter-and> 9.5.4 <table:filter-or> 9.5.5 <table:filter-condition> 9.5.6 <table:filter-set-item> 9.6 Data Pilot Tables 9.6.1 General 9.6.2 <table:data-pilot-tables> 9.6.3 <table:data-pilot-table> 9.6.4 Data Pilot Table Source 9.6.5 <table:source-cell-range> 9.6.6 <table:source-service> 9.6.7 <table:data-pilot-field> 9.6.8 <table:data-pilot-level> 9.6.9 <table:data-pilot-subtotals> 9.6.10 <table:data-pilot-subtotal> 9.6.11 <table:data-pilot-members> 9.6.12 <table:data-pilot-member> 9.6.13 <table:data-pilot-display-info> 9.6.14 <table:data-pilot-sort-info> 9.6.15 <table:data-pilot-layout-info> 9.6.16 <table:data-pilot-field-reference> 9.6.17 <table:data-pilot-groups> 9.6.18 <table:data-pilot-group> 9.6.19 <table:data-pilot-group-member> 9.7 <table:consolidation> 9.8 <table:dde-links> 9.9 Change Tracking in Spreadsheets 9.9.1 General 9.9.2 <table:tracked-changes> 9.9.3 <table:insertion> 9.9.4 <table:dependencies> 9.9.5 <table:dependency> 9.9.6 <table:deletions> 9.9.7 <table:cell-content-deletion> 9.9.8 <table:change-deletion> 9.9.9 <table:deletion> 9.9.10 <table:cut-offs> 9.9.11 <table:insertion-cut-off> 9.9.12 <table:movement-cut-off> 9.9.13 <table:movement> 9.9.14 <table:source-range-address> 9.9.15 <table:target-range-address> 9.9.16 <table:change-track-table-cell> 9.9.17 <table:cell-content-change> 9.9.18 <table:cell-address> 9.9.19 <table:previous> 10 Graphic Content 10.1 General 10.2 Enhanced Page Features for Graphical Applications 10.2.1 <style:handout-master> 10.2.2 <draw:layer-set> 10.2.3 <draw:layer> 10.2.4 <draw:page> 10.2.5 <draw:equation> 10.3 Drawing Shapes 10.3.1 General 10.3.2 <draw:rect> 10.3.3 <draw:line> 10.3.4 <draw:polyline> 10.3.5 <draw:polygon> 10.3.6 <draw:regular-polygon> 10.3.7 <draw:path> 10.3.8 <draw:circle> 10.3.9 <draw:ellipse> 10.3.10 <draw:connector> 10.3.11 <draw:caption> 10.3.12 <draw:measure> 10.3.13 <draw:control> 10.3.14 <draw:page-thumbnail> 10.3.15 <draw:g> 10.3.16 <draw:glue-point> 10.3.17 <svg:title> 10.3.18 <svg:desc> 10.3.19 <office:event-listeners> 10.4 Frames 10.4.1 General 10.4.2 <draw:frame> 10.4.3 <draw:text-box> 10.4.4 <draw:image> 10.4.5 <office:binary-data> 10.4.6 Objects 10.4.6.1 General 10.4.6.2 <draw:object> 10.4.6.3 <draw:object-ole> 10.4.7 <draw:applet> 10.4.8 <draw:plugin> 10.4.9 <draw:param> 10.4.10 <draw:floating-frame> 10.4.11 Contours 10.4.11.1 General 10.4.11.2 <draw:contour-polygon> 10.4.11.3 <draw:contour-path> 10.4.12 <draw:a> 10.4.13 Client Side Image Maps 10.4.13.1 General 10.4.13.2 <draw:image-map> 10.4.13.3 <draw:area-rectangle> 10.4.13.4 <draw:area-circle> 10.4.13.5 <draw:area-polygon> 10.5 3D Shapes 10.5.1 General 10.5.2 <dr3d:scene> 10.5.3 <dr3d:light> 10.5.4 <dr3d:cube> 10.5.5 <dr3d:sphere> 10.5.6 <dr3d:extrude> 10.5.7 <dr3d:rotate> 10.6 Custom Shape 10.6.1 <draw:custom-shape> 10.6.2 <draw:enhanced-geometry> 10.6.3 <draw:handle> 10.7 Presentation Shapes 10.8 Presentation Animations 10.8.1 <presentation:animations> 10.8.2 <presentation:sound> 10.8.3 <presentation:show-shape> 10.8.4 <presentation:show-text> 10.8.5 <presentation:hide-shape> 10.8.6 <presentation:hide-text> 10.8.7 <presentation:dim> 10.8.8 <presentation:play> 10.8.9 <presentation:animation-group> 10.9 SMIL Presentation Animations 10.9.1 General 10.9.2 <presentation:event-listener> 10.9.3 Presentation Document Content 10.9.3.1 <presentation:header> 10.9.3.2 <presentation:header-decl> 10.9.3.3 <presentation:footer> 10.9.3.4 <presentation:footer-decl> 10.9.3.5 <presentation:date-time> 10.9.3.6 <presentation:date-time-decl> 10.9.3.7 <presentation:settings> 10.9.3.8 <presentation:show> 11 Chart Content 11.1 <chart:chart> 11.2 Title, Subtitle and Footer 11.2.1 <chart:title> 11.2.2 <chart:subtitle> 11.2.3 <chart:footer> 11.3 <chart:legend> 11.4 <chart:plot-area> 11.5 3D Plot Area 11.6 <chart:wall> 11.7 <chart:floor> 11.8 <chart:axis> 11.9 <chart:categories> 11.10 <chart:grid> 11.11 <chart:series> 11.12 <chart:domain> 11.13 <chart:data-point> 11.14 <chart:data-label> 11.15 <chart:mean-value> 11.16 <chart:error-indicator> 11.17 <chart:regression-curve> 11.18 <chart:equation> 11.19 <chart:stock-gain-marker> 11.20 <chart:stock-loss-marker> 11.21 <chart:stock-range-line> 12 Database Front-end Document Content 12.1 <office:database> 12.2 <db:data-source> 12.3 <db:connection-data> 12.4 <db:database-description> 12.5 <db:file-based-database> 12.6 <db:server-database> 12.7 <db:connection-resource> 12.8 <db:login> 12.9 <db:driver-settings> 12.10 <db:auto-increment> 12.11 <db:delimiter> 12.12 <db:character-set> 12.13 <db:table-settings> 12.14 <db:table-setting> 12.15 <db:application-connection-settings> 12.16 <db:table-filter> 12.17 <db:table-include-filter> 12.18 <db:table-exclude-filter> 12.19 <db:table-filter-pattern> 12.20 <db:table-type-filter> 12.21 <db:table-type> 12.22 <db:data-source-settings> 12.23 <db:data-source-setting> 12.24 <db:data-source-setting-value> 12.25 Forms and Reports 12.25.1 General 12.25.2 <db:forms> 12.25.3 <db:reports> 12.25.4 <db:component-collection> 12.25.5 <db:component> 12.26 <db:queries> 12.27 <db:query-collection> 12.28 <db:query> 12.29 <db:order-statement> 12.30 <db:filter-statement> 12.31 <db:update-table> 12.32 <db:table-representations> 12.33 <db:table-representation> 12.34 <db:columns> 12.35 <db:column> 12.36 <db:schema-definition> 12.37 <db:table-definitions> 12.38 <db:table-definition> 12.39 <db:column-definitions> 12.40 <db:column-definition> 12.41 <db:keys> 12.42 <db:key> 12.43 <db:key-columns> 12.44 <db:key-column> 12.45 <db:indices> 12.46 <db:index> 12.47 <db:index-columns> 12.48 <db:index-column> 13 Form Content 13.1 General 13.2 <office:forms> 13.3 <form:form> 13.4 <xforms:model> 13.5 Controls 13.5.1 General 13.5.2 <form:text> 13.5.3 <form:textarea> 13.5.4 <form:password> 13.5.5 <form:file> 13.5.6 <form:formatted-text> 13.5.7 <form:number> 13.5.8 <form:date> 13.5.9 <form:time> 13.5.10 <form:fixed-text> 13.5.11 <form:combobox> 13.5.12 <form:item> 13.5.13 <form:listbox> 13.5.14 <form:option> 13.5.15 <form:button> 13.5.16 <form:image> 13.5.17 <form:checkbox> 13.5.18 <form:radio> 13.5.19 <form:frame> 13.5.20 <form:image-frame> 13.5.21 <form:hidden> 13.5.22 <form:grid> 13.5.23 <form:column> 13.5.24 <form:value-range> 13.5.25 <form:generic-control> 13.6 Event Listeners 13.7 <form:properties> 13.8 <form:property> 13.9 <form:list-property> 13.10 <form:list-value> 14 Common Content 14.1 <office:annotation> 14.2 <office:annotation-end> 14.3 <meta:date-string> 14.4 Event Listener Tables 14.4.1 General 14.4.2 <script:event-listener> 14.4.3 Event Types 14.4.4 Macro Name and Location 14.5 <math:math> 14.6 DDE Connections 14.6.1 General 14.6.2 <text:dde-connection-decls> 14.6.3 <text:dde-connection-decl> 14.6.4 <table:dde-link> 14.6.5 <office:dde-source> 15 SMIL Animations 15.1 General 15.2 Basic Animation Elements 15.2.1 General 15.2.2 <anim:animate> 15.2.3 <anim:animateTransform> 15.2.4 <anim:set> 15.2.5 <anim:animateMotion> 15.2.6 <anim:animateColor> 15.2.7 <anim:transitionFilter> 15.3 Animation Model Attributes 15.3.1 General 15.3.2 Simple Animation Functions 15.4 Animation Timing 15.4.1 General 15.4.2 <anim:par> 15.4.3 <anim:seq> 15.4.4 <anim:iterate> 15.5 <anim:audio> 15.6 Animation Command Elements 15.6.1 <anim:command> 15.6.2 <anim:param> 16 Styles 16.1 General 16.2 <style:style> 16.3 <style:map> 16.4 <style:default-style> 16.5 <style:page-layout> 16.6 <style:header-style> 16.7 <style:footer-style> 16.8 <style:default-page-layout> 16.9 <style:master-page> 16.10 <style:header> 16.11 <style:footer> 16.12 <style:header-left> 16.13 <style:footer-left> 16.14 <style:region-left> 16.15 <style:region-center> 16.16 <style:region-right> 16.17 <presentation:notes> 16.18 <table:table-template> 16.19 Cell Styles 16.19.1 General 16.19.2 <table:first-row> 16.19.3 <table:last-row> 16.19.4 <table:first-column> 16.19.5 <table:last-column> 16.19.6 <table:body> 16.19.7 <table:even-rows> 16.19.8 <table:odd-rows> 16.19.9 <table:even-columns> 16.19.10 <table:odd-columns> 16.20 <table:background> 16.21 <style:font-face> 16.22 <svg:font-face-src> 16.23 <svg:font-face-name> 16.24 <svg:font-face-uri> 16.25 <svg:definition-src> 16.26 <svg:font-face-format> 16.27 Data Styles 16.27.1 General 16.27.2 <number:number-style> 16.27.3 <number:number> 16.27.4 <number:embedded-text> 16.27.5 <number:scientific-number> 16.27.6 <number:fraction> 16.27.7 <number:currency-style> 16.27.8 <number:currency-symbol> 16.27.9 <number:percentage-style> 16.27.10 <number:date-style> 16.27.11 <number:day> 16.27.12 <number:month> 16.27.13 <number:year> 16.27.14 <number:era> 16.27.15 <number:day-of-week> 16.27.16 <number:week-of-year> 16.27.17 <number:quarter> 16.27.18 <number:time-style> 16.27.19 <number:hours> 16.27.20 <number:minutes> 16.27.21 <number:seconds> 16.27.22 <number:am-pm> 16.27.23 <number:boolean-style> 16.27.24 <number:boolean> 16.27.25 <number:text-style> 16.27.26 <number:text> 16.27.27 <number:text-content> 16.27.28 <style:text-properties> 16.28 Text Style Families 16.28.1 Text Styles 16.28.2 Paragraph Styles 16.28.3 Section Styles 16.28.4 Ruby Styles 16.29 Enhanced Text Styles 16.29.1 <text:linenumbering-configuration> 16.29.2 <text:linenumbering-separator> 16.29.3 <text:notes-configuration> 16.29.4 <text:note-continuation-notice-forward> 16.29.5 <text:note-continuation-notice-backward> 16.29.6 <text:bibliography-configuration> 16.29.7 <text:sort-key> 16.30 <text:list-style> 16.31 <text:list-level-style-bullet> 16.32 <text:list-level-style-number> 16.33 <text:list-level-style-image> 16.34 <text:outline-style> 16.35 <text:outline-level-style> 16.36 Table Styles 16.36.1 Table Styles 16.36.2 Table Column Styles 16.36.3 Table Row Styles 16.36.4 Table Cell Styles 16.37 Graphic Styles 16.38 Presentation Styles 16.39 Drawing Page Style 16.40 Enhanced Graphic Style Elements 16.40.1 <draw:gradient> 16.40.2 <svg:linearGradient> 16.40.3 <svg:radialGradient> 16.40.4 <svg:stop> 16.40.5 <draw:hatch> 16.40.6 <draw:fill-image> 16.40.7 <draw:opacity> 16.40.8 <draw:marker> 16.40.9 <draw:stroke-dash> 16.41 <style:presentation-page-layout> 16.42 <presentation:placeholder> 16.43 Chart Styles 17 Formatting Elements 17.1 General 17.2 <style:page-layout-properties> 17.3 <style:background-image> 17.4 <style:footnote-sep> 17.5 <style:header-footer-properties> 17.6 <style:paragraph-properties> 17.7 <style:tab-stops> 17.8 <style:tab-stop> 17.9 <style:drop-cap> 17.10 <style:ruby-properties> 17.11 <style:section-properties> 17.12 <style:columns> 17.13 <style:column> 17.14 <style:column-sep> 17.15 <style:table-properties> 17.16 <style:table-column-properties> 17.17 <style:table-row-properties> 17.18 <style:table-cell-properties> 17.19 <style:list-level-properties> 17.20 <style:list-level-label-alignment> 17.21 <style:graphic-properties> 17.22 <style:chart-properties> 17.23 <chart:symbol-image> 17.24 <chart:label-separator> 17.25 <style:drawing-page-properties> 18 Datatypes 18.1 Introduction 18.2 W3C Schema Datatypes 18.3 Other Datatypes 18.3.1 angle 18.3.2 anyIRI 18.3.3 boolean 18.3.4 cellAddress 18.3.5 cellRangeAddress 18.3.6 cellRangeAddressList 18.3.7 character 18.3.8 clipShape 18.3.9 color 18.3.10 coordinate 18.3.11 countryCode 18.3.12 CURIE 18.3.13 CURIEs 18.3.14 dateOrDateTime 18.3.15 distance 18.3.16 language 18.3.17 languageCode 18.3.18 length 18.3.19 namespacedToken 18.3.20 nonNegativeLength 18.3.21 nonNegativePixelLength 18.3.22 pathData 18.3.23 percent 18.3.24 point3D 18.3.25 points 18.3.26 positiveLength 18.3.27 relativeLength 18.3.28 safeCURIE 18.3.29 scriptCode 18.3.30 signedZeroToHundredPercent 18.3.31 styleName 18.3.32 styleNameRef 18.3.33 styleNameRefs 18.3.34 targetFrameName 18.3.35 textEncoding 18.3.36 timeOrDateTime 18.3.37 URIorSafeCURIE 18.3.38 valueType 18.3.39 variableName 18.3.40 vector3D 18.3.41 zeroToHundredPercent 19 General Attributes 19.1 General 19.2 anim:color-interpolation 19.3 anim:color-interpolation-direction 19.4 anim:audio-level 19.5 anim:command 19.6 anim:formula 19.7 anim:id (deprecated) 19.8 anim:iterate-interval 19.9 anim:iterate-type 19.10 anim:name 19.11 anim:sub-item 19.12 anim:value 19.13 chart:attached-axis 19.14 chart:automatic-content 19.15 chart:class 19.15.1 <chart:chart>, <chart:series> 19.15.2 <chart:grid> 19.16 chart:column-mapping (deprecated) 19.17 chart:data-source-has-labels (deprecated) 19.18 chart:dimension 19.19 chart:display-equation 19.20 chart:display-r-square 19.21 chart:label-cell-address 19.22 chart:legend-align 19.23 chart:legend-position 19.24 chart:name 19.25 chart:repeated 19.26 chart:row-mapping (deprecated) 19.27 chart:style-name 19.28 chart:values-cell-range-address 19.29 config:name 19.30 config:type 19.31 db:additional-column-statement 19.32 db:append-table-alias-name 19.33 db:apply-command 19.34 db:as-template 19.35 db:base-dn 19.36 db:boolean-comparison-mode 19.37 db:catalog-name 19.38 db:command 19.39 db:data-source-setting-is-list 19.40 db:data-source-setting-name 19.41 db:data-source-setting-type 19.42 db:data-type 19.43 db:database-name 19.44 db:decimal 19.45 db:default-cell-style-name 19.46 db:default-row-style-name 19.47 db:delete-rule 19.48 db:description 19.49 db:enable-sql92-check 19.50 db:encoding 19.51 db:escape-processing 19.52 db:extension 19.53 db:field 19.54 db:hostname 19.55 db:ignore-driver-privileges 19.56 db:is-ascending 19.57 db:is-autoincrement 19.58 db:is-clustered 19.59 db:is-empty-allowed 19.60 db:is-first-row-header-line 19.61 db:login-timeout 19.62 db:is-nullable 19.63 db:is-password-required 19.64 db:is-unique 19.65 db:precision 19.66 db:is-table-name-length-limited 19.67 db:local-socket 19.68 db:max-row-count 19.69 db:media-type 19.70 db:name 19.70.1 General 19.70.2 <db:column> 19.70.3 <db:column-definition> 19.70.4 <db:component> 19.70.5 <db:component-collection> 19.70.6 <db:index> 19.70.7 <db:index-column> 19.70.8 <db:key> 19.70.9 <db:key-column> 19.70.10 <db:query> 19.70.11 <db:query-collection> 19.70.12 <db:table-definition> 19.70.13 <db:table-representation> 19.70.14 <db:update-table> 19.71 db:parameter-name-substitution 19.72 db:port 19.73 db:referenced-table-name 19.74 db:related-column-name 19.75 db:row-retrieving-statement 19.76 db:scale 19.77 db:schema-name 19.78 db:show-deleted 19.79 db:string 19.80 db:style-name 19.80.1 General 19.80.2 <db:column> 19.80.3 <db:query> 19.80.4 <db:table-representation> 19.81 db:suppress-version-columns 19.82 db:system-driver-settings 19.83 db:thousand 19.84 db:title 19.85 db:type 19.85.1 General 19.85.2 <db:key> 19.85.3 <db:server-database> 19.85.4 <db:table-definition> 19.86 db:type-name 19.87 db:update-rule 19.88 db:use-catalog 19.89 db:use-system-user 19.90 db:user-name 19.91 db:visible 19.92 dr3d:ambient-color 19.93 dr3d:center 19.94 dr3d:diffuse-color 19.95 dr3d:direction 19.96 dr3d:distance 19.97 dr3d:enabled 19.98 dr3d:focal-length 19.99 dr3d:lighting-mode 19.99.1 General 19.99.2 <chart:plot-area> 19.99.3 <dr3d:scene> 19.100 dr3d:max-edge 19.101 dr3d:min-edge 19.102 dr3d:projection 19.103 dr3d:shade-mode 19.104 dr3d:shadow-slant 19.105 dr3d:size 19.106 dr3d:specular 19.107 dr3d:transform 19.108 dr3d:vpn 19.109 dr3d:vrp 19.110 dr3d:vup 19.111 draw:align 19.112 draw:angle 19.113 draw:archive 19.114 draw:border 19.115 draw:caption-id 19.116 draw:caption-point-x 19.117 draw:caption-point-y 19.118 draw:chain-next-name 19.119 draw:class-id 19.120 draw:class-names 19.121 draw:code 19.122 draw:color 19.122.1 General 19.122.2 <draw:hatch> 19.122.3 <presentation:dim> 19.123 draw:concave 19.124 draw:concentric-gradient-fill-allowed 19.125 draw:control 19.126 draw:copy-of 19.127 draw:corner-radius 19.128 draw:corners 19.129 draw:cx 19.130 draw:cy 19.131 draw:data 19.132 draw:display 19.133 draw:display-name 19.133.1 General 19.133.2 <draw:fill-image> 19.133.3 <draw:gradient> 19.133.4 <draw:hatch> 19.133.5 <draw:marker> 19.133.6 <draw:opacity> 19.133.7 <draw:stroke-dash> 19.133.8 <svg:linearGradient> 19.133.9 <svg:radialGradient> 19.134 draw:distance 19.134.1 General 19.134.2 <draw:hatch> 19.134.3 <draw:stroke-dash> 19.135 draw:dots 19.136 draw:dots1-length 19.137 draw:dots 19.138 draw:dots2-length 19.139 draw:end 19.140 draw:end-angle 19.141 draw:end-color 19.142 draw:end-glue-point 19.143 draw:end-intensity 19.144 draw:end-shape 19.145 draw:enhanced-path 19.146 draw:engine 19.147 draw:escape-direction 19.148 draw:extrusion 19.149 draw:extrusion-allowed 19.150 draw:extrusion-brightness 19.151 draw:extrusion-color 19.152 draw:extrusion-depth 19.153 draw:extrusion-diffusion 19.154 draw:extrusion-first-light-direction 19.155 draw:extrusion-first-light-harsh 19.156 draw:extrusion-first-light-level 19.157 draw:extrusion-light-face 19.158 draw:extrusion-metal 19.159 draw:extrusion-number-of-line-segments 19.160 draw:extrusion-origin 19.161 draw:extrusion-rotation-angle 19.162 draw:extrusion-rotation-center 19.163 draw:extrusion-second-light-direction 19.164 draw:extrusion-second-light-harsh 19.165 draw:extrusion-second-light-level 19.166 draw:extrusion-shininess 19.167 draw:extrusion-skew 19.168 draw:extrusion-specularity 19.169 draw:extrusion-viewpoint 19.170 draw:filter-name 19.171 draw:formula 19.172 draw:frame-name 19.173 draw:glue-point-leaving-directions 19.174 draw:glue-point-type 19.175 draw:glue-points 19.176 draw:handle-mirror-horizontal 19.177 draw:handle-mirror-vertical 19.178 draw:handle-polar 19.179 draw:handle-position 19.180 draw:handle-radius-range-maximum 19.181 draw:handle-radius-range-minimum 19.182 draw:handle-range-x-maximum 19.183 draw:handle-range-x-minimum 19.184 draw:handle-range-y-maximum 19.185 draw:handle-range-y-minimum 19.186 draw:handle-switched 19.187 draw:id 19.187.1 General 19.187.2 <draw:glue-point> 19.187.3 <dr3d:cube>, <dr3d:extrude>, <dr3d:rotate>, <dr3d:scene>, <dr3d:sphere>, <draw:caption>, <draw:circle>, <draw:connector>, <draw:control>, <draw:custom-shape>, <draw:ellipse>, <draw:frame>, <draw:g>, <draw:line>, <draw:measure>, <draw:page>, <draw:page-thumbnail>, <draw:path>, <draw:polygon>, <draw:polyline>, <draw:rect>, <draw:regular-polygon> and <office:annotation> 19.188 draw:kind 19.189 draw:layer 19.190 draw:line-skew 19.191 draw:mime-type 19.192 draw:mirror-horizontal 19.193 draw:mirror-vertical 19.194 draw:master-page-name 19.195 draw:may-script 19.196 draw:modifiers 19.197 draw:name 19.197.1 General 19.197.2 <draw:caption> 19.197.3 <draw:circle> 19.197.4 <draw:connector> 19.197.5 <draw:control> 19.197.6 <draw:custom-shape> 19.197.7 <draw:ellipse> 19.197.8 <draw:equation> 19.197.9 <draw:fill-image> 19.197.10 <draw:frame> 19.197.11 <draw:g> 19.197.12 <draw:gradient> 19.197.13 <draw:hatch> 19.197.14 <draw:layer> 19.197.15 <draw:line> 19.197.16 <draw:marker> 19.197.17 <draw:measure> 19.197.18 <draw:opacity> 19.197.19 <draw:page> 19.197.20 <draw:page-thumbnail> 19.197.21 <draw:param> 19.197.22 <draw:path> 19.197.23 <draw:polygon> 19.197.24 <draw:polyline> 19.197.25 <draw:rect> 19.197.26 <draw:regular-polygon> 19.197.27 <draw:stroke-dash> 19.197.28 <office:annotation> (deprecated) 19.197.29 <svg:linearGradient> 19.197.30 <svg:radialGradient> 19.198 draw:nav-order 19.199 draw:nohref 19.200 draw:notify-on-update-of-ranges 19.201 draw:object 19.202 draw:opacity 19.203 draw:page-number 19.204 draw:path-stretchpoint-x 19.205 draw:path-stretchpoint-y 19.206 draw:points 19.207 draw:protected 19.208 draw:recreate-on-edit 19.209 draw:rotation 19.210 draw:shape-id 19.211 draw:sharpness 19.212 draw:start 19.213 draw:start-angle 19.214 draw:start-color 19.215 draw:start-glue-point 19.216 draw:start-intensity 19.217 draw:start-shape 19.218 draw:style 19.218.1 General 19.218.2 <draw:gradient> 19.218.3 <draw:hatch> 19.218.4 <draw:opacity> 19.218.5 <draw:stroke-dash> 19.219 draw:style-name 19.219.1 General 19.219.2 <dr3d:cube> 19.219.3 <dr3d:extrude> 19.219.4 <dr3d:rotate> 19.219.5 <dr3d:scene> 19.219.6 <dr3d:sphere> 19.219.7 <draw:caption> 19.219.8 <draw:circle> 19.219.9 <draw:connector> 19.219.10 <draw:control> 19.219.11 <draw:custom-shape> 19.219.12 <draw:ellipse> 19.219.13 <draw:frame> 19.219.14 <draw:g> 19.219.15 <draw:line> 19.219.16 <draw:measure> 19.219.17 <draw:page> 19.219.18 <draw:page-thumbnail> 19.219.19 <draw:path> 19.219.20 <draw:polygon> 19.219.21 <draw:polyline> 19.219.22 <draw:rect> 19.219.23 <draw:regular-polygon> 19.219.24 <office:annotation> 19.219.25 <presentation:notes> 19.219.26 <style:handout-master> 19.219.27 <style:master-page> 19.220 draw:text-areas 19.221 draw:text-path 19.222 draw:text-path-allowed 19.223 draw:text-path-mode 19.224 draw:text-path-same-letter-heights 19.225 draw:text-path-scale 19.226 draw:text-rotate-angle 19.227 draw:text-style-name 19.228 draw:transform 19.229 draw:type 19.229.1 General 19.229.2 <draw:connector> 19.229.3 <draw:enhanced-geometry> 19.230 draw:value 19.231 draw:z-index 19.232 fo:column-count 19.233 fo:column-gap 19.234 fo:country 19.234.1 <text:alphabetical-index-source> 19.234.2 <text:bibliography-configuration> 19.235 fo:end-indent 19.236 fo:language 19.236.1 General 19.236.2 <text:alphabetical-index-source> 19.236.3 <text:bibliography-configuration> 19.237 fo:margin-left 19.238 fo:max-height 19.239 fo:max-width 19.240 fo:min-height 19.241 fo:min-width 19.242 fo:script 19.242.1 General 19.242.2 <text:alphabetical-index-source> 19.242.3 <text:bibliography-configuration> 19.243 fo:space-after 19.244 fo:space-before 19.245 fo:start-indent 19.246 fo:text-indent 19.247 form:allow-deletes 19.248 form:allow-inserts 19.249 form:allow-updates 19.250 form:apply-design-mode 19.251 form:apply-filter 19.252 form:auto-complete 19.253 form:automatic-focus 19.254 form:bound-column 19.255 form:button-type 19.256 form:command 19.257 form:command-type 19.258 form:control-implementation 19.259 form:convert-empty-to-null 19.260 form:current-selected 19.261 form:current-state 19.262 form:current-value 19.263 form:data-field 19.264 form:datasource 19.265 form:default-button 19.266 form:delay-for-repeat 19.267 form:detail-fields 19.268 form:disabled 19.269 form:dropdown 19.270 form:echo-char 19.271 form:enctype 19.272 form:escape-processing 19.273 form:filter 19.274 form:focus-on-click 19.275 form:for 19.276 form:id (deprecated) 19.277 form:ignore-result 19.278 form:image-align 19.279 form:image-data 19.280 form:image-position 19.281 form:is-tristate 19.282 form:label 19.283 form:linked-cell 19.284 form:list-linkage-type 19.285 form:list-source 19.286 form:list-source-type 19.287 form:master-fields 19.288 form:max-length 19.289 form:max-value 19.289.1 General 19.289.2 <form:date> 19.289.3 <form:formatted-text> 19.289.4 <form:number> and <form:value-range> 19.289.5 <form:time> 19.290 form:min-value 19.290.1 General 19.290.2 <form:date> 19.290.3 <form:formatted-text> 19.290.4 <form:number> and <form:value-range> 19.290.5 <form:time> 19.291 form:method 19.292 form:multi-line 19.293 form:multiple 19.294 form:name 19.295 form:navigation-mode 19.296 form:order 19.297 form:orientation 19.298 form:page-step-size 19.299 form:printable 19.300 form:property-name 19.301 form:readonly 19.302 form:repeat 19.303 form:selected 19.304 form:size 19.305 form:source-cell-range 19.306 form:spin-button 19.307 form:state 19.308 form:step-size 19.309 form:tab-cycle 19.310 form:tab-index 19.311 form:tab-stop 19.312 form:text-style-name 19.313 form:title 19.314 form:toggle 19.315 form:validation 19.316 form:value 19.316.1 General 19.316.2 <form:button> 19.316.3 <form:date> 19.316.4 <form:number> and <form:value-range> 19.316.5 <form:checkbox>, <form:combobox>, <form:file>, <form:formatted-text>, <form:hidden>, <form:image>, <form:option>, <form:password>, <form:radio>, <form:text>, <form:textarea> 19.316.6 <form:time> 19.317 form:visual-effect 19.318 form:xforms-list-source 19.319 form:xforms-submission 19.320 grddl:transformation 19.321 meta:cell-count 19.322 meta:character-count 19.323 meta:date 19.324 meta:delay 19.325 meta:draw-count 19.326 meta:frame-count 19.327 meta:image-count 19.328 meta:name 19.329 meta:non-whitespace-character-count 19.330 meta:object-count 19.331 meta:ole-object-count 19.332 meta:page-count 19.333 meta:paragraph-count 19.334 meta:row-count 19.335 meta:sentence-count 19.336 meta:syllable-count 19.337 meta:table-count 19.338 meta:value-type 19.339 meta:word-count 19.340 number:automatic-order 19.341 number:calendar 19.342 number:country 19.343 number:decimal-places 19.343.1 General 19.343.2 <number:number> 19.343.3 <number:seconds> 19.343.4 <number:scientific-number> 19.344 number:decimal-replacement 19.345 number:denominator-value 19.346 number:display-factor 19.347 number:format-source 19.348 number:grouping 19.349 number:language 19.350 number:min-denominator-digits 19.351 number:min-exponent-digits 19.352 number:min-integer-digits 19.353 number:min-numerator-digits 19.354 number:position 19.355 number:possessive-form 19.356 number:rfc-language-tag 19.357 number:script 19.358 number:style 19.358.1 General 19.358.2 <number:day> 19.358.3 <number:day-of-week> 19.358.4 <number:era> 19.358.5 <number:hours> 19.358.6 <number:minutes> 19.358.7 <number:month> 19.358.8 <number:quarter> 19.358.9 <number:seconds> 19.358.10 <number:year> 19.359 number:textual 19.360 number:title 19.361 number:transliteration-country 19.362 number:transliteration-format 19.363 number:transliteration-language 19.364 number:transliteration-style 19.365 number:truncate-on-overflow 19.366 office:automatic-update 19.367 office:boolean-value 19.368 office:conversion-mode 19.369 office:currency 19.370 office:date-value 19.371 office:dde-application 19.372 office:dde-item 19.373 office:dde-topic 19.374 office:display 19.375 office:mimetype 19.376 office:name 19.376.1 General 19.376.2 <draw:a> 19.376.3 <draw:area-circle> 19.376.4 <draw:area-rectangle> 19.376.5 <draw:area-polygon> 19.376.6 <office:annotation> 19.376.7 <office:annotation-end> 19.376.8 <office:dde-source> 19.376.9 <text:a> 19.376.10 <text:dde-connection-decl> 19.377 office:process-content (deprecated) 19.378 office:server-map 19.379 office:string-value 19.380 office:target-frame 19.381 office:target-frame-name 19.382 office:time-value 19.383 office:title 19.384 office:value 19.385 office:value-type 19.386 office:version 19.387 presentation:action 19.388 presentation:animations 19.389 presentation:class 19.390 presentation:class-names 19.391 presentation:delay 19.392 presentation:direction 19.393 presentation:endless 19.394 presentation:effect 19.395 presentation:force-manual 19.396 presentation:full-screen 19.397 presentation:group-id 19.398 presentation:master-element 19.399 presentation:mouse-as-pen 19.400 presentation:mouse-visible 19.401 presentation:name 19.402 presentation:node-type 19.403 presentation:object 19.404 presentation:pages 19.405 presentation:path-id 19.406 presentation:pause 19.407 presentation:placeholder 19.408 presentation:play-full 19.409 presentation:presentation-page-layout-name 19.410 presentation:preset-class 19.411 presentation:preset-id 19.412 presentation:preset-sub-type 19.413 presentation:show 19.414 presentation:show-end-of-presentation-slide 19.415 presentation:show-logo 19.416 presentation:source 19.417 presentation:speed 19.418 presentation:start-scale 19.419 presentation:start-page 19.420 presentation:start-with-navigator 19.421 presentation:stay-on-top 19.422 presentation:style-name 19.423 presentation:transition-on-click 19.424 presentation:use-date-time-name 19.425 presentation:use-footer-name 19.426 presentation:use-header-name 19.427 presentation:user-transformed 19.428 presentation:verb 19.429 script:event-name 19.430 script:language 19.431 script:macro-name 19.432 smil:accelerate 19.433 smil:accumulate 19.434 smil:additive 19.435 smil:attributeName 19.436 smil:autoReverse 19.437 smil:begin 19.438 smil:by 19.439 smil:calcMode 19.440 smil:decelerate 19.441 smil:direction 19.442 smil:dur 19.443 smil:end 19.444 smil:endsync 19.445 smil:fadeColor 19.446 smil:fill 19.447 smil:fillDefault 19.448 smil:from 19.449 smil:keySplines 19.450 smil:keyTimes 19.451 smil:mode 19.452 smil:repeatCount 19.453 smil:repeatDur 19.454 smil:restart 19.455 smil:restartDefault 19.456 smil:subtype 19.457 smil:targetElement 19.458 smil:to 19.459 smil:type 19.460 smil:values 19.461 style:adjustment 19.462 style:apply-style-name 19.463 style:auto-update 19.464 style:base-cell-address 19.465 style:char 19.466 style:class 19.467 style:color 19.468 style:condition 19.469 style:data-style-name 19.469.1 General 19.469.2 <presentation:date-time-decl> 19.469.3 <style:style> 19.469.4 <text:creation-date> 19.469.5 <text:creation-time> 19.469.6 <text:database-display> 19.469.7 <text:date> 19.469.8 <text:editing-duration> 19.469.9 <text:expression> 19.469.10 <text:meta-field> 19.469.11 <text:modification-date> 19.469.12 <text:modification-time> 19.469.13 <text:print-date> 19.469.14 <text:print-time> 19.469.15 <text:table-formula> 19.469.16 <text:time> 19.469.17 <text:user-defined> 19.469.18 <text:user-field-get> 19.469.19 <text:user-field-input> 19.469.20 <text:variable-get> 19.469.21 <text:variable-input> 19.469.22 <text:variable-set> 19.470 style:default-outline-level 19.471 style:display 19.472 style:display-name 19.473 style:distance 19.474 style:distance-before-sep 19.475 style:distance-after-sep 19.476 style:family 19.477 style:filter-name 19.478 style:font-adornments 19.479 style:font-charset 19.480 style:font-family-generic 19.481 style:font-pitch 19.482 style:height 19.483 style:leader-char 19.484 style:leader-color 19.485 style:leader-style 19.486 style:leader-text 19.487 style:leader-text-style 19.488 style:leader-type 19.489 style:leader-width 19.490 style:legend-expansion 19.491 style:legend-expansion-aspect-ratio 19.492 style:length 19.493 style:line-style 19.494 style:lines 19.495 style:list-level 19.496 style:list-style-name 19.497 style:master-page-name 19.498 style:name 19.498.1 General 19.498.2 <number:boolean-style>, <number:currency-style>, <number:date-style>, <number:number-style>, <number:percentage-style>, <number:text-style>, <number:time-style>, <style:master-page>, <style:page-layout>, <style:presentation-page-layout>, <style:style>, <text:list-style>, <text:outline-style> 19.498.3 <style:font-face> 19.499 style:next-style-name 19.499.1 General 19.499.2 <style:master-page> 19.499.3 <style:style> 19.500 style:num-format 19.501 style:num-letter-sync 19.502 style:num-prefix 19.503 style:num-suffix 19.504 style:page-layout-name 19.505 style:page-usage 19.506 style:parent-style-name 19.507 style:percentage-data-style-name 19.508 style:position 19.508.1 General 19.508.2 <style:background-image> 19.508.3 <style:tab-stop> 19.508.4 <text:index-entry-tab-stop> 19.509 style:rel-height 19.510 style:rel-width 19.510.1 General 19.510.2 <draw:frame> 19.510.3 <style:column> 19.510.4 <style:footnote-sep> 19.511 style:repeat 19.512 style:rfc-language-tag 19.513 style:style 19.514 style:style-name 19.515 style:type 19.515.1 General 19.515.2 <text:index-entry-tab-stop> 19.515.3 <style:tab-stop> 19.516 style:vertical-align 19.517 style:volatile 19.518 style:width 19.518.1 General 19.518.2 <style:column-sep> 19.518.3 <style:footnote-sep> 19.519 svg:accent-height 19.520 svg:alphabetic 19.521 svg:ascent 19.522 svg:bbox 19.523 svg:cap-height 19.524 svg:cx 19.524.1 <draw:area-circle> 19.524.2 <draw:circle> 19.524.3 <draw:ellipse> 19.524.4 <svg:radialGradient> 19.525 svg:cy 19.525.1 <draw:area-circle> 19.525.2 <draw:circle> 19.525.3 <draw:ellipse> 19.525.4 <svg:radialGradient> 19.526 svg:d 19.527 svg:descent 19.528 svg:font-family 19.529 svg:font-size 19.530 svg:font-stretch 19.531 svg:font-style 19.532 svg:font-variant 19.533 svg:font-weight 19.534 svg:fx 19.535 svg:fy 19.536 svg:gradientTransform 19.537 svg:gradientUnits 19.538 svg:hanging 19.539 svg:height 19.539.1 <chart:chart> 19.539.2 <chart:plot-area> 19.539.3 <dr3d:scene> 19.539.4 <draw:area-polygon> 19.539.5 <draw:area-rectangle> 19.539.6 <draw:contour-polygon>, <draw:contour-path> 19.539.7 <draw:fill-image> 19.539.8 <draw:caption>, <draw:custom-shape>, <draw:circle>, <draw:control>, <draw:ellipse>, <draw:frame>, <draw:rect>, <draw:page-thumbnail>, <draw:path>, <draw:polygon>, <draw:polyline>, <draw:regular-polygon> 19.539.9 <office:annotation> 19.539.10 <presentation:placeholder> 19.540 svg:ideographic 19.541 svg:mathematical 19.542 svg:name 19.543 svg:offset 19.544 svg:origin 19.545 svg:overline-position 19.546 svg:overline-thickness 19.547 svg:panose- 19.548 svg:path 19.549 svg:r 19.549.1 <draw:area-circle> 19.549.2 <draw:circle> 19.549.3 <svg:radialGradient> 19.550 svg:rx 19.551 svg:ry 19.552 svg:slope 19.553 svg:spreadMethod 19.554 svg:stemh 19.555 svg:stemv 19.556 svg:stop-color 19.557 svg:stop-opacity 19.558 svg:strikethrough-position 19.559 svg:strikethrough-thickness 19.560 svg:string 19.561 svg:type 19.562 svg:underline-position 19.563 svg:underline-thickness 19.564 svg:unicode-range 19.565 svg:units-per-em 19.566 svg:v-alphabetic 19.567 svg:v-hanging 19.568 svg:v-ideographic 19.569 svg:v-mathematical 19.570 svg:viewBox 19.571 svg:width 19.571.1 <chart:chart> 19.571.2 <chart:floor> 19.571.3 <chart:plot-area> 19.571.4 <chart:wall> 19.571.5 <dr3d:scene> 19.571.6 <draw:area-polygon> 19.571.7 <draw:area-rectangle> 19.571.8 <draw:contour-polygon>, <draw:contour-path> 19.571.9 <draw:fill-image> 19.571.10 <draw:caption>, <draw:custom-shape>, <draw:circle>, <draw:control>, <draw:ellipse>, <draw:frame>, <draw:rect>, <draw:page-thumbnail>, <draw:path>, <draw:polygon>, <draw:polyline>, <draw:regular-polygon> 19.571.11 <office:annotation> 19.571.12 <presentation:placeholder> 19.572 svg:widths 19.573 svg:x 19.573.1 <chart:data-label>, <chart:equation>, <chart:footer>, <chart:legend>, <chart:plot-area>, <chart:subtitle>, <chart:title> 19.573.2 <draw:area-polygon> 19.573.3 <draw:area-rectangle> 19.573.4 <dr3d:scene> 19.573.5 <draw:caption>, <draw:custom-shape>, <draw:circle>, <draw:control>, <draw:ellipse>, <draw:frame>, <draw:rect>, <draw:page-thumbnail>, <draw:path>, <draw:polygon>, <draw:polyline>, <draw:regular-polygon> 19.573.6 <draw:glue-point> 19.573.7 <office:annotation> 19.573.8 <presentation:placeholder> 19.574 svg:x 19.574.1 <draw:connector>, <draw:line> and <draw:measure> 19.574.2 <svg:linearGradient> 19.575 svg:x 19.575.1 <draw:connector>, <draw:line> and <draw:measure> 19.575.2 <svg:linearGradient> 19.576 svg:x-height 19.577 svg:y 19.577.1 <chart:data-label>, <chart:equation>, <chart:footer>, <chart:legend>, <chart:plot-area>, <chart:subtitle>, <chart:title> 19.577.2 <draw:area-polygon> 19.577.3 <draw:area-rectangle> 19.577.4 <dr3d:scene> 19.577.5 <draw:caption>, <draw:custom-shape>, <draw:circle>, <draw:control>, <draw:ellipse>, <draw:frame>, <draw:g>, <draw:rect>, <draw:page-thumbnail>, <draw:path>, <draw:polygon>, <draw:polyline>, <draw:regular-polygon> 19.577.6 <draw:glue-point> 19.577.7 <office:annotation> 19.577.8 <presentation:placeholder> 19.578 svg:y 19.578.1 <draw:connector>, <draw:line> and <draw:measure> 19.578.2 <svg:linearGradient> 19.579 svg:y 19.579.1 <draw:connector>, <draw:line> and <draw:measure> 19.579.2 <svg:linearGradient> 19.580 table:acceptance-state 19.581 table:algorithm 19.582 table:add-empty-lines 19.583 table:allow-empty-cell 19.584 table:application-data 19.585 table:automatic-find-labels 19.586 table:base-cell-address 19.587 table:bind-styles-to-content 19.588 table:border-color 19.589 table:buttons 19.590 table:case-sensitive 19.591 table:cell-address 19.592 table:cell-range 19.593 table:cell-range-address 19.593.1 General 19.593.2 <chart:categories> 19.593.3 <chart:domain> - bubble 19.593.4 <chart:domain>- scatter 19.593.5 <chart:domain> - surface 19.593.6 <chart:plot-area> (deprecated) 19.593.7 <table:highlighted-range> 19.593.8 <table:named-range> 19.593.9 <table:source-cell-range> 19.594 table:column 19.595 table:comment 19.596 table:condition 19.597 table:condition-source 19.598 table:condition-source-range-address 19.599 table:contains-error 19.600 table:contains-header 19.601 table:content-validation-name 19.602 table:copy-back 19.603 table:copy-formulas 19.604 table:copy-styles 19.605 table:count 19.606 table:country 19.607 table:data-field 19.608 table:data-cell-range-address 19.609 table:database-name 19.610 table:database-table-name 19.611 table:data-type 19.611.1 General 19.611.2 <table:filter-condition> 19.611.3 <table:sort-by> 19.611.4 <table:sort-groups> 19.612 table:date-end 19.613 table:date-start 19.614 table:date-value 19.615 table:default-cell-style-name 19.616 table:direction 19.617 table:display 19.618 table:display-border 19.619 table:display-duplicates 19.620 table:display-filter-buttons 19.621 table:display-list 19.622 table:display-member-mode 19.623 table:drill-down-on-double-click 19.624 table:embedded-number-behavior 19.625 table:enabled 19.626 table:end 19.627 table:end-cell-address 19.628 table:end-column 19.629 table:end-position 19.630 table:end-row 19.631 table:end-table 19.632 table:end-x 19.633 table:end-y 19.634 table:execute 19.635 table:expression 19.636 table:field-name 19.637 table:field-number 19.638 table:filter-name 19.639 table:filter-options 19.640 table:first-row-end-column (deprecated) 19.641 table:first-row-start-column (deprecated) 19.642 table:formula 19.643 table:function 19.643.1 General 19.643.2 <table:consolidation> 19.643.3 <table:data-pilot-field> 19.643.4 <table:data-pilot-subtotal> 19.643.5 <table:subtotal-field> 19.644 table:grand-total 19.645 table:group-by-field-number 19.646 table:grouped-by 19.647 table:has-persistent-data 19.648 table:id 19.649 table:identify-categories 19.650 table:ignore-empty-rows 19.651 table:index 19.652 table:is-active 19.653 table:is-data-layout-field 19.654 table:is-selection 19.655 table:is-sub-table 19.656 table:label-cell-range-address 19.657 table:language 19.658 table:last-column-spanned 19.659 table:last-row-end-column (deprecated) 19.660 table:last-row-spanned 19.661 table:last-row-start-column (deprecated) 19.662 table:layout-mode 19.663 table:link-to-source-data 19.664 table:marked-invalid 19.665 table:matrix-covered 19.666 table:maximum-difference 19.667 table:member-count 19.668 table:member-name 19.669 table:member-type 19.670 table:message-type 19.671 table:mode 19.672 table:multi-deletion-spanned 19.673 table:name 19.673.1 General 19.673.2 <table:cell-range-source> 19.673.3 <table:content-validation> 19.673.4 <table:data-pilot-group> 19.673.5 <table:data-pilot-group-member> 19.673.6 <table:data-pilot-member> 19.673.7 <table:data-pilot-table> 19.673.8 <table:database-range> 19.673.9 <table:named-expression> 19.673.10 <table:named-range> 19.673.11 <table:operation> 19.673.12 <table:source-service> 19.673.13 <table:table> 19.673.14 <table:table-template> 19.674 table:null-year 19.675 table:number-columns-repeated 19.675.1 General 19.675.2 <table:covered-table-cell> 19.675.3 <table:table-cell> 19.675.4 <table:table-column> 19.676 table:number-columns-spanned 19.677 table:number-rows-repeated 19.678 table:number-rows-spanned 19.679 table:number-matrix-columns-spanned 19.680 table:number-matrix-rows-spanned 19.681 table:object-name 19.682 table:on-update-keep-size 19.683 table:on-update-keep-styles 19.684 table:operator 19.685 table:order 19.686 table:orientation 19.686.1 General 19.686.2 <table:data-pilot-field> 19.686.3 <table:database-range> 19.686.4 <table:label-range> 19.687 table:page-breaks-on-group-change 19.688 table:paragraph-style-name 19.689 table:parse-sql-statement 19.690 table:password 19.691 table:position 19.692 table:precision-as-shown 19.693 table:print 19.694 table:print-ranges 19.695 table:protect (deprecated) 19.696 table:protected 19.696.1 General 19.696.2 <table:covered-table-cell> 19.696.3 <table:scenario> 19.696.4 <table:table> 19.696.5 <table:table-cell> 19.697 table:protection-key 19.698 table:protection-key-digest-algorithm 19.699 table:query-name 19.700 table:range-usable-as 19.701 table:refresh-delay 19.702 table:rejecting-change-id 19.703 table:rfc-language-tag 19.704 table:row 19.705 table:scenario-ranges 19.706 table:script 19.707 table:search-criteria-must-apply-to-whole-cell 19.708 table:selected-page 19.709 table:show-details 19.710 table:show-empty 19.711 table:show-filter-button 19.712 table:sort-mode 19.713 table:source-cell-range-addresses 19.714 table:source-field-name 19.715 table:source-name 19.716 table:sql-statement 19.717 table:start 19.718 table:start-column 19.719 table:start-position 19.720 table:start-row 19.721 table:start-table 19.722 table:status 19.723 table:step 19.724 table:steps 19.725 table:structure-protected 19.726 table:style-name 19.726.1 General 19.726.2 <table:background> 19.726.3 <table:body> 19.726.4 <table:covered-table-cell> 19.726.5 <table:even-columns> 19.726.6 <table:even-rows> 19.726.7 <table:first-column> 19.726.8 <table:first-row> 19.726.9 <table:last-column> 19.726.10 <table:last-row> 19.726.11 <table:odd-columns> 19.726.12 <table:odd-rows> 19.726.13 <table:table-cell> 19.726.14 <table:table-column> 19.726.15 <table:table-row> 19.726.16 <table:table> 19.727 table:table 19.728 table:table-background 19.729 table:table-name 19.730 table:target-cell-address 19.731 table:target-range-address 19.731.1 General 19.731.2 <table:data-pilot-table> 19.731.3 <table:database-range> 19.731.4 <table:filter> 19.731.5 <table:sort> 19.732 table:template-name 19.733 table:title 19.734 table:track-changes 19.735 table:type 19.735.1 General 19.735.2 <table:data-pilot-field-reference> 19.735.3 <table:deletion> 19.735.4 <table:insertion> 19.736 table:use-banding-columns-styles 19.737 table:use-banding-rows-styles 19.738 table:use-first-column-styles 19.739 table:use-first-row-styles 19.740 table:use-last-column-styles 19.741 table:use-last-row-styles 19.742 table:use-labels 19.743 table:use-regular-expressions 19.744 table:use-wildcards 19.745 table:used-hierarchy 19.746 table:user-name 19.747 table:value 19.747.1 <table:filter-condition> 19.747.2 <table:filter-set-item> 19.748 table:value-type 19.749 table:visibility 19.750 text:active 19.751 text:address 19.752 text:alphabetical-separators 19.753 text:anchor-page-number 19.754 text:anchor-type 19.755 text:annote 19.756 text:author 19.757 text:bibliography-data-field 19.758 text:bibliography-type 19.759 text:booktitle 19.760 text:bullet-char 19.761 text:bullet-relative-size 19.762 text:capitalize-entries 19.763 text:c 19.764 text:caption-sequence-format 19.765 text:caption-sequence-name 19.766 text:change-id 19.767 text:chapter 19.768 text:citation-body-style-name 19.769 text:citation-style-name 19.770 text:class-names 19.770.1 General 19.770.2 <text:h> 19.770.3 <text:p> 19.770.4 <text:span> 19.771 text:column-name 19.772 text:combine-entries 19.773 text:combine-entries-with-dash 19.774 text:combine-entries-with-pp 19.775 text:comma-separated 19.776 text:cond-style-name 19.777 text:condition 19.777.1 General 19.777.2 <text:conditional-text> 19.777.3 <text:database-next> 19.777.4 <text:database-row-select> 19.777.5 <text:hidden-paragraph> 19.777.6 <text:hidden-text> 19.777.7 <text:section> 19.778 text:connection-name 19.779 text:consecutive-numbering 19.780 text:continue-list 19.781 text:continue-numbering 19.782 text:copy-outline-levels 19.783 text:count-empty-lines 19.784 text:count-in-text-boxes 19.785 text:current-value 19.786 text:custom 19.787 text:custom 19.788 text:custom 19.789 text:custom 19.790 text:custom 19.791 text:database-name 19.792 text:date-adjust 19.793 text:date-value 19.794 text:default-style-name 19.795 text:description 19.796 text:display 19.796.1 General 19.796.2 <text:chapter> 19.796.3 <text:expression> 19.796.4 <text:file-name> 19.796.5 <text:index-entry-chapter> 19.796.6 <text:section> 19.796.7 <text:table-formula> 19.796.8 <text:template-name> 19.796.9 <text:user-field-get> 19.796.10 <text:variable-get> 19.796.11 <text:variable-input> 19.796.12 <text:variable-set> 19.797 text:display-levels 19.798 text:display-outline-level 19.799 text:duration 19.800 text:edition 19.801 text:editor 19.802 text:filter-name 19.803 text:fixed 19.804 text:footnotes-position 19.805 text:formula 19.806 text:global (deprecated) 19.807 text:howpublished 19.808 text:increment 19.809 text:id 19.809.1 General 19.809.2 <draw:text-box> 19.809.3 <text:alphabetical-index-mark-end> 19.809.4 <text:alphabetical-index-mark-start> 19.809.5 <text:changed-region> 19.809.6 <text:h> 19.809.7 <text:note> 19.809.8 <text:p> 19.809.9 <text:toc-mark-end> 19.809.10 <text:toc-mark-start> 19.809.11 <text:user-index-mark-end> 19.809.12 <text:user-index-mark-start> 19.810 text:identifier 19.811 text:index-name 19.812 text:index-scope 19.813 text:ignore-case 19.814 text:institution 19.815 text:is-hidden 19.816 text:is-list-header 19.817 text:isbn 19.818 text:issn 19.819 text:journal 19.820 text:key 19.821 text:key 19.822 text:key 19.823 text:key1-phonetic 19.824 text:key2-phonetic 19.825 text:kind 19.826 text:label 19.827 text:label-followed-by 19.828 text:level 19.829 text:list-id 19.830 text:list-tab-stop-position 19.831 text:main-entry 19.832 text:main-entry-style-name 19.833 text:master-page-name 19.834 text:month 19.835 text:name 19.835.1 General 19.835.2 <text:alphabetical-index> 19.835.3 <text:bibliography> 19.835.4 <text:bookmark> 19.835.5 <text:bookmark-end> 19.835.6 <text:bookmark-start> 19.835.7 <text:execute-macro> 19.835.8 <text:illustration-index> 19.835.9 <text:index-title> 19.835.10 <text:object-index> 19.835.11 <text:reference-mark> 19.835.12 <text:reference-mark-end> 19.835.13 <text:reference-mark-start> 19.835.14 <text:section> 19.835.15 <text:sequence> 19.835.16 <text:sequence-decl> 19.835.17 <text:table-of-content> 19.835.18 <text:table-index> 19.835.19 <text:user-defined> 19.835.20 <text:user-field-decl> 19.835.21 <text:user-field-get> 19.835.22 <text:user-field-input> 19.835.23 <text:user-index> 19.835.24 <text:variable-set> 19.835.25 <text:variable-decl> 19.835.26 <text:variable-get> 19.835.27 <text:variable-input> 19.836 text:note 19.837 text:note-class 19.838 text:number 19.839 text:number-lines 19.840 text:number-position 19.841 text:numbered-entries 19.842 text:offset 19.843 text:organizations 19.844 text:outline-level 19.844.1 General 19.844.2 <text:alphabetical-index-entry-template> 19.844.3 <text:chapter> 19.844.4 <text:h> 19.844.5 <text:index-entry-chapter> 19.844.6 <text:index-source-styles> 19.844.7 <text:user-index-mark> 19.844.8 <text:table-of-content-entry-template> 19.844.9 <text:table-of-content-source> 19.844.10 <text:toc-mark> 19.844.11 <text:toc-mark-start> 19.844.12 <text:user-index-entry-template> 19.844.13 <text:user-index-mark-start> 19.845 text:page-adjust 19.845.1 General 19.845.2 <text:page-number> 19.845.3 <text:page-variable-set> 19.846 text:pages 19.847 text:placeholder-type 19.848 text:prefix 19.849 text:protected 19.850 text:protection-key 19.851 text:protection-key-digest-algorithm 19.852 text:publisher 19.853 text:ref-name 19.853.1 General 19.853.2 <text:bookmark-ref> 19.853.3 <text:note-ref> 19.853.4 <text:reference-ref> 19.853.5 <text:sequence> 19.853.6 <text:sequence-ref> 19.854 text:reference-format 19.855 text:relative-tab-stop-position 19.856 text:report-type 19.857 text:restart-numbering 19.858 text:restart-on-page 19.859 text:row-number 19.860 text:school 19.861 text:section-name 19.862 text:series 19.863 text:select-page 19.863.1 General 19.863.2 <text:page-continuation> 19.863.3 <text:page-number> 19.864 text:separation-character 19.865 text:sort-algorithm 19.866 text:sort-ascending 19.867 text:sort-by-position 19.868 text:start-value 19.868.1 General 19.868.2 <text:h> 19.868.3 <text:list-item> 19.868.4 <text:list-level-style-number> 19.868.5 <text:notes-configuration> 19.868.6 <text:numbered-paragraph> 19.868.7 <text:outline-level-style> 19.869 text:start-numbering-at 19.870 text:string-value-phonetic 19.871 text:string-value 19.871.1 General 19.871.2 <text:alphabetical-index-mark> 19.871.3 <text:hidden-text> 19.871.4 <text:page-continuation> 19.871.5 <text:toc-mark> 19.871.6 <text:user-index-mark> 19.872 text:string-value-if-false 19.873 text:string-value-if-true 19.874 text:style-name 19.874.1 General 19.874.2 <text:a> 19.874.3 <text:alphabetical-index> 19.874.4 <text:alphabetical-index-entry-template> 19.874.5 <text:bibliography> 19.874.6 <text:bibliography-entry-template> 19.874.7 <text:h> 19.874.8 <text:illustration-index> 19.874.9 <text:illustration-index-entry-template> 19.874.10 <text:index-entry-bibliography> 19.874.11 <text:index-entry-chapter> 19.874.12 <text:index-entry-link-end> 19.874.13 <text:index-entry-link-start> 19.874.14 <text:index-entry-page-number> 19.874.15 <text:index-entry-span> 19.874.16 <text:index-entry-tab-stop> 19.874.17 <text:index-entry-text> 19.874.18 <text:index-source-style> 19.874.19 <text:index-title> 19.874.20 <text:index-title-template> 19.874.21 <text:linenumbering-configuration> 19.874.22 <text:list> 19.874.23 <text:list-level-style-number> 19.874.24 <text:list-level-style-bullet> 19.874.25 <text:numbered-paragraph> 19.874.26 <text:object-index> 19.874.27 <text:object-index-entry-template> 19.874.28 <text:outline-level-style> 19.874.29 <text:p> 19.874.30 <text:ruby> 19.874.31 <text:ruby-text> 19.874.32 <text:section> 19.874.33 <text:span> 19.874.34 <text:table-index-entry-template> 19.874.35 <text:table-of-content> 19.874.36 <text:table-of-content-entry-template> 19.874.37 <text:table-index> 19.874.38 <text:user-index> 19.874.39 <text:user-index-entry-template> 19.875 text:style-override 19.876 text:suffix 19.877 text:tab-ref 19.878 text:table-name 19.879 text:table-type 19.880 text:time-adjust 19.881 text:time-value 19.882 text:title 19.883 text:track-changes 19.884 text:url 19.885 text:use-caption 19.886 text:use-chart-objects 19.887 text:use-draw-objects 19.888 text:use-floating-frames 19.889 text:use-graphics 19.890 text:use-index-marks 19.891 text:use-index-source-styles 19.892 text:use-keys-as-entries 19.893 text:use-math-objects 19.894 text:use-objects 19.895 text:use-other-objects 19.896 text:use-outline-level 19.897 text:use-soft-page-breaks 19.898 text:use-spreadsheet-objects 19.899 text:use-tables 19.900 text:value 19.901 text:visited-style-name 19.902 text:volume 19.903 text:year 19.904 xforms:bind 19.905 xhtml:about 19.906 xhtml:content 19.907 xhtml:datatype 19.908 xhtml:property 19.909 xlink:actuate 19.910 xlink:href 19.910.1 General 19.910.2 <anim:audio> 19.910.3 <chart:chart> 19.910.4 <chart:symbol-image> 19.910.5 <db:component> 19.910.6 <db:connection-resource> 19.910.7 <db:file-based-database> 19.910.8 <draw:a> 19.910.9 <draw:applet> 19.910.10 <draw:area-circle> 19.910.11 <draw:area-polygon> 19.910.12 <draw:area-rectangle> 19.910.13 <draw:fill-image> 19.910.14 <draw:floating-frame> 19.910.15 <draw:image> 19.910.16 <draw:object> 19.910.17 <draw:object-ole> 19.910.18 <draw:plugin> 19.910.19 <form:button> 19.910.20 <form:connection-resource> 19.910.21 <form:image> 19.910.22 <form:form> 19.910.23 <meta:auto-reload> 19.910.24 <meta:template> 19.910.25 <presentation:event-listener> 19.910.26 <presentation:sound> 19.910.27 <script:event-listener> 19.910.28 <style:background-image> 19.910.29 <svg:definition-src> 19.910.30 <svg:font-face-uri> 19.910.31 <table:cell-range-source> 19.910.32 <table:table-source> 19.910.33 <text:a> 19.910.34 <text:alphabetical-index-auto-mark-file> 19.910.35 <text:list-level-style-image> 19.910.36 <text:script> 19.910.37 <text:section-source> 19.911 xlink:show 19.912 xlink:title 19.913 xlink:type 19.914 xml:id 20 Formatting Attributes 20.1 General 20.2 chart:angle-offset 20.3 chart:auto-position 20.4 chart:auto-size 20.5 chart:axis-label-position 20.6 chart:axis-position 20.7 chart:connect-bars 20.8 chart:data-label-number 20.9 chart:data-label-symbol 20.10 chart:data-label-text 20.11 chart:deep 20.12 chart:display-label 20.13 chart:error-category 20.14 chart:error-lower-indicator 20.15 chart:error-lower-limit 20.16 chart:error-lower-range 20.17 chart:error-margin 20.18 chart:error-percentage 20.19 chart:error-upper-indicator 20.20 chart:error-upper-limit 20.21 chart:error-upper-range 20.22 chart:gap-width 20.23 chart:group-bars-per-axis 20.24 chart:hole-size 20.25 chart:include-hidden-cells 20.26 chart:interpolation 20.27 chart:interval-major 20.28 chart:interval-minor-divisor 20.29 chart:japanese-candle-stick 20.30 chart:label-arrangement 20.31 chart:label-position 20.32 chart:label-position-negative 20.33 chart:lines (deprecated) 20.34 chart:link-data-style-to-source 20.35 chart:logarithmic 20.36 chart:maximum 20.37 chart:mean-value 20.38 chart:minimum 20.39 chart:origin 20.40 chart:overlap 20.41 chart:pie-offset 20.42 chart:percentage 20.43 chart:regression-type 20.44 chart:reverse-direction 20.45 chart:right-angled-axes 20.46 chart:scale-text 20.47 chart:series-source (deprecated) 20.48 chart:sort-by-x-values 20.49 chart:solid-type 20.50 chart:spline-order 20.51 chart:spline-resolution 20.52 chart:stacked 20.53 chart:symbol-height 20.54 chart:symbol-name 20.55 chart:symbol-type 20.56 chart:symbol-width 20.57 chart:text-overlap 20.58 chart:three-dimensional 20.59 chart:tick-marks-major-inner 20.60 chart:tick-marks-major-outer 20.61 chart:tick-marks-minor-inner 20.62 chart:tick-marks-minor-outer 20.63 chart:tick-mark-position 20.64 chart:treat-empty-cells 20.65 chart:vertical 20.66 chart:visible 20.67 dr3d:ambient-color 20.68 dr3d:back-scale 20.69 dr3d:backface-culling 20.70 dr3d:close-back 20.71 dr3d:close-front 20.72 dr3d:depth 20.73 dr3d:diffuse-color 20.74 dr3d:edge-rounding 20.75 dr3d:edge-rounding-mode 20.76 dr3d:emissive-color 20.77 dr3d:end-angle 20.78 dr3d:horizontal-segments 20.79 dr3d:lighting-mode 20.80 dr3d:normals-direction 20.81 dr3d:normals-kind 20.82 dr3d:shadow 20.83 dr3d:shininess 20.84 dr3d:specular-color 20.85 dr3d:texture-filter 20.86 dr3d:texture-kind 20.87 dr3d:texture-mode 20.88 dr3d:texture-generation-mode-x 20.89 dr3d:texture-generation-mode-y 20.90 dr3d:vertical-segments 20.91 draw:auto-grow-height 20.92 draw:auto-grow-width 20.93 draw:background-size 20.94 draw:blue 20.95 draw:caption-angle 20.96 draw:caption-angle-type 20.97 draw:caption-escape 20.98 draw:caption-escape-direction 20.99 draw:caption-fit-line-length 20.100 draw:caption-gap 20.101 draw:caption-line-length 20.102 draw:caption-type 20.103 draw:color-inversion 20.104 draw:color-mode 20.105 draw:contrast 20.106 draw:decimal-places 20.107 draw:draw-aspect 20.108 draw:end-guide 20.109 draw:end-line-spacing-horizontal 20.110 draw:end-line-spacing-vertical 20.111 draw:fill 20.112 draw:fill-color 20.113 draw:fill-gradient-name 20.114 draw:fill-hatch-name 20.115 draw:fill-hatch-solid 20.116 draw:fill-image-height 20.117 draw:fill-image-name 20.118 draw:fill-image-ref-point 20.119 draw:fill-image-ref-point-x 20.120 draw:fill-image-ref-point-y 20.121 draw:fill-image-width 20.122 draw:fit-to-contour 20.123 draw:fit-to-size 20.124 draw:frame-display-border 20.125 draw:frame-margin-horizontal 20.126 draw:frame-display-scrollbar 20.127 draw:frame-margin-vertical 20.128 draw:gamma 20.129 draw:green 20.130 draw:gradient-step-count 20.131 draw:guide-distance 20.132 draw:guide-overhang 20.133 draw:image-opacity 20.134 draw:line-distance 20.135 draw:luminance 20.136 draw:marker-end 20.137 draw:marker-end-center 20.138 draw:marker-end-width 20.139 draw:marker-start 20.140 draw:marker-start-center 20.141 draw:marker-start-width 20.142 draw:measure-align 20.143 draw:measure-vertical-align 20.144 draw:ole-draw-aspect (deprecated) 20.145 draw:opacity 20.146 draw:opacity-name 20.147 draw:parallel 20.148 draw:placing 20.149 draw:red 20.150 draw:secondary-fill-color 20.151 draw:shadow 20.152 draw:shadow-color 20.153 draw:shadow-offset-x 20.154 draw:shadow-offset-y 20.155 draw:shadow-opacity 20.156 draw:show-unit 20.157 draw:start-guide 20.158 draw:start-line-spacing-horizontal 20.159 draw:start-line-spacing-vertical 20.160 draw:stroke 20.161 draw:stroke-dash 20.162 draw:stroke-dash-names 20.163 draw:stroke-linejoin 20.164 svg:stroke-linecap 20.165 draw:symbol-color 20.166 draw:textarea-horizontal-align 20.167 draw:textarea-vertical-align 20.168 draw:tile-repeat-offset 20.169 draw:visible-area-height 20.170 draw:visible-area-left 20.171 draw:visible-area-top 20.172 draw:visible-area-width 20.173 draw:unit 20.174 draw:wrap-influence-on-position 20.175 fo:background-color 20.176 fo Border Properties 20.176.1 General 20.176.2 fo:border 20.176.3 fo:border-bottom 20.176.4 fo:border-left 20.176.5 fo:border-right 20.176.6 fo:border-top 20.177 fo:break-after 20.178 fo:break-before 20.179 fo:clip 20.180 fo:color 20.181 fo:country 20.182 fo:font-family 20.183 fo:font-size 20.184 fo:font-style 20.185 fo:font-variant 20.186 fo:font-weight 20.187 fo:height 20.188 fo:hyphenate 20.189 fo:hyphenation-keep 20.190 fo:hyphenation-ladder-count 20.191 fo:hyphenation-push-char-count 20.192 fo:hyphenation-remain-char-count 20.193 fo:keep-together 20.194 fo:keep-with-next 20.195 fo:language 20.196 fo:letter-spacing 20.197 fo:line-height 20.198 fo:margin 20.199 fo:margin-bottom 20.200 fo:margin-left 20.201 fo:margin-right 20.202 fo:margin-top 20.203 fo:max-height 20.204 fo:max-width 20.205 fo:min-height 20.205.1 <style:graphic-properties> 20.205.2 <style:header-footer-properties> 20.206 fo:min-width 20.207 fo:orphans 20.208 fo:page-height 20.209 fo:page-width 20.210 fo:padding 20.211 fo:padding-bottom 20.212 fo:padding-left 20.213 fo:padding-right 20.214 fo:padding-top 20.215 fo:script 20.216 fo:text-align 20.216.1 <style:paragraph-properties> 20.216.2 <style:list-level-properties> 20.217 fo:text-align-last 20.218 fo:text-indent 20.219 fo:text-shadow 20.220 fo:text-transform 20.221 fo:widows 20.222 fo:width 20.223 fo:wrap-option 20.224 presentation:background-objects-visible 20.225 presentation:background-visible 20.226 presentation:display-date-time 20.227 presentation:display-footer 20.228 presentation:display-header 20.229 presentation:display-page-number 20.230 presentation:duration 20.231 presentation:transition-speed 20.232 presentation:transition-style 20.233 presentation:transition-type 20.234 presentation:visibility 20.235 smil:direction 20.236 smil:fadeColor 20.237 smil:subtype 20.238 smil:type 20.239 style:auto-text-indent 20.240 style:background-transparency 20.241 style:border-line-width 20.242 style:border-line-width-bottom 20.243 style:border-line-width-left 20.244 style:border-line-width-right 20.245 style:border-line-width-top 20.246 style:cell-protect 20.247 style:column-width 20.248 style:country-asian 20.249 style:country-complex 20.250 style:decimal-places 20.251 style:diagonal-bl-tr 20.252 style:diagonal-bl-tr-widths 20.253 style:diagonal-tl-br 20.254 style:diagonal-tl-br-widths 20.255 style:direction 20.256 style:dynamic-spacing 20.257 style:editable 20.258 style:first-page-number 20.259 style:flow-with-text 20.260 style:font-charset 20.261 style:font-charset-asian 20.262 style:font-charset-complex 20.263 style:font-family-asian 20.264 style:font-family-complex 20.265 style:font-family-generic 20.266 style:font-family-generic-asian 20.267 style:font-family-generic-complex 20.268 style:font-independent-line-spacing 20.269 style:font-name 20.270 style:font-name-asian 20.271 style:font-name-complex 20.272 style:font-pitch 20.273 style:font-pitch-asian 20.274 style:font-pitch-complex 20.275 style:font-relief 20.276 style:font-size-asian 20.277 style:font-size-complex 20.278 style:font-size-rel 20.279 style:font-size-rel-asian 20.280 style:font-size-rel-complex 20.281 style:font-style-asian 20.282 style:font-style-complex 20.283 style:font-style-name 20.284 style:font-style-name-asian 20.285 style:font-style-name-complex 20.286 style:font-weight-asian 20.287 style:font-weight-complex 20.288 style:footnote-max-height 20.289 style:glyph-orientation-vertical 20.290 style:horizontal-pos 20.291 style:horizontal-rel 20.292 style:join-border 20.293 style:justify-single-word 20.294 style:language-asian 20.295 style:language-complex 20.296 style:layout-grid-base-height 20.297 style:layout-grid-base-width 20.298 style:layout-grid-color 20.299 style:layout-grid-display 20.300 style:layout-grid-lines 20.301 style:layout-grid-mode 20.302 style:layout-grid-print 20.303 style:layout-grid-ruby-below 20.304 style:layout-grid-ruby-height 20.305 style:layout-grid-snap-to 20.306 style:layout-grid-standard-mode 20.307 style:line-break 20.308 style:letter-kerning 20.309 style:line-height-at-least 20.310 style:line-spacing 20.311 style:may-break-between-rows 20.312 style:min-row-height 20.313 style:mirror 20.314 style:num-format 20.315 style:num-letter-sync 20.316 style:num-prefix 20.317 style:num-suffix 20.318 style:number-wrapped-paragraphs 20.319 style:overflow-behavior 20.320 style:page-number 20.321 style:paper-tray-name 20.322 style:print 20.323 style:print-content 20.323.1 General 20.323.2 <style:graphic-properties> 20.323.3 <style:table-cell-properties> 20.324 style:print-page-order 20.325 style:print-orientation 20.326 style:protect 20.326.1 General 20.326.2 <style:graphic-properties> 20.326.3 <style:section-properties> 20.327 style:punctuation-wrap 20.328 style:register-true 20.329 style:register-truth-ref-style-name 20.330 style:rel-column-width 20.331 style:rel-height 20.332 style:rel-width 20.332.1 <style:graphic-properties> 20.332.2 <style:table-properties> 20.333 style:repeat 20.334 style:repeat-content 20.335 style:rfc-language-tag 20.336 style:rfc-language-tag-asian 20.337 style:rfc-language-tag-complex 20.338 style:rotation-align 20.339 style:rotation-angle 20.340 style:row-height 20.341 style:ruby-align 20.342 style:ruby-position 20.343 style:run-through 20.344 style:scale-to 20.345 style:scale-to-pages 20.346 style:script-asian 20.347 style:script-complex 20.348 style:script-type 20.349 style:shadow 20.350 style:shrink-to-fit 20.351 style:snap-to-layout-grid 20.352 style:tab-stop-distance 20.353 style:table-centering 20.354 style:text-align-source 20.355 style:text-autospace 20.356 style:text-blinking 20.357 style:text-combine 20.358 style:text-combine-start-char 20.359 style:text-combine-end-char 20.360 style:text-emphasize 20.361 style:text-line-through-color 20.362 style:text-line-through-mode 20.363 style:text-line-through-style 20.364 style:text-line-through-text 20.365 style:text-line-through-text-style 20.366 style:text-line-through-type 20.367 style:text-line-through-width 20.368 style:text-outline 20.369 style:text-overline-color 20.370 style:text-overline-mode 20.371 style:text-overline-style 20.372 style:text-overline-type 20.373 style:text-overline-width 20.374 style:text-position 20.375 style:text-rotation-angle 20.376 style:text-rotation-scale 20.377 style:text-scale 20.378 style:text-underline-color 20.379 style:text-underline-mode 20.380 style:text-underline-style 20.381 style:text-underline-type 20.382 style:text-underline-width 20.383 style:use-optimal-column-width 20.384 style:use-optimal-row-height 20.385 style:use-window-font-color 20.386 style:vertical-align 20.386.1 <style:paragraph-properties> 20.386.2 <style:table-cell-properties> 20.387 style:vertical-pos 20.388 style:vertical-rel 20.389 style:width 20.390 style:wrap 20.391 style:wrap-contour 20.392 style:wrap-contour-mode 20.393 style:wrap-dynamic-threshold 20.394 style:writing-mode 20.394.1 General 20.394.2 <style:graphic-properties> 20.394.3 <style:page-layout-properties> 20.394.4 <style:paragraph-properties> 20.394.5 <style:section-properties> 20.394.6 <style:table-cell-properties> 20.394.7 <style:table-properties> 20.395 style:writing-mode-automatic 20.396 svg:fill-rule 20.397 svg:height 20.397.1 <style:graphic-properties> 20.397.2 <style:header-footer-properties> 20.398 svg:stroke-color 20.399 svg:stroke-opacity 20.400 svg:stroke-width 20.401 svg:x 20.402 svg:y 20.402.1 <style:graphic-properties> 20.402.2 <style:list-level-properties> 20.403 svg:width 20.404 table:align 20.405 table:border-model 20.406 table:display 20.407 text:anchor-page-number 20.408 text:anchor-type 20.409 text:animation 20.410 text:animation-delay 20.411 text:animation-direction 20.412 text:animation-repeat 20.413 text:animation-start-inside 20.414 text:animation-steps 20.415 text:animation-stop-inside 20.416 text:condition 20.417 text:display 20.418 text:dont-balance-text-columns 20.419 text:line-break 20.420 text:line-number 20.421 text:list-level-position-and-space-mode 20.422 text:min-label-distance 20.423 text:min-label-width 20.424 text:number-lines 20.425 text:space-before Appendix A. OpenDocument Relax NG Schema Appendix B. OpenDocument Metadata Manifest Ontology Appendix C. MIME Types and File Name Extensions (Non Normative) Appendix D. Accessibility Guidelines (Non Normative) D.1. Title, Description and Caption of Graphical Elements D.1.1. Guidance for authors D.1.2. Authoring tool responsibility for presenting and prompting for the <svg:title> and <svg:desc> elements D.2. Hyperlink Titles D.3. Tables in Presentations D.4. Further Guidelines Appendix E. Bidirectional (BiDi) Scripts,Numeric Digits Presentation and Calendars (Non Normative) E.1. Paragraph and Layout Direction E.2. Numeric Digits Presentation and Calendars Appendix F. Recommended Usage of SMIL F.1. Slide Animation F.2. Main Sequence F.3. Interactive Sequence Appendix G. Changes From Previous Specification Versions (Non Normative) G.1. Changes from “Open Document Format for Office Applications (OpenDocument) v1.1” Table of Contents Part 2 1 Introduction 1.1 Introduction 1.2 Terminology 1.3 Purpose 1.4 Normative References 1.5 Non-Normative References 2 Expressions and Evaluators 2.1 Introduction 2.2 OpenDocument Formula Expression 2.3 Evaluators 2.3.1 OpenDocument Formula Evaluator 2.3.2 OpenDocument Formula Small Group Evaluator 2.3.3 OpenDocument Formula Medium Group Evaluator 2.3.4 OpenDocument Formula Large Group Evaluator 2.4 Variances (Implementation-defined, Unspecified, and Behavioral Changes) 3 Formula Processing Model 3.1 General 3.2 Expression Evaluation 3.2.1 General 3.2.2 Expression Calculation 3.2.3 Operator and Function Evaluation 3.3 Non-Scalar Evaluation (aka 'Array expressions') 3.4 Host-Defined Behaviors 3.5 When recalculation occurs 3.6 Numerical Models 3.7 Basic Limits 4 Types 4.1 General 4.2 Text (String) 4.3 Number 4.3.1 General 4.3.2 Time 4.3.3 Date 4.3.4 DateTime 4.3.5 Percentage 4.3.6 Currency 4.3.7 Logical (Number) 4.4 Complex Number 4.5 Logical (Boolean) 4.6 Error 4.7 Empty Cell 4.8 Reference 4.9 ReferenceList 4.10 Array 4.11 Pseudotypes 4.11.1 General 4.11.2 Scalar 4.11.3 DateParam 4.11.4 TimeParam 4.11.5 Integer 4.11.6 TextOrNumber 4.11.7 Basis 4.11.8 Criterion 4.11.9 Database 4.11.10 Field 4.11.11 Criteria 4.11.12 Sequences (NumberSequence, NumberSequenceList, DateSequence, LogicalSequence, and ComplexSequence) 4.11.13 Any 5 Expression Syntax 5.1 General 5.2 Basic Expressions 5.3 Constant Numbers 5.4 Constant Strings 5.5 Operators 5.6 Functions and Function Parameters 5.7 Nonstandard Function Names 5.8 References 5.9 Reference List 5.10 Quoted Label 5.10.1 General 5.10.2 Lookup of Defined Labels 5.10.3 Automatic Lookup of Labels 5.10.4 Implicit Intersection 5.10.5 Automatic Range 5.10.6 Automatic Intersection 5.11 Named Expressions 5.12 Constant Errors 5.13 Inline Arrays 5.14 Whitespace 6 Standard Operators and Functions 6.1 General 6.2 Common Template for Functions and Operators 6.3 Implicit Conversion Operators 6.3.1 General 6.3.2 Conversion to Scalar 6.3.3 Implied intersection 6.3.4 Force to array context (ForceArray) 6.3.5 Conversion to Number 6.3.6 Conversion to Integer 6.3.7 Conversion to NumberSequence 6.3.8 Conversion to NumberSequenceList 6.3.9 Conversion to DateSequence 6.3.10 Conversion to Complex Number 6.3.11 Conversion to ComplexSequence 6.3.12 Conversion to Logical 6.3.13 Conversion to LogicalSequence 6.3.14 Conversion to Text 6.3.15 Conversion to DateParam 6.3.16 Conversion to TimeParam 6.4 Standard Operators 6.4.1 General 6.4.2 Infix Operator "+" 6.4.3 Infix Operator "-" 6.4.4 Infix Operator "*" 6.4.5 Infix Operator "/" 6.4.6 Infix Operator "^" 6.4.7 Infix Operator "=" 6.4.8 Infix Operator "<>" 6.4.9 Infix Operator Ordered Comparison ("<", "<=", ">", ">=") 6.4.10 Infix Operator "&" 6.4.11 Infix Operator Reference Range (":") 6.4.12 Infix Operator Reference Intersection ("!") 6.4.13 Infix Operator Reference Concatenation ("~") (aka Union) 6.4.14 Postfix Operator "%" 6.4.15 Prefix Operator "+" 6.4.16 Prefix Operator "-" 6.5 Matrix Functions 6.5.1 General 6.5.2 MDETERM 6.5.3 MINVERSE 6.5.4 MMULT 6.5.5 MUNIT 6.5.6 TRANSPOSE 6.6 Bit operation functions 6.6.1 General 6.6.2 BITAND 6.6.3 BITLSHIFT 6.6.4 BITOR 6.6.5 BITRSHIFT 6.6.6 BITXOR 6.7 Byte-position text functions 6.7.1 General 6.7.2 FINDB 6.7.3 LEFTB 6.7.4 LENB 6.7.5 MIDB 6.7.6 REPLACEB 6.7.7 RIGHTB 6.7.8 SEARCHB 6.8 Complex Number Functions 6.8.1 General 6.8.2 COMPLEX 6.8.3 IMABS 6.8.4 IMAGINARY 6.8.5 IMARGUMENT 6.8.6 IMCONJUGATE 6.8.7 IMCOS 6.8.8 IMCOSH 6.8.9 IMCOT 6.8.10 IMCSC 6.8.11 IMCSCH 6.8.12 IMDIV 6.8.13 IMEXP 6.8.14 IMLN 6.8.15 IMLOG 6.8.16 IMLOG 6.8.17 IMPOWER 6.8.18 IMPRODUCT 6.8.19 IMREAL 6.8.20 IMSIN 6.8.21 IMSINH 6.8.22 IMSEC 6.8.23 IMSECH 6.8.24 IMSQRT 6.8.25 IMSUB 6.8.26 IMSUM 6.8.27 IMTAN 6.9 Database Functions 6.9.1 General 6.9.2 DAVERAGE 6.9.3 DCOUNT 6.9.4 DCOUNTA 6.9.5 DGET 6.9.6 DMAX 6.9.7 DMIN 6.9.8 DPRODUCT 6.9.9 DSTDEV 6.9.10 DSTDEVP 6.9.11 DSUM 6.9.12 DVAR 6.9.13 DVARP 6.10 Date and Time Functions 6.10.1 General 6.10.2 DATE 6.10.3 DATEDIF 6.10.4 DATEVALUE 6.10.5 DAY 6.10.6 DAYS 6.10.7 DAYS 6.10.8 EDATE 6.10.9 EOMONTH 6.10.10 HOUR 6.10.11 ISOWEEKNUM 6.10.12 MINUTE 6.10.13 MONTH 6.10.14 NETWORKDAYS 6.10.15 NOW 6.10.16 SECOND 6.10.17 TIME 6.10.18 TIMEVALUE 6.10.19 TODAY 6.10.20 WEEKDAY 6.10.21 WEEKNUM 6.10.22 WORKDAY 6.10.23 YEAR 6.10.24 YEARFRAC 6.11 External Access Functions 6.11.1 General 6.11.2 DDE 6.11.3 HYPERLINK 6.12 Financial Functions 6.12.1 General 6.12.2 ACCRINT 6.12.3 ACCRINTM 6.12.4 AMORLINC 6.12.5 COUPDAYBS 6.12.6 COUPDAYS 6.12.7 COUPDAYSNC 6.12.8 COUPNCD 6.12.9 COUPNUM 6.12.10 COUPPCD 6.12.11 CUMIPMT 6.12.12 CUMPRINC 6.12.13 DB 6.12.14 DDB 6.12.15 DISC 6.12.16 DOLLARDE 6.12.17 DOLLARFR 6.12.18 DURATION 6.12.19 EFFECT 6.12.20 FV 6.12.21 FVSCHEDULE 6.12.22 INTRATE 6.12.23 IPMT 6.12.24 IRR 6.12.25 ISPMT 6.12.26 MDURATION 6.12.27 MIRR 6.12.28 NOMINAL 6.12.29 NPER 6.12.30 NPV 6.12.31 ODDFPRICE 6.12.32 ODDFYIELD 6.12.33 ODDLPRICE 6.12.34 ODDLYIELD 6.12.35 PDURATION 6.12.36 PMT 6.12.37 PPMT 6.12.38 PRICE 6.12.39 PRICEDISC 6.12.40 PRICEMAT 6.12.41 PV 6.12.42 RATE 6.12.43 RECEIVED 6.12.44 RRI 6.12.45 SLN 6.12.46 SYD 6.12.47 TBILLEQ 6.12.48 TBILLPRICE 6.12.49 TBILLYIELD 6.12.50 VDB 6.12.51 XIRR 6.12.52 XNPV 6.12.53 YIELD 6.12.54 YIELDDISC 6.12.55 YIELDMAT 6.13 Information Functions 6.13.1 General 6.13.2 AREAS 6.13.3 CELL 6.13.4 COLUMN 6.13.5 COLUMNS 6.13.6 COUNT 6.13.7 COUNTA 6.13.8 COUNTBLANK 6.13.9 COUNTIF 6.13.10 COUNTIFS 6.13.11 ERROR.TYPE 6.13.12 FORMULA 6.13.13 INFO 6.13.14 ISBLANK 6.13.15 ISERR 6.13.16 ISERROR 6.13.17 ISEVEN 6.13.18 ISFORMULA 6.13.19 ISLOGICAL 6.13.20 ISNA 6.13.21 ISNONTEXT 6.13.22 ISNUMBER 6.13.23 ISODD 6.13.24 ISREF 6.13.25 ISTEXT 6.13.26 N 6.13.27 NA 6.13.28 NUMBERVALUE 6.13.29 ROW 6.13.30 ROWS 6.13.31 SHEET 6.13.32 SHEETS 6.13.33 TYPE 6.13.34 VALUE 6.14 Lookup Functions 6.14.1 General 6.14.2 ADDRESS 6.14.3 CHOOSE 6.14.4 GETPIVOTDATA 6.14.5 HLOOKUP 6.14.6 INDEX 6.14.7 INDIRECT 6.14.8 LOOKUP 6.14.9 MATCH 6.14.10 MULTIPLE.OPERATIONS 6.14.11 OFFSET 6.14.12 VLOOKUP 6.15 Logical Functions 6.15.1 General 6.15.2 AND 6.15.3 FALSE 6.15.4 IF 6.15.5 IFERROR 6.15.6 IFNA 6.15.7 NOT 6.15.8 OR 6.15.9 TRUE 6.15.10 XOR 6.16 Mathematical Functions 6.16.1 General 6.16.2 ABS 6.16.3 ACOS 6.16.4 ACOSH 6.16.5 ACOT 6.16.6 ACOTH 6.16.7 ASIN 6.16.8 ASINH 6.16.9 ATAN 6.16.10 ATAN 6.16.11 ATANH 6.16.12 BESSELI 6.16.13 BESSELJ 6.16.14 BESSELK 6.16.15 BESSELY 6.16.16 COMBIN 6.16.17 COMBINA 6.16.18 CONVERT 6.16.19 COS 6.16.20 COSH 6.16.21 COT 6.16.22 COTH 6.16.23 CSC 6.16.24 CSCH 6.16.25 DEGREES 6.16.26 DELTA 6.16.27 ERF 6.16.28 ERFC 6.16.29 EUROCONVERT 6.16.30 EVEN 6.16.31 EXP 6.16.32 FACT 6.16.33 FACTDOUBLE 6.16.34 GAMMA 6.16.35 GAMMALN 6.16.36 GCD 6.16.37 GESTEP 6.16.38 LCM 6.16.39 LN 6.16.40 LOG 6.16.41 LOG 6.16.42 MOD 6.16.43 MULTINOMIAL 6.16.44 ODD 6.16.45 PI 6.16.46 POWER 6.16.47 PRODUCT 6.16.48 QUOTIENT 6.16.49 RADIANS 6.16.50 RAND 6.16.51 RANDBETWEEN 6.16.52 SEC 6.16.53 SERIESSUM 6.16.54 SIGN 6.16.55 SIN 6.16.56 SINH 6.16.57 SECH 6.16.58 SQRT 6.16.59 SQRTPI 6.16.60 SUBTOTAL 6.16.61 SUM 6.16.62 SUMIF 6.16.63 SUMIFS 6.16.64 SUMPRODUCT 6.16.65 SUMSQ 6.16.66 SUMX2MY 6.16.67 SUMX2PY 6.16.68 SUMXMY 6.16.69 TAN 6.16.70 TANH 6.17 Rounding Functions 6.17.1 CEILING 6.17.2 INT 6.17.3 FLOOR 6.17.4 MROUND 6.17.5 ROUND 6.17.6 ROUNDDOWN 6.17.7 ROUNDUP 6.17.8 TRUNC 6.18 Statistical Functions 6.18.1 General 6.18.2 AVEDEV 6.18.3 AVERAGE 6.18.4 AVERAGEA 6.18.5 AVERAGEIF 6.18.6 AVERAGEIFS 6.18.7 BETADIST 6.18.8 BETAINV 6.18.9 BINOM.DIST.RANGE 6.18.10 BINOMDIST 6.18.11 LEGACY.CHIDIST 6.18.12 CHISQDIST 6.18.13 LEGACY.CHIINV 6.18.14 CHISQINV 6.18.15 LEGACY.CHITEST 6.18.16 CONFIDENCE 6.18.17 CORREL 6.18.18 COVAR 6.18.19 CRITBINOM 6.18.20 DEVSQ 6.18.21 EXPONDIST 6.18.22 FDIST 6.18.23 LEGACY.FDIST 6.18.24 FINV 6.18.25 LEGACY.FINV 6.18.26 FISHER 6.18.27 FISHERINV 6.18.28 FORECAST 6.18.29 FREQUENCY 6.18.30 FTEST 6.18.31 GAMMADIST 6.18.32 GAMMAINV 6.18.33 GAUSS 6.18.34 GEOMEAN 6.18.35 GROWTH 6.18.36 HARMEAN 6.18.37 HYPGEOMDIST 6.18.38 INTERCEPT 6.18.39 KURT 6.18.40 LARGE 6.18.41 LINEST 6.18.42 LOGEST 6.18.43 LOGINV 6.18.44 LOGNORMDIST 6.18.45 MAX 6.18.46 MAXA 6.18.47 MEDIAN 6.18.48 MIN 6.18.49 MINA 6.18.50 MODE 6.18.51 NEGBINOMDIST 6.18.52 NORMDIST 6.18.53 NORMINV 6.18.54 LEGACY.NORMSDIST 6.18.55 LEGACY.NORMSINV 6.18.56 PEARSON 6.18.57 PERCENTILE 6.18.58 PERCENTRANK 6.18.59 PERMUT 6.18.60 PERMUTATIONA 6.18.61 PHI 6.18.62 POISSON 6.18.63 PROB 6.18.64 QUARTILE 6.18.65 RANK 6.18.66 RSQ 6.18.67 SKEW 6.18.68 SKEWP 6.18.69 SLOPE 6.18.70 SMALL 6.18.71 STANDARDIZE 6.18.72 STDEV 6.18.73 STDEVA 6.18.74 STDEVP 6.18.75 STDEVPA 6.18.76 STEYX 6.18.77 LEGACY.TDIST 6.18.78 TINV 6.18.79 TREND 6.18.80 TRIMMEAN 6.18.81 TTEST 6.18.82 VAR 6.18.83 VARA 6.18.84 VARP 6.18.85 VARPA 6.18.86 WEIBULL 6.18.87 ZTEST 6.19 Number Representation Conversion Functions 6.19.1 General 6.19.2 ARABIC 6.19.3 BASE 6.19.4 BIN2DEC 6.19.5 BIN2HEX 6.19.6 BIN2OCT 6.19.7 DEC2BIN 6.19.8 DEC2HEX 6.19.9 DEC2OCT 6.19.10 DECIMAL 6.19.11 HEX2BIN 6.19.12 HEX2DEC 6.19.13 HEX2OCT 6.19.14 OCT2BIN 6.19.15 OCT2DEC 6.19.16 OCT2HEX 6.19.17 ROMAN 6.20 Text Functions 6.20.1 General 6.20.2 ASC 6.20.3 CHAR 6.20.4 CLEAN 6.20.5 CODE 6.20.6 CONCATENATE 6.20.7 DOLLAR 6.20.8 EXACT 6.20.9 FIND 6.20.10 FIXED 6.20.11 JIS 6.20.12 LEFT 6.20.13 LEN 6.20.14 LOWER 6.20.15 MID 6.20.16 PROPER 6.20.17 REPLACE 6.20.18 REPT 6.20.19 RIGHT 6.20.20 SEARCH 6.20.21 SUBSTITUTE 6.20.22 T 6.20.23 TEXT 6.20.24 TRIM 6.20.25 UNICHAR 6.20.26 UNICODE 6.20.27 UPPER 7 Other Capabilities 7.1 General 7.2 Inline constant arrays 7.3 Inline non-constant arrays 7.4 Year 8 Non-portable Features 8.1 General 8.2 Distinct Logical Table of Contents Part 3 1 Introduction 1.1 Introduction 1.2 Terminology 1.3 Normative References 1.4 Non Normative References 1.5 Namespaces 2 Packages, Package Consumers and Package Producers 2.1 Introduction 2.2 Packages 2.2.1 OpenDocument Package 2.2.2 OpenDocument Extended Package 2.3 Producers 2.3.1 OpenDocument Package Producer 2.3.2 OpenDocument Package Extended Producer 2.4 OpenDocument Package Consumer 3 Packages 3.1 General 3.2 Manifest 3.3 MIME Media Type 3.4 Encryption 3.4.1 General 3.4.2 Encryption Process 3.5 Digital Signatures 3.6 Metadata 3.7 Usage of IRIs Within Packages 3.8 Preview Image 4 Manifest File 4.1 Introduction 4.2 <manifest:manifest> 4.3 <manifest:file-entry> 4.4 <manifest:encryption-data> 4.5 <manifest:algorithm> 4.6 <manifest:start-key-generation> 4.7 <manifest:key-derivation> 4.8 Manifest Attributes 4.8.1 manifest:algorithm-name 4.8.2 manifest:checksum 4.8.3 manifest:checksum-type 4.8.4 manifest:full-path 4.8.5 manifest:initialisation-vector 4.8.6 manifest:start-key-generation-name 4.8.7 manifest:key-size 4.8.8 manifest:iteration-count 4.8.9 manifest:key-derivation-name 4.8.10 manifest:media-type 4.8.11 manifest:preferred-view-mode 4.8.12 manifest:salt 4.8.13 manifest:size 4.8.14 manifest:version 5 Digital Signatures File 5.1 Introduction 5.2 <dsig:document-signatures> 5.3 <ds:Signature> 5.4 Digital Signatures Attributes 5.4.1 dsig:version 6 Metadata Manifest Files 6.1 General 6.2 pkg:Document 6.3 pkg:File 6.4 pkg:MetadataFile 6.5 pkg:Element 6.6 pkg:hasPart 6.7 pkg:mimeType 7 Datatypes 7.1 Introduction 7.2 W3C Schema Datatypes 7.3 Other Datatypes 7.3.1 namespacedToken Appendix A. Schemas A.1. OpenDocument Manifest Schema A.2. OpenDocument Digital Signature Schema Appendix B. OpenDocument Metadata Manifest Ontology Appendix C. Zip File Structure (Non normative) Appendix D. Changes From “Open Document Format for Office Applications (OpenDocument) v1.1” (Non Normative) 1 1.1 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 All text is normative unless otherwise labeled. Within the normative text of this specification, the terms " shall shall not should should not may [ISO/IEC Directives] implementation-defined behavior: behavior that depends on the implementation and that each implementation shall document. Note: 1.3 [ ISO/IEC Directives Rules for the structure and drafting of International Standards The individual parts of the OpenDocument specification each defines its own set of normative references. 1.4 [ ODF11 Open Document Format for Office Applications (OpenDocument) v1.1 http://docs.oasis-open.org/office/v1.1/OS/OpenDocument-v1.1.pdf The individual parts of the OpenDocument specification each contains further non normative references. 2 The OpenDocument specification defines conformance for documents, consumers, producers, packages, package consumer, package producers, formula expressions and formula evaluators, with multiple conformance classes. (C1) conforming OpenDocument Document shall (C2) conforming OpenDocument extended Document shall (C3) conforming OpenDocument Text Document shall (C4) conforming OpenDocument Spreadsheet Document (C5) conforming OpenDocument Drawing Document shall (C6) conforming OpenDocument Presentation Document shall (C7) conforming OpenDocument Chart Document shall (C8) conforming OpenDocument Image Document shall (C9) OpenDocument Formula Document (C10) OpenDocument Database Front End Document (C11) Conforming OpenDocument Producer (C12) Conforming OpenDocument Extended Producer (C13) OpenDocument Consumer (C14) conforming OpenDocument Formula Expression shall (C15) OpenDocument Formula Evaluator (C16) OpenDocument Formula Small Group Evaluator (C17) OpenDocument Formula Medium Group Evaluator (C18) OpenDocument Formula Large Group Evaluator (C19) conforming OpenDocument Package shall meet the requirements defined in part 3 section 2.2.1 and chapters 3 to 7 for OpenDocument packages. (C20) 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. Appendix A. A.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. Appendix B. The following individuals have participated in the creation of this specification and are gratefully acknowledged: Participants: Chieko Asakawa, IBM Cherie Ekholm, Microsoft Corporation Bart Hanssens, Fedict Kazmer Koleszar, MultiRacio Ltd. Robin LaFontaine David LeBlanc, Microsoft Ben Martin, KDE e.V. Tristan Mitchell Asokan Ramanathan, IBM Douglas Schepers John Tolbert, The Boeing Company Jos van den Oever, KDE e.V.

Open Document Format for Office Applications (OpenDocument) Version 1.2 (2011-09-30)

Related documents