diff options
author | Andrés <andmarti@gmail.com> | 2021-04-01 17:39:23 -0300 |
---|---|---|
committer | Andrés <andmarti@gmail.com> | 2021-04-01 17:39:23 -0300 |
commit | ff1945c97bab0c6c9a370a0030faa90eedeff5a0 (patch) | |
tree | ea9c390e58d8c57015ec7799621f57ec88b6a86f | |
parent | 8368b3ff288ce48e36e7180212dc96d2a71780d9 (diff) |
disable mouse in mode othe than normal_mode. move ods example files.
-rw-r--r-- | examples/ods/gnumeric.ods | bin | 0 -> 6691 bytes | |||
-rw-r--r-- | examples/ods/gnumeric/META-INF/manifest.xml | 9 | ||||
-rw-r--r-- | examples/ods/gnumeric/content.xml | 227 | ||||
-rw-r--r-- | examples/ods/gnumeric/meta.xml | 10 | ||||
-rw-r--r-- | examples/ods/gnumeric/mimetype | 1 | ||||
-rw-r--r-- | examples/ods/gnumeric/settings.xml | 33 | ||||
-rw-r--r-- | examples/ods/gnumeric/styles.xml | 45 |
7 files changed, 325 insertions, 0 deletions
diff --git a/examples/ods/gnumeric.ods b/examples/ods/gnumeric.ods Binary files differnew file mode 100644 index 0000000..3a18326 --- /dev/null +++ b/examples/ods/gnumeric.ods diff --git a/examples/ods/gnumeric/META-INF/manifest.xml b/examples/ods/gnumeric/META-INF/manifest.xml new file mode 100644 index 0000000..e1b8e74 --- /dev/null +++ b/examples/ods/gnumeric/META-INF/manifest.xml @@ -0,0 +1,9 @@ +<?xml version="1.0" encoding="UTF-8"?> + +<manifest:manifest xmlns:manifest="urn:oasis:names:tc:opendocument:xmlns:manifest:1.0" manifest:version="1.2"> + <manifest:file-entry manifest:media-type="application/vnd.oasis.opendocument.spreadsheet" manifest:full-path="/"/> + <manifest:file-entry manifest:media-type="text/xml" manifest:full-path="content.xml"/> + <manifest:file-entry manifest:media-type="text/xml" manifest:full-path="styles.xml"/> + <manifest:file-entry manifest:media-type="text/xml" manifest:full-path="meta.xml"/> + <manifest:file-entry manifest:media-type="text/xml" manifest:full-path="settings.xml"/> +</manifest:manifest> diff --git a/examples/ods/gnumeric/content.xml b/examples/ods/gnumeric/content.xml new file mode 100644 index 0000000..022a93f --- /dev/null +++ b/examples/ods/gnumeric/content.xml @@ -0,0 +1,227 @@ +<?xml version="1.0" encoding="UTF-8"?> + +<office:document-content xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:gnm="http://www.gnumeric.org/odf-extension/1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" office:version="1.2"> + <office:scripts/> + <office:font-face-decls/> + <office:automatic-styles> + <style:style style:name="ta-0" style:family="table" style:master-page-name="ta-mp-0"> + <style:table-properties table:display="true" style:writing-mode="lr-tb" gnm:display-formulas="false" gnm:display-col-header="true" gnm:display-row-header="true"/> + </style:style> + <style:style style:name="AC-weight100" style:family="text"> + <style:text-properties fo:font-weight="100"/> + </style:style> + <style:style style:name="AC-weight200" style:family="text"> + <style:text-properties fo:font-weight="200"/> + </style:style> + <style:style style:name="AC-weight300" style:family="text"> + <style:text-properties fo:font-weight="300"/> + </style:style> + <style:style style:name="AC-weight400" style:family="text"> + <style:text-properties fo:font-weight="normal"/> + </style:style> + <style:style style:name="AC-weight500" style:family="text"> + <style:text-properties fo:font-weight="500"/> + </style:style> + <style:style style:name="AC-weight600" style:family="text"> + <style:text-properties fo:font-weight="600"/> + </style:style> + <style:style style:name="AC-weight700" style:family="text"> + <style:text-properties fo:font-weight="bold"/> + </style:style> + <style:style style:name="AC-weight800" style:family="text"> + <style:text-properties fo:font-weight="800"/> + </style:style> + <style:style style:name="AC-weight900" style:family="text"> + <style:text-properties fo:font-weight="900"/> + </style:style> + <style:style style:name="AC-weight1000" style:family="text"> + <style:text-properties fo:font-weight="900"/> + </style:style> + <style:style style:name="AC-italic" style:family="text"> + <style:text-properties fo:font-style="italic"/> + </style:style> + <style:style style:name="AC-roman" style:family="text"> + <style:text-properties fo:font-style="normal"/> + </style:style> + <style:style style:name="AC-subscript" style:family="text"> + <style:text-properties style:text-position="sub 83%"/> + </style:style> + <style:style style:name="AC-superscript" style:family="text"> + <style:text-properties style:text-position="super 83%"/> + </style:style> + <style:style style:name="AC-script" style:family="text"> + <style:text-properties style:text-position="0% 100%"/> + </style:style> + <style:style style:name="AC-strikethrough-solid" style:family="text"> + <style:text-properties style:text-line-through-type="single" style:text-line-through-style="solid"/> + </style:style> + <style:style style:name="AC-strikethrough-none" style:family="text"> + <style:text-properties style:text-line-through-type="none" style:text-line-through-style="none"/> + </style:style> + <style:style style:name="AC-underline-none" style:family="text"> + <style:text-properties style:text-underline-type="none" style:text-underline-style="none" style:text-underline-width="auto"/> + </style:style> + <style:style style:name="AC-underline-single" style:family="text"> + <style:text-properties style:text-underline-type="single" style:text-underline-style="solid" style:text-underline-width="auto"/> + </style:style> + <style:style style:name="AC-underline-double" style:family="text"> + <style:text-properties style:text-underline-type="double" style:text-underline-style="solid" style:text-underline-width="auto"/> + </style:style> + <style:style style:name="AC-underline-low" style:family="text"> + <style:text-properties style:text-underline-type="single" style:text-underline-style="solid" style:text-underline-width="bold"/> + </style:style> + <style:style style:name="AC-underline-error" style:family="text"> + <style:text-properties style:text-underline-type="single" style:text-underline-style="wave" style:text-underline-width="auto"/> + </style:style> + <style:style style:name="AROW-0" style:family="table-row"> + <style:table-row-properties style:row-height="12.75pt" style:use-optimal-row-height="true"/> + </style:style> + <style:style style:name="ACOL-0" style:family="table-column"> + <style:table-column-properties style:column-width="47.988pt" style:use-optimal-column-width="true"/> + </style:style> + <style:style style:name="ACE-0" style:family="table-cell" style:data-style-name="General"> + <style:table-cell-properties fo:background-color="transparent" gnm:background-colour="#ffffff" gnm:pattern-colour="#000000" gnm:pattern="0" fo:border-top="0.000cm none #c7c7c7" fo:border-bottom="0.000cm none #c7c7c7" fo:border-left="0.000cm none #c7c7c7" fo:border-right="0.000cm none #c7c7c7" style:diagonal-bl-tr="0.000cm none #c7c7c7" style:diagonal-tl-br="0.000cm none #c7c7c7" style:vertical-align="bottom" fo:wrap-option="no-wrap" style:shrink-to-fit="false" style:writing-mode="page" style:glyph-orientation-vertical="auto" style:cell-protect="protected" style:rotation-align="none" style:rotation-angle="0" style:print-content="true" style:decimal-places="13" style:text-align-source="value-type" style:repeat-content="false"/> + <style:paragraph-properties style:writing-mode-automatic="true" gnm:GnmHAlign="1" fo:margin-left="0pt"/> + <style:text-properties text:display="true" fo:font-weight="normal" fo:font-style="normal" style:text-line-through-type="none" style:text-line-through-style="none" style:text-underline-type="none" style:text-underline-style="none" style:text-underline-width="auto" style:text-underline-color="font-color" style:text-underline-mode="continuous" style:text-position="0% 100%" fo:font-size="10pt" fo:color="#000000" fo:font-family="Sans"/> + </style:style> + <style:style style:name="ACE-1" style:family="table-cell" style:data-style-name="General"> + <style:table-cell-properties fo:background-color="transparent" gnm:background-colour="#ffffff" gnm:pattern-colour="#000000" gnm:pattern="0" fo:border-top="0.000cm none #c7c7c7" fo:border-bottom="0.000cm none #c7c7c7" fo:border-left="0.000cm none #c7c7c7" fo:border-right="0.000cm none #c7c7c7" style:diagonal-bl-tr="0.000cm none #c7c7c7" style:diagonal-tl-br="0.000cm none #c7c7c7" style:vertical-align="bottom" fo:wrap-option="no-wrap" style:shrink-to-fit="false" style:writing-mode="page" style:glyph-orientation-vertical="auto" style:cell-protect="protected" style:rotation-align="none" style:rotation-angle="0" style:print-content="true" style:decimal-places="13" style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties style:writing-mode-automatic="true" fo:text-align="center" fo:margin-left="0pt"/> + <style:text-properties text:display="true" fo:font-weight="normal" fo:font-style="normal" style:text-line-through-type="none" style:text-line-through-style="none" style:text-underline-type="none" style:text-underline-style="none" style:text-underline-width="auto" style:text-underline-color="font-color" style:text-underline-mode="continuous" style:text-position="0% 100%" fo:font-size="10pt" fo:color="#000000" fo:font-family="Sans"/> + </style:style> + <style:style style:name="ACE-2" style:family="table-cell" style:data-style-name="General"> + <style:table-cell-properties fo:background-color="transparent" gnm:background-colour="#ffffff" gnm:pattern-colour="#000000" gnm:pattern="0" fo:border-top="0.000cm none #c7c7c7" fo:border-bottom="0.000cm none #c7c7c7" fo:border-left="0.000cm none #c7c7c7" fo:border-right="0.000cm none #c7c7c7" style:diagonal-bl-tr="0.000cm none #c7c7c7" style:diagonal-tl-br="0.000cm none #c7c7c7" style:vertical-align="bottom" fo:wrap-option="no-wrap" style:shrink-to-fit="false" style:writing-mode="page" style:glyph-orientation-vertical="auto" style:cell-protect="protected" style:rotation-align="none" style:rotation-angle="0" style:print-content="true" style:decimal-places="13" style:text-align-source="value-type" style:repeat-content="false"/> + <style:paragraph-properties style:writing-mode-automatic="true" gnm:GnmHAlign="1" fo:margin-left="0pt"/> + <style:text-properties text:display="true" fo:font-weight="normal" fo:font-style="normal" style:text-line-through-type="none" style:text-line-through-style="none" style:text-underline-type="none" style:text-underline-style="none" style:text-underline-width="auto" style:text-underline-color="font-color" style:text-underline-mode="continuous" style:text-position="0% 100%" fo:font-size="10pt" fo:color="#000000" fo:font-family="Sans"/> + </style:style> + <style:style style:name="ACE-3" style:family="table-cell" style:data-style-name="ND-0"> + <style:table-cell-properties fo:background-color="transparent" gnm:background-colour="#ffffff" gnm:pattern-colour="#000000" gnm:pattern="0" fo:border-top="0.000cm none #c7c7c7" fo:border-bottom="0.000cm none #c7c7c7" fo:border-left="0.000cm none #c7c7c7" fo:border-right="0.000cm none #c7c7c7" style:diagonal-bl-tr="0.000cm none #c7c7c7" style:diagonal-tl-br="0.000cm none #c7c7c7" style:vertical-align="bottom" fo:wrap-option="no-wrap" style:shrink-to-fit="false" style:writing-mode="page" style:glyph-orientation-vertical="auto" style:cell-protect="protected" style:rotation-align="none" style:rotation-angle="0" style:print-content="true" style:decimal-places="13" style:text-align-source="value-type" style:repeat-content="false"/> + <style:paragraph-properties style:writing-mode-automatic="true" gnm:GnmHAlign="1" fo:margin-left="0pt"/> + <style:text-properties text:display="true" fo:font-weight="normal" fo:font-style="normal" style:text-line-through-type="none" style:text-line-through-style="none" style:text-underline-type="none" style:text-underline-style="none" style:text-underline-width="auto" style:text-underline-color="font-color" style:text-underline-mode="continuous" style:text-position="0% 100%" fo:font-size="10pt" fo:color="#000000" fo:font-family="Sans"/> + </style:style> + <style:style style:name="ACE-4" style:family="table-cell" style:data-style-name="ND-1"> + <style:table-cell-properties fo:background-color="transparent" gnm:background-colour="#ffffff" gnm:pattern-colour="#000000" gnm:pattern="0" fo:border-top="0.000cm none #c7c7c7" fo:border-bottom="0.000cm none #c7c7c7" fo:border-left="0.000cm none #c7c7c7" fo:border-right="0.000cm none #c7c7c7" style:diagonal-bl-tr="0.000cm none #c7c7c7" style:diagonal-tl-br="0.000cm none #c7c7c7" style:vertical-align="bottom" fo:wrap-option="no-wrap" style:shrink-to-fit="false" style:writing-mode="page" style:glyph-orientation-vertical="auto" style:cell-protect="protected" style:rotation-align="none" style:rotation-angle="0" style:print-content="true" style:decimal-places="13" style:text-align-source="value-type" style:repeat-content="false"/> + <style:paragraph-properties style:writing-mode-automatic="true" gnm:GnmHAlign="1" fo:margin-left="0pt"/> + <style:text-properties text:display="true" fo:font-weight="normal" fo:font-style="normal" style:text-line-through-type="none" style:text-line-through-style="none" style:text-underline-type="none" style:text-underline-style="none" style:text-underline-width="auto" style:text-underline-color="font-color" style:text-underline-mode="continuous" style:text-position="0% 100%" fo:font-size="10pt" fo:color="#000000" fo:font-family="Sans"/> + </style:style> + <style:style style:name="ACE-5" style:family="table-cell" style:data-style-name="ND-2"> + <style:table-cell-properties fo:background-color="transparent" gnm:background-colour="#ffffff" gnm:pattern-colour="#000000" gnm:pattern="0" fo:border-top="0.000cm none #c7c7c7" fo:border-bottom="0.000cm none #c7c7c7" fo:border-left="0.000cm none #c7c7c7" fo:border-right="0.000cm none #c7c7c7" style:diagonal-bl-tr="0.000cm none #c7c7c7" style:diagonal-tl-br="0.000cm none #c7c7c7" style:vertical-align="bottom" fo:wrap-option="no-wrap" style:shrink-to-fit="false" style:writing-mode="page" style:glyph-orientation-vertical="auto" style:cell-protect="protected" style:rotation-align="none" style:rotation-angle="0" style:print-content="true" style:decimal-places="13" style:text-align-source="value-type" style:repeat-content="false"/> + <style:paragraph-properties style:writing-mode-automatic="true" gnm:GnmHAlign="1" fo:margin-left="0pt"/> + <style:text-properties text:display="true" fo:font-weight="normal" fo:font-style="normal" style:text-line-through-type="none" style:text-line-through-style="none" style:text-underline-type="none" style:text-underline-style="none" style:text-underline-width="auto" style:text-underline-color="font-color" style:text-underline-mode="continuous" style:text-position="0% 100%" fo:font-size="10pt" fo:color="#000000" fo:font-family="Sans"/> + </style:style> + <style:style style:name="ACE-6" style:family="table-cell" style:data-style-name="ND-3"> + <style:table-cell-properties fo:background-color="transparent" gnm:background-colour="#ffffff" gnm:pattern-colour="#000000" gnm:pattern="0" fo:border-top="0.000cm none #c7c7c7" fo:border-bottom="0.000cm none #c7c7c7" fo:border-left="0.000cm none #c7c7c7" fo:border-right="0.000cm none #c7c7c7" style:diagonal-bl-tr="0.000cm none #c7c7c7" style:diagonal-tl-br="0.000cm none #c7c7c7" style:vertical-align="bottom" fo:wrap-option="no-wrap" style:shrink-to-fit="false" style:writing-mode="page" style:glyph-orientation-vertical="auto" style:cell-protect="protected" style:rotation-align="none" style:rotation-angle="0" style:print-content="true" style:decimal-places="13" style:text-align-source="value-type" style:repeat-content="false"/> + <style:paragraph-properties style:writing-mode-automatic="true" gnm:GnmHAlign="1" fo:margin-left="0pt"/> + <style:text-properties text:display="true" fo:font-weight="normal" fo:font-style="normal" style:text-line-through-type="none" style:text-line-through-style="none" style:text-underline-type="none" style:text-underline-style="none" style:text-underline-width="auto" style:text-underline-color="font-color" style:text-underline-mode="continuous" style:text-position="0% 100%" fo:font-size="10pt" fo:color="#000000" fo:font-family="Sans"/> + </style:style> + <style:style style:name="ACOL-1" style:family="table-column"> + <style:table-column-properties style:column-width="225.0144pt" style:use-optimal-column-width="true"/> + </style:style> + <style:style style:name="ACOL-2" style:family="table-column"> + <style:table-column-properties style:column-width="119.988pt" style:use-optimal-column-width="true"/> + </style:style> + <style:style style:name="ACOL-3" style:family="table-column"> + <style:table-column-properties style:column-width="207.0144pt" style:use-optimal-column-width="true"/> + </style:style> + <style:style style:name="ACOL-4" style:family="table-column"/> + <style:style style:name="AROW-1" style:family="table-row"> + <style:table-row-properties style:row-height="12.815999999999999pt" style:use-optimal-row-height="true"/> + </style:style> + <style:style style:name="AROW-2" style:family="table-row"/> + </office:automatic-styles> + <office:body> + <office:spreadsheet> + <table:calculation-settings table:null-year="1930" table:automatic-find-labels="false" table:case-sensitive="false" table:precision-as-shown="false" table:search-criteria-must-apply-to-whole-cell="true" table:use-regular-expressions="false" table:use-wildcards="false"> + <table:null-date table:date-value="1899-12-30" table:value-type="date"/> + <table:iteration table:maximum-difference="0.001" table:status="enable" table:steps="100"/> + </table:calculation-settings> + <table:table table:name="Sheet1" table:style-name="ta-0" table:print="true"> + <office:forms form:automatic-focus="false" form:apply-design-mode="false"> + <form:form/> + </office:forms> + <table:table-column table:style-name="ACOL-1"/> + <table:table-column table:style-name="ACOL-2"/> + <table:table-column table:style-name="ACOL-3" table:number-columns-repeated="2"/> + <table:table-column table:style-name="ACOL-0" table:number-columns-repeated="124"/> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-0" office:value-type="float" office:value="4322669"><text:p>4322669</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-0" office:value-type="float" office:value="1.1200000000000001"><text:p>1.12</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-4" office:value-type="time" office:time-value="PT012H31M00S"><text:p>12:31:00 PM</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="125" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-0" office:value-type="string"><text:p>izquierda</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-0" office:value-type="string"><text:p>derecha</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-5" office:value-type="string"><text:p>18/04/2019</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="125" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-1" office:value-type="string"><text:p>centro</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-3" office:value-type="float" office:value="960.13999999999999"><text:p>$960.14</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-6" office:value-type="date" office:date-value="2019-04-18"><text:p>04/18/19</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="125" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-0" office:value-type="float" office:value="-32"><text:p>−32</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="127" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-0" office:value-type="string"><text:p>expr</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-0" table:formula="of:=[.A1]+[.B1]" office:value-type="float" office:value="4322670.1200000001"><text:p>4322670.12</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="126" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-0" office:value-type="string"><text:p>average</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-0" table:formula="of:=AVERAGE([.A1:.B1])" office:value-type="float" office:value="2161335.0600000001"><text:p>2161335.06</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="126" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-0" office:value-type="string"><text:p>sum</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-0" table:formula="of:=SUM([.A1:.B1])" office:value-type="float" office:value="4322670.1200000001"><text:p>4322670.12</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="126" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-0" office:value-type="string"><text:p>product</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-0" table:formula="of:=PRODUCT([.A1:.B1])" office:value-type="float" office:value="4841389.2800000003"><text:p>4841389.28</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="126" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-0" office:value-type="string"><text:p>count</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-0" table:formula="of:=COUNT([.A1:.B1])" office:value-type="float" office:value="2"><text:p>2</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="126" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-0" office:value-type="string"><text:p>min</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-0" table:formula="of:=MIN([.A1:.B1])" office:value-type="float" office:value="1.1200000000000001"><text:p>1.12</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="126" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-0" office:value-type="string"><text:p>max</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-0" table:formula="of:=MAX([.A1:.B1])" office:value-type="float" office:value="4322669"><text:p>4322669</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="126" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-0" office:value-type="string"><text:p>abs</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-0" table:formula="of:=ABS([.A4])" office:value-type="float" office:value="32"><text:p>32</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="126" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-1"> + <table:table-cell table:style-name="ACE-0" office:value-type="string"><text:p>stdev</text:p></table:table-cell> + <table:table-cell table:style-name="ACE-0" table:formula="of:=STDEV([.A1:.B1])" office:value-type="float" office:value="3056587.7707652776"><text:p>3056587.770765</text:p></table:table-cell> + <table:table-cell table:number-columns-repeated="126" table:style-name="ACE-0"/> + </table:table-row> + <table:table-row table:style-name="AROW-0" table:number-rows-repeated="115"> + <table:table-cell table:number-columns-repeated="128"/> + </table:table-row> + <table:named-expressions> + <table:named-expression table:name="Sheet_Title" table:expression="of:="Sheet1"" table:base-cell-address="$'Sheet1'.$A$1"/> + <table:named-expression table:name="Print_Area" table:expression="of:=#REF!" table:base-cell-address="$'Sheet1'.$A$1"/> + </table:named-expressions> + <gnm:selections gnm:cursor-col="1" gnm:cursor-row="13"> + <gnm:selection gnm:start-col="1" gnm:start-row="13" gnm:end-col="1" gnm:end-row="13"/> + </gnm:selections> + </table:table> + <table:named-expressions/> + </office:spreadsheet> + </office:body> +</office:document-content> diff --git a/examples/ods/gnumeric/meta.xml b/examples/ods/gnumeric/meta.xml new file mode 100644 index 0000000..9152ac6 --- /dev/null +++ b/examples/ods/gnumeric/meta.xml @@ -0,0 +1,10 @@ +<?xml version="1.0" encoding="UTF-8"?> +<office:document-meta xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:ooo="http://openoffice.org/2004/office" office:version="1.2"> + <office:meta> + <dc:date>2021-03-27T22:47:40Z</dc:date> + <meta:creation-date>2021-03-27T19:18:10Z</meta:creation-date> + <meta:editing-cycles>2</meta:editing-cycles> + <meta:editing-duration>PT3M57S</meta:editing-duration> + <meta:generator>gnumeric/1.12.48</meta:generator> + </office:meta> +</office:document-meta> diff --git a/examples/ods/gnumeric/mimetype b/examples/ods/gnumeric/mimetype new file mode 100644 index 0000000..78a49cc --- /dev/null +++ b/examples/ods/gnumeric/mimetype @@ -0,0 +1 @@ +application/vnd.oasis.opendocument.spreadsheet
\ No newline at end of file diff --git a/examples/ods/gnumeric/settings.xml b/examples/ods/gnumeric/settings.xml new file mode 100644 index 0000000..506dafb --- /dev/null +++ b/examples/ods/gnumeric/settings.xml @@ -0,0 +1,33 @@ +<?xml version="1.0" encoding="UTF-8"?> +<office:document-settings xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:gnm="http://www.gnumeric.org/odf-extension/1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" office:version="1.2"> + <office:settings> + <config:config-item-set config:name="gnm:settings"> + <config:config-item config:name="gnm:has_foreign" config:type="boolean">true</config:config-item> + <config:config-item config:name="gnm:active-sheet" config:type="string">Sheet1</config:config-item> + <config:config-item config:name="gnm:geometry-width" config:type="int">959</config:config-item> + <config:config-item config:name="gnm:geometry-height" config:type="int">827</config:config-item> + </config:config-item-set> + <config:config-item-set config:name="ooo:view-settings"> + <config:config-item-map-indexed config:name="Views"> + <config:config-item-map-entry> + <config:config-item config:name="ViewId" config:type="string">View1</config:config-item> + <config:config-item-map-named config:name="Tables"> + <config:config-item-map-entry config:name="Sheet1"> + <config:config-item config:name="CursorPositionX" config:type="int">1</config:config-item> + <config:config-item config:name="CursorPositionY" config:type="int">13</config:config-item> + <config:config-item config:name="ZoomValue" config:type="int">100</config:config-item> + <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item> + <config:config-item config:name="HasColumnRowHeaders" config:type="boolean">true</config:config-item> + <config:config-item config:name="ShowZeroValues" config:type="boolean">true</config:config-item> + <config:config-item config:name="PositionLeft" config:type="int">0</config:config-item> + <config:config-item config:name="PositionRight" config:type="int">0</config:config-item> + <config:config-item config:name="PositionTop" config:type="int">0</config:config-item> + <config:config-item config:name="PositionBottom" config:type="int">0</config:config-item> + </config:config-item-map-entry> + </config:config-item-map-named> + <config:config-item config:name="ActiveTable" config:type="string">Sheet1</config:config-item> + </config:config-item-map-entry> + </config:config-item-map-indexed> + </config:config-item-set> + </office:settings> +</office:document-settings> diff --git a/examples/ods/gnumeric/styles.xml b/examples/ods/gnumeric/styles.xml new file mode 100644 index 0000000..368429b --- /dev/null +++ b/examples/ods/gnumeric/styles.xml @@ -0,0 +1,45 @@ +<?xml version="1.0" encoding="UTF-8"?> +<office:document-styles xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:gnm="http://www.gnumeric.org/odf-extension/1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" office:version="1.2"> + <office:styles><number:currency-style style:name="ND-0-0"><number:currency-symbol>$</number:currency-symbol><number:number number:decimal-places="2" number:grouping="true" number:min-integer-digits="1"/></number:currency-style><number:number-style style:name="ND-0"><style:text-properties fo:color="#FF0000"/><number:text>-$</number:text><number:number number:decimal-places="2" number:grouping="true" number:min-integer-digits="1"/><style:map style:condition="value()>=0" style:apply-style-name="ND-0-0"/></number:number-style><number:time-style style:name="ND-1" number:format-source="fixed"><number:hours number:style="long" gnm:truncate-on-overflow="true"/><number:text>:</number:text><number:minutes number:style="long" gnm:truncate-on-overflow="true"/><number:text>:</number:text><number:seconds number:style="long" number:decimal-places="0" gnm:truncate-on-overflow="true"/><number:text> </number:text><number:am-pm gnm:am-suffix="AM" gnm:pm-suffix="PM"/></number:time-style><number:date-style style:name="ND-2" number:format-source="fixed"><number:day number:style="long"/><number:text>/</number:text><number:month number:possessive-form="false" number:textual="false" number:style="long"/><number:text>/</number:text><number:year number:style="long" number:calendar="gregorian"/></number:date-style><number:date-style style:name="ND-3" number:format-source="fixed"><number:month number:possessive-form="false" number:textual="false" number:style="long"/><number:text>/</number:text><number:day number:style="long"/><number:text>/</number:text><number:year number:style="short" number:calendar="gregorian"/></number:date-style> <style:style style:name="Gnumeric-default" style:family="table-cell" style:data-style-name="General"> + <style:table-cell-properties fo:background-color="transparent" gnm:background-colour="#ffffff" gnm:pattern-colour="#000000" gnm:pattern="0" fo:border-top="0.000cm none #c7c7c7" fo:border-bottom="0.000cm none #c7c7c7" fo:border-left="0.000cm none #c7c7c7" fo:border-right="0.000cm none #c7c7c7" style:diagonal-bl-tr="0.000cm none #c7c7c7" style:diagonal-tl-br="0.000cm none #c7c7c7" style:vertical-align="bottom" fo:wrap-option="no-wrap" style:shrink-to-fit="false" style:writing-mode="page" style:glyph-orientation-vertical="auto" style:cell-protect="protected" style:rotation-align="none" style:rotation-angle="0" style:print-content="true" style:decimal-places="13" style:text-align-source="value-type" style:repeat-content="false"/> + <style:paragraph-properties style:writing-mode-automatic="true" gnm:GnmHAlign="1" fo:margin-left="0pt"/> + <style:text-properties text:display="true" fo:font-weight="normal" fo:font-style="normal" style:text-line-through-type="none" style:text-line-through-style="none" style:text-underline-type="none" style:text-underline-style="none" style:text-underline-width="auto" style:text-underline-color="font-color" style:text-underline-mode="continuous" style:text-position="0% 100%" fo:font-size="10pt" fo:color="#000000" fo:font-family="Sans"/> + </style:style> + <style:default-style style:family="table-cell"> + <style:table-cell-properties fo:background-color="transparent" gnm:background-colour="#ffffff" gnm:pattern-colour="#000000" gnm:pattern="0" fo:border-top="0.000cm none #c7c7c7" fo:border-bottom="0.000cm none #c7c7c7" fo:border-left="0.000cm none #c7c7c7" fo:border-right="0.000cm none #c7c7c7" style:diagonal-bl-tr="0.000cm none #c7c7c7" style:diagonal-tl-br="0.000cm none #c7c7c7" style:vertical-align="bottom" fo:wrap-option="no-wrap" style:shrink-to-fit="false" style:writing-mode="page" style:glyph-orientation-vertical="auto" style:cell-protect="protected" style:rotation-align="none" style:rotation-angle="0" style:print-content="true" style:decimal-places="13" style:text-align-source="value-type" style:repeat-content="false"/> + <style:paragraph-properties style:writing-mode-automatic="true" gnm:GnmHAlign="1" fo:margin-left="0pt"/> + <style:text-properties text:display="true" fo:font-weight="normal" fo:font-style="normal" style:text-line-through-type="none" style:text-line-through-style="none" style:text-underline-type="none" style:text-underline-style="none" style:text-underline-width="auto" style:text-underline-color="font-color" style:text-underline-mode="continuous" style:text-position="0% 100%" fo:font-size="10pt" fo:color="#000000" fo:font-family="Sans"/> + </style:default-style> + <style:default-style style:family="table-column"> + <style:table-column-properties style:column-width="47.988pt" style:use-optimal-column-width="true"/> + </style:default-style> + <style:default-style style:family="table-row"> + <style:table-row-properties style:row-height="12.75pt" style:use-optimal-row-height="true"/> + </style:default-style> + </office:styles> + <office:automatic-styles> + <style:page-layout style:name="pl-0" style:page-usage="all"> + <style:page-layout-properties fo:margin-top="72pt" fo:margin-bottom="72pt" fo:margin-left="72pt" fo:margin-right="72pt" fo:page-width="611.9999826986959pt" fo:page-height="791.9999826986959pt" style:table-centering="none" style:print-page-order="ttb" style:writing-mode="lr-tb" style:print-orientation="portrait" style:print="charts drawings objects annotations" style:scale-to="100.00%" gnm:style-print=""/> + <style:header-style> + <style:header-footer-properties fo:border="none" style:shadow="none" fo:padding="0pt" fo:margin="0pt" fo:min-height="21.2616pt" svg:height="21.2616pt" style:dynamic-spacing="true"/> + </style:header-style> + <style:footer-style> + <style:header-footer-properties fo:border="none" style:shadow="none" fo:padding="0pt" fo:margin="0pt" fo:min-height="21.2616pt" svg:height="21.2616pt" style:dynamic-spacing="true"/> + </style:footer-style> + </style:page-layout> + </office:automatic-styles> + <office:master-styles> + <style:master-page style:name="ta-mp-0" style:display-name="Sheet1" style:page-layout-name="pl-0"> + <style:header style:display="true"> + <style:region-left><text:p/></style:region-left> + <style:region-center><text:p><text:sheet-name/></text:p></style:region-center> + <style:region-right><text:p/></style:region-right> + </style:header> + <style:footer style:display="true"> + <style:region-left><text:p/></style:region-left> + <style:region-center><text:p><text:span>Page </text:span><text:page-number style:num-format="1"/></text:p></style:region-center> + <style:region-right><text:p/></style:region-right> + </style:footer> + </style:master-page> + </office:master-styles> +</office:document-styles> |