Adding upstream version 0.19.2.upstream/0.19.2upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

28 files changed, 248 insertions, 0 deletions

diff --git a/test/ods/borders/grid-box.ods b/test/ods/borders/grid-box.ods
new file mode 100644
index 0000000..635df51
--- /dev/null
+++ b/test/ods/borders/grid-box.ods
diff --git a/test/ods/borders/single-cells.ods b/test/ods/borders/single-cells.ods
new file mode 100644
index 0000000..a51d845
--- /dev/null
+++ b/test/ods/borders/single-cells.ods
diff --git a/test/ods/cell-properties/wrap-and-shrink.ods b/test/ods/cell-properties/wrap-and-shrink.ods
new file mode 100644
index 0000000..ad03617
--- /dev/null
+++ b/test/ods/cell-properties/wrap-and-shrink.ods
diff --git a/test/ods/column-width-row-height/input.ods b/test/ods/column-width-row-height/input.ods
new file mode 100644
index 0000000..0f4b223
--- /dev/null
+++ b/test/ods/column-width-row-height/input.ods
diff --git a/test/ods/date-cell/input.ods b/test/ods/date-cell/input.ods
new file mode 100644
index 0000000..1aecd24
--- /dev/null
+++ b/test/ods/date-cell/input.ods
diff --git a/test/ods/formatted-text/bold-and-italic.ods b/test/ods/formatted-text/bold-and-italic.ods
new file mode 100644
index 0000000..f49e27f
--- /dev/null
+++ b/test/ods/formatted-text/bold-and-italic.ods
diff --git a/test/ods/formula-1/check.txt b/test/ods/formula-1/check.txt
new file mode 100644
index 0000000..ef31604
--- /dev/null
+++ b/test/ods/formula-1/check.txt
@@ -0,0 +1,4 @@
+Formula/0/0:formula:1*2:2
+Formula/1/0:formula:12/3:4
+Formula/2/0:formula:AVERAGE($A1:A$2):3
+Formula/3/0:formula:SUM($A$1:$A$3):9
diff --git a/test/ods/formula-1/input.ods b/test/ods/formula-1/input.ods
new file mode 100644
index 0000000..36841e6
--- /dev/null
+++ b/test/ods/formula-1/input.ods
diff --git a/test/ods/formula-2/check.txt b/test/ods/formula-2/check.txt
new file mode 100644
index 0000000..eef6880
--- /dev/null
+++ b/test/ods/formula-2/check.txt
@@ -0,0 +1,21 @@
+Sheet1/0/0:string:"Number"
+Sheet1/0/1:string:"String"
+Sheet1/0/2:string:"Formula"
+Sheet1/1/0:numeric:1
+Sheet1/1/1:string:"Andy"
+Sheet1/1/2:formula:CONCATENATE(A2," ",B2):1 Andy
+Sheet1/2/0:numeric:2
+Sheet1/2/1:string:"Bruce"
+Sheet1/2/2:formula:CONCATENATE(A3," ",B3):2 Bruce
+Sheet1/3/0:numeric:3
+Sheet1/3/1:string:"Charlie"
+Sheet1/3/2:formula:CONCATENATE(A4," ",B4):3 Charlie
+Sheet1/4/0:numeric:4
+Sheet1/4/1:string:"David"
+Sheet1/4/2:formula:CONCATENATE(A5," ",B5):4 David
+Sheet1/5/0:numeric:5
+Sheet1/5/1:string:"Edward"
+Sheet1/5/2:formula:CONCATENATE(A6," ",B6):5 Edward
+Sheet1/6/0:numeric:6
+Sheet1/6/1:string:"Frank"
+Sheet1/6/2:formula:CONCATENATE(A7," ",B7):6 Frank
diff --git a/test/ods/formula-2/input.ods b/test/ods/formula-2/input.ods
new file mode 100644
index 0000000..d310af2
--- /dev/null
+++ b/test/ods/formula-2/input.ods
diff --git a/test/ods/import-styles/cell-protection.xml b/test/ods/import-styles/cell-protection.xml
new file mode 100644
index 0000000..0bea938
--- /dev/null
+++ b/test/ods/import-styles/cell-protection.xml
@@ -0,0 +1,17 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<office:styles xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0">
+  <style:style style:name="Default" style:family="table-cell"/>
+  <style:style style:name="Protected" style:family="table-cell" style:parent-style-name="Default"/>
+  <style:style style:name="Hide_20_Formula" style:display-name="Hide Formula" style:family="table-cell" style:parent-style-name="Protected">
+    <style:table-cell-properties style:cell-protect="protected formula-hidden" style:print-content="true"/>
+  </style:style>
+  <style:style style:name="Hide_20_When_20_Printing" style:display-name="Hide When Printing" style:family="table-cell" style:parent-style-name="Protected">
+    <style:table-cell-properties style:cell-protect="protected" style:print-content="false"/>
+  </style:style>
+  <style:style style:name="Hide_20_All" style:display-name="Hide All" style:family="table-cell" style:parent-style-name="Protected">
+    <style:table-cell-properties style:cell-protect="hidden-and-protected" style:print-content="true"/>
+  </style:style>
+  <style:style style:name="Not_20_Protected" style:display-name="Not Protected" style:family="table-cell" style:parent-style-name="Default">
+    <style:table-cell-properties style:cell-protect="none" style:print-content="true"/>
+  </style:style>
+</office:styles>
diff --git a/test/ods/import-styles/cell-styles.xml b/test/ods/import-styles/cell-styles.xml
new file mode 100644
index 0000000..f3e94ff
--- /dev/null
+++ b/test/ods/import-styles/cell-styles.xml
@@ -0,0 +1,43 @@
+<?xml version="1.0"?>
+<office:styles xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0">
+  <style:style style:name="Name1" style:family="table-cell" style:parent-style-name="Text">
+    <style:table-cell-properties fo:background-color="#feffcc" fo:border="0.06pt dotted #ffcc12"/>
+  </style:style>
+  <style:style style:name="Name2" style:family="table-cell" style:parent-style-name="Text">
+    <style:table-cell-properties fo:border-top="0.74pt fine-dashed #ffee11" fo:border-bottom="1.74pt double-thin #aeee11" fo:border-left="0.74pt none #11ee11" fo:border-right="0.22pt dash-dot-dot #05ee11"/>
+  </style:style>
+  <style:style style:name="Name3" style:family="table-cell" style:parent-style-name="Text">
+    <style:table-cell-properties fo:diagonal-bl-tr="1.74pt dashed #ffccee" fo:diagonal-tl-br="0.74pt dash-dot #120000" fo:border-left="none" fo:border-right="0.74pt dotted #000000"/>
+  </style:style>
+  <style:style style:name="Name4" style:family="table-cell" style:parent-style-name="Text">
+    <style:table-cell-properties fo:border-top="0.74pt double-border #000000" fo:border-bottom="none" fo:border-left="0.74pt solid #000000" fo:border-right="0.74pt dotted #000000"/>
+  </style:style>
+  <style:style style:name="Name5" style:family="table-cell" style:parent-style-name="Text">
+    <style:table-cell-properties style:cell-protect="hidden-and-protected" style:print-content="true"/>
+  </style:style>
+  <style:style style:name="Name6" style:family="table-cell" style:parent-style-name="Text">
+    <style:table-cell-properties style:cell-protect="protected formula-hidden" style:print-content="false"/>
+  </style:style>
+  <style:style style:name="Name7" style:family="table-cell" style:parent-style-name="Text">
+    <style:table-cell-properties style:cell-protect="none" style:print-content="true"/>
+  </style:style>
+  <style:style style:name="Name8" style:family="table-cell" style:parent-style-name="Text">
+    <style:text-properties style:font-name="Liberation Sans" style:text-underline-style="solid" fo:font-size="24pt" fo:color="#808080" fo:font-style="italic" style:text-underline-color="font-color" fo:font-weight="bold" style:text-underline-width="thick"/>
+  </style:style>
+  <style:style style:name="Name9" style:family="table-cell" style:parent-style-name="Text">
+    <style:text-properties style:font-name="Tahoma" style:text-underline-style="dash" fo:font-size="00pt" style:text-underline-color="#1856ff" fo:font-weight="bold" style:text-underline-width="bold"/>
+  </style:style>
+  <style:style style:name="Name20" style:family="table-cell" style:parent-style-name="Default">
+    <style:text-properties style:text-line-through-style="solid" style:text-line-through-type="single"/>
+  </style:style>
+  <style:style style:name="Name21" style:family="table-cell" style:parent-style-name="Default">
+    <style:text-properties style:text-line-through-style="solid" style:text-line-through-type="single" style:text-line-through-width="bold"/>
+  </style:style>
+  <style:style style:name="Name22" style:family="table-cell" style:parent-style-name="Default">
+    <style:text-properties style:text-line-through-style="solid" style:text-line-through-type="single" style:text-line-through-text="/"/>
+  </style:style>
+  <style:style style:name="Name23" style:family="table-cell" style:parent-style-name="Text">
+    <style:table-cell-properties style:vertical-align="middle"/>
+    <style:paragraph-properties fo:text-align="end"/>
+  </style:style>
+</office:styles>
diff --git a/test/ods/import-styles/standard-styles.xml b/test/ods/import-styles/standard-styles.xml
new file mode 100644
index 0000000..d1d1a75
--- /dev/null
+++ b/test/ods/import-styles/standard-styles.xml
@@ -0,0 +1,64 @@
+<?xml version="1.0"?>
+<office:styles xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0">
+    <style:style style:name="Heading" style:family="table-cell" style:parent-style-name="Default">
+        <style:text-properties fo:color="#000000" fo:font-size="24pt" fo:font-style="normal" fo:font-weight="bold"/>
+    </style:style>
+    <style:style style:name="Heading 1" style:family="table-cell" style:parent-style-name="Heading">
+        <style:text-properties fo:font-size="18pt"/>
+    </style:style>
+    <style:style style:name="Heading 2" style:family="table-cell" style:parent-style-name="Heading">
+        <style:text-properties fo:font-size="12pt"/>
+    </style:style>
+
+    <style:style style:name="Text" style:family="table-cell" style:parent-style-name="Default"/>
+    <style:style style:name="Note" style:family="table-cell" style:parent-style-name="Text">
+        <style:table-cell-properties fo:background-color="#ffffcc" fo:border="0.75pt solid #808080"/>
+        <style:text-properties fo:color="#333333"/>
+    </style:style>
+    <style:style style:name="Footnote" style:family="table-cell" style:parent-style-name="Text">
+        <style:text-properties fo:color="#808080" fo:font-style="italic"/>
+    </style:style>
+    <style:style style:name="Hyperlink" style:family="table-cell" style:parent-style-name="Text">
+        <style:text-properties fo:color="#0000ee" style:text-underline-style="solid" style:text-underline-width="auto" style:text-underline-color="font-color"/>
+    </style:style>
+
+    <style:style style:name="Status" style:family="table-cell" style:parent-style-name="Default"/>
+    <style:style style:name="Good" style:family="table-cell" style:parent-style-name="Status">
+        <style:table-cell-properties fo:background-color="#ccffcc"/>
+        <style:text-properties fo:color="#006600"/>
+    </style:style>
+    <style:style style:name="Neutral" style:family="table-cell" style:parent-style-name="Status">
+        <style:table-cell-properties fo:background-color="#ffffcc"/>
+        <style:text-properties fo:color="#996600"/>
+    </style:style>
+    <style:style style:name="Bad" style:family="table-cell" style:parent-style-name="Status">
+        <style:table-cell-properties fo:background-color="#ffcccc"/>
+        <style:text-properties fo:color="#cc0000"/>
+    </style:style>
+    <style:style style:name="Warning" style:family="table-cell" style:parent-style-name="Status">
+        <style:text-properties fo:color="#cc0000"/>
+    </style:style>
+    <style:style style:name="Error" style:family="table-cell" style:parent-style-name="Status">
+        <style:table-cell-properties fo:background-color="#cc0000"/>
+        <style:text-properties fo:color="#ffffff" fo:font-weight="bold"/>
+    </style:style>
+
+    <style:style style:name="Accent" style:family="table-cell" style:parent-style-name="Default">
+        <style:text-properties fo:font-weight="bold"/>
+    </style:style>
+    <style:style style:name="Accent 1" style:family="table-cell" style:parent-style-name="Accent">
+        <style:table-cell-properties fo:background-color="#000000"/>
+        <style:text-properties fo:color="#ffffff"/>
+    </style:style>
+    <style:style style:name="Accent 2" style:family="table-cell" style:parent-style-name="Accent">
+        <style:table-cell-properties fo:background-color="#808080"/>
+        <style:text-properties fo:color="#ffffff"/>
+    </style:style>
+    <style:style style:name="Accent 3" style:family="table-cell" style:parent-style-name="Accent">
+        <style:table-cell-properties fo:background-color="#dddddd"/>
+    </style:style>
+
+    <style:style style:name="Result" style:family="table-cell" style:parent-style-name="Default">
+        <style:text-properties fo:font-weight="bold" fo:font-style="italic" style:text-underline-style="solid"/>
+    </style:style>
+</office:styles>
diff --git a/test/ods/japanese.ods b/test/ods/japanese.ods
new file mode 100644
index 0000000..3c2cc4e
--- /dev/null
+++ b/test/ods/japanese.ods
diff --git a/test/ods/named-expression-sheet-local/check.txt b/test/ods/named-expression-sheet-local/check.txt
new file mode 100644
index 0000000..c6dbaed
--- /dev/null
+++ b/test/ods/named-expression-sheet-local/check.txt
@@ -0,0 +1,24 @@
+Sheet1/0/0:numeric:1
+Sheet1/0/1:numeric:6
+Sheet1/1/0:numeric:2
+Sheet1/1/1:numeric:7
+Sheet1/2/0:numeric:3
+Sheet1/2/1:numeric:8
+Sheet1/3/0:numeric:4
+Sheet1/3/1:numeric:9
+Sheet1/4/0:numeric:5
+Sheet1/4/1:numeric:10
+Sheet1/6/0:formula:SUM(MyRange):27
+Sheet1/6/1:formula:MyCalc:9
+Sheet2/0/0:numeric:10
+Sheet2/0/1:numeric:20
+Sheet2/1/0:numeric:11
+Sheet2/1/1:numeric:21
+Sheet2/2/0:numeric:12
+Sheet2/2/1:numeric:22
+Sheet2/3/0:numeric:13
+Sheet2/3/1:numeric:23
+Sheet2/4/0:numeric:14
+Sheet2/4/1:numeric:24
+Sheet2/6/0:formula:SUM(MyRange):74
+Sheet2/6/1:formula:MyCalc:-8
diff --git a/test/ods/named-expression-sheet-local/input.ods b/test/ods/named-expression-sheet-local/input.ods
new file mode 100644
index 0000000..b26f717
--- /dev/null
+++ b/test/ods/named-expression-sheet-local/input.ods
diff --git a/test/ods/named-expression/check.txt b/test/ods/named-expression/check.txt
new file mode 100644
index 0000000..e25d914
--- /dev/null
+++ b/test/ods/named-expression/check.txt
@@ -0,0 +1,14 @@
+Sheet1/1/1:formula:MyCalc:128
+Sheet1/1/4:numeric:7
+Sheet1/2/4:numeric:3
+Sheet1/3/2:formula:128/MyCalc:1
+Sheet1/3/4:formula:MyCalcWithRef:1024
+Sheet1/6/0:formula:INT(MyCalcWithRef2*PI()):65
+Sheet1/7/0:formula:INT(MyCalcWithRef2*PI()):50
+Sheet1/8/0:formula:INT(MyCalcWithRef2*PI()):28
+Sheet2/0/0:numeric:1
+Sheet2/0/1:numeric:4
+Sheet2/1/0:numeric:2
+Sheet2/1/1:numeric:5
+Sheet2/2/0:numeric:3
+Sheet2/2/1:numeric:6
diff --git a/test/ods/named-expression/input.ods b/test/ods/named-expression/input.ods
new file mode 100644
index 0000000..19a60e8
--- /dev/null
+++ b/test/ods/named-expression/input.ods
diff --git a/test/ods/named-range/check.txt b/test/ods/named-range/check.txt
new file mode 100644
index 0000000..e745fb7
--- /dev/null
+++ b/test/ods/named-range/check.txt
@@ -0,0 +1,36 @@
+Sheet1/0/0:numeric:1
+Sheet1/0/1:numeric:6
+Sheet1/0/2:numeric:11
+Sheet1/0/4:numeric:1
+Sheet1/0/5:numeric:6
+Sheet1/0/6:numeric:11
+Sheet1/1/0:numeric:2
+Sheet1/1/1:numeric:7
+Sheet1/1/2:numeric:12
+Sheet1/1/4:numeric:2
+Sheet1/1/5:numeric:7
+Sheet1/1/6:numeric:12
+Sheet1/2/0:numeric:3
+Sheet1/2/1:numeric:8
+Sheet1/2/2:numeric:13
+Sheet1/2/4:numeric:3
+Sheet1/2/5:numeric:8
+Sheet1/2/6:numeric:13
+Sheet1/3/0:numeric:4
+Sheet1/3/1:numeric:9
+Sheet1/3/2:numeric:14
+Sheet1/3/4:numeric:4
+Sheet1/3/5:numeric:9
+Sheet1/3/6:numeric:14
+Sheet1/4/0:numeric:5
+Sheet1/4/1:numeric:10
+Sheet1/4/2:numeric:15
+Sheet1/4/4:numeric:5
+Sheet1/4/5:numeric:10
+Sheet1/4/6:numeric:15
+Sheet1/6/0:formula:SUM(MyRange):15
+Sheet1/6/1:formula:SUM(MyRange2):55
+Sheet1/6/2:formula:SUM(MyRange3):65
+Sheet1/6/4:formula:SUM(RangeRelative):15
+Sheet1/6/5:formula:SUM(RangeRelative):40
+Sheet1/6/6:formula:SUM(RangeRelative):65
diff --git a/test/ods/named-range/input.ods b/test/ods/named-range/input.ods
new file mode 100644
index 0000000..47b3aad
--- /dev/null
+++ b/test/ods/named-range/input.ods
diff --git a/test/ods/number-format/basic-set.ods b/test/ods/number-format/basic-set.ods
new file mode 100644
index 0000000..d009f1b
--- /dev/null
+++ b/test/ods/number-format/basic-set.ods
diff --git a/test/ods/raw-values-1/check.txt b/test/ods/raw-values-1/check.txt
new file mode 100644
index 0000000..935cf22
--- /dev/null
+++ b/test/ods/raw-values-1/check.txt
@@ -0,0 +1,25 @@
+Num/1/0:numeric:1.1
+Num/1/2:numeric:2.1
+Num/1/4:numeric:3.1
+Num/2/0:numeric:1.2
+Num/2/2:numeric:2.2
+Num/2/4:numeric:3.2
+Num/3/0:numeric:1.3
+Num/3/2:numeric:2.3
+Num/3/4:numeric:3.3
+Num/6/2:numeric:5
+Num/6/3:numeric:6
+Num/6/4:numeric:7
+Text/0/0:string:"A"
+Text/1/0:string:"B"
+Text/1/1:string:"D"
+Text/2/0:string:"C"
+Text/2/1:string:"E"
+Text/2/2:string:"G"
+Text/3/1:string:"F"
+Text/3/2:string:"H"
+Text/4/2:string:"I"
+Text/6/3:string:"Andy"
+Text/7/3:string:"Bruce"
+Text/8/3:string:"Charlie"
+Text/9/3:string:"David"
diff --git a/test/ods/raw-values-1/input.ods b/test/ods/raw-values-1/input.ods
new file mode 100644
index 0000000..8b856a3
--- /dev/null
+++ b/test/ods/raw-values-1/input.ods
diff --git a/test/ods/styles/asian-complex.ods b/test/ods/styles/asian-complex.ods
new file mode 100644
index 0000000..4e3eb9c
--- /dev/null
+++ b/test/ods/styles/asian-complex.ods
diff --git a/test/ods/styles/column-styles.ods b/test/ods/styles/column-styles.ods
new file mode 100644
index 0000000..a37ed22
--- /dev/null
+++ b/test/ods/styles/column-styles.ods
diff --git a/test/ods/styles/direct-format.ods b/test/ods/styles/direct-format.ods
new file mode 100644
index 0000000..6e80685
--- /dev/null
+++ b/test/ods/styles/direct-format.ods
diff --git a/test/ods/styles/text-underlines.ods b/test/ods/styles/text-underlines.ods
new file mode 100644
index 0000000..316b3c0
--- /dev/null
+++ b/test/ods/styles/text-underlines.ods
diff --git a/test/ods/test.ods b/test/ods/test.ods
new file mode 100644
index 0000000..0c5b00a
--- /dev/null
+++ b/test/ods/test.ods