diff options
Diffstat (limited to 'test/ods')
28 files changed, 248 insertions, 0 deletions
diff --git a/test/ods/borders/grid-box.ods b/test/ods/borders/grid-box.ods Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew file mode 100644 index 0000000..0c5b00a --- /dev/null +++ b/test/ods/test.ods |