From c484829272cd13a738e35412498e12f2c9a194ac Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Mon, 15 Apr 2024 07:48:59 +0200 Subject: Adding upstream version 0.19.2. Signed-off-by: Daniel Baumann --- test/xlsx/background-color/standard.xlsx | Bin 0 -> 8676 bytes test/xlsx/boolean-values/check.txt | 3 ++ test/xlsx/boolean-values/input.xlsx | Bin 0 -> 8272 bytes test/xlsx/borders/colors.xlsx | Bin 0 -> 9753 bytes test/xlsx/borders/directions.xlsx | Bin 0 -> 9726 bytes test/xlsx/borders/grid-box.xlsx | Bin 0 -> 9562 bytes test/xlsx/borders/single-cells.xlsx | Bin 0 -> 8489 bytes test/xlsx/cell-properties/wrap-and-shrink.xlsx | Bin 0 -> 9928 bytes test/xlsx/column-width-row-height/input.xlsx | Bin 0 -> 9966 bytes test/xlsx/conditional-format/basic.xlsx | Bin 0 -> 13482 bytes test/xlsx/conditional-format/data-bars.xlsx | Bin 0 -> 11334 bytes test/xlsx/data-table/multi-table.xlsx | Bin 0 -> 9578 bytes test/xlsx/data-table/one-variable.xlsx | Bin 0 -> 9018 bytes test/xlsx/date-cell/input.xlsx | Bin 0 -> 7965 bytes test/xlsx/date-time/input.xlsx | Bin 0 -> 8358 bytes .../doc-structure/unordered-sheet-positions.xlsx | Bin 0 -> 12924 bytes test/xlsx/empty-shared-strings/check.txt | 8 +++++ test/xlsx/empty-shared-strings/input.xlsx | Bin 0 -> 8246 bytes test/xlsx/formatted-text/basic.xlsx | Bin 0 -> 11637 bytes test/xlsx/formatted-text/bold-and-italic.xlsx | Bin 0 -> 9343 bytes test/xlsx/formatted-text/colored-text.xlsx | Bin 0 -> 8780 bytes test/xlsx/formula-array-1/check.txt | 23 ++++++++++++++ test/xlsx/formula-array-1/input.xlsx | Bin 0 -> 8794 bytes test/xlsx/formula-cells/check.txt | 7 +++++ test/xlsx/formula-cells/input.xlsx | Bin 0 -> 8460 bytes test/xlsx/formula-shared/check.txt | 29 ++++++++++++++++++ test/xlsx/formula-shared/input.xlsx | Bin 0 -> 8606 bytes test/xlsx/formula-simple.xlsx | Bin 0 -> 8476 bytes test/xlsx/formula-with-string-results/check.txt | 33 +++++++++++++++++++++ test/xlsx/formula-with-string-results/input.xlsx | Bin 0 -> 9384 bytes test/xlsx/hidden-rows-columns/input.xlsx | Bin 0 -> 9250 bytes test/xlsx/matrix-results/input.xlsx | Bin 0 -> 8514 bytes test/xlsx/merged-cells/simple.xlsx | Bin 0 -> 9456 bytes test/xlsx/named-expression-relative/input.xlsx | Bin 0 -> 8321 bytes test/xlsx/named-expression-sheet-local/check.txt | 22 ++++++++++++++ test/xlsx/named-expression-sheet-local/input.xlsx | Bin 0 -> 8921 bytes test/xlsx/named-expression/check.txt | 12 ++++++++ test/xlsx/named-expression/input.xlsx | Bin 0 -> 8209 bytes test/xlsx/number-format/date-time.xlsx | Bin 0 -> 9514 bytes test/xlsx/pivot-table/chart-simple.xlsx | Bin 0 -> 17470 bytes test/xlsx/pivot-table/error-values.xlsx | Bin 0 -> 11808 bytes test/xlsx/pivot-table/group-by-dates.xlsx | Bin 0 -> 14268 bytes test/xlsx/pivot-table/group-by-numbers.xlsx | Bin 0 -> 12059 bytes test/xlsx/pivot-table/group-field.xlsx | Bin 0 -> 13165 bytes test/xlsx/pivot-table/many-fields.xlsx | Bin 0 -> 12556 bytes test/xlsx/pivot-table/mixed-type-field.xlsx | Bin 0 -> 15206 bytes .../three-pivot-tables-on-one-sheet.xlsx | Bin 0 -> 17103 bytes test/xlsx/pivot-table/two-pivot-caches.xlsx | Bin 0 -> 15538 bytes test/xlsx/pivot-table/two-tables-one-source.xlsx | Bin 0 -> 13496 bytes test/xlsx/raw-values-1/check.txt | 25 ++++++++++++++++ test/xlsx/raw-values-1/input.xlsx | Bin 0 -> 8127 bytes test/xlsx/revision/cell-change-basic.xlsx | Bin 0 -> 15414 bytes test/xlsx/styles/column-styles.xlsx | Bin 0 -> 10289 bytes test/xlsx/styles/direct-format.xlsx | Bin 0 -> 10259 bytes test/xlsx/table/autofilter-text-filter-1.xlsx | Bin 0 -> 9115 bytes test/xlsx/table/autofilter.xlsx | Bin 0 -> 8742 bytes test/xlsx/table/table-1.xlsx | Bin 0 -> 9244 bytes test/xlsx/table/table-2.xlsx | Bin 0 -> 9325 bytes test/xlsx/test.xlsx | Bin 0 -> 12152 bytes test/xlsx/text-alignment/input.xlsx | Bin 0 -> 11421 bytes test/xlsx/view/cursor-per-sheet.xlsx | Bin 0 -> 11521 bytes test/xlsx/view/cursor-split-pane.xlsx | Bin 0 -> 12033 bytes test/xlsx/view/frozen-pane.xlsx | Bin 0 -> 9742 bytes 63 files changed, 162 insertions(+) create mode 100644 test/xlsx/background-color/standard.xlsx create mode 100644 test/xlsx/boolean-values/check.txt create mode 100644 test/xlsx/boolean-values/input.xlsx create mode 100644 test/xlsx/borders/colors.xlsx create mode 100644 test/xlsx/borders/directions.xlsx create mode 100644 test/xlsx/borders/grid-box.xlsx create mode 100644 test/xlsx/borders/single-cells.xlsx create mode 100644 test/xlsx/cell-properties/wrap-and-shrink.xlsx create mode 100644 test/xlsx/column-width-row-height/input.xlsx create mode 100644 test/xlsx/conditional-format/basic.xlsx create mode 100644 test/xlsx/conditional-format/data-bars.xlsx create mode 100644 test/xlsx/data-table/multi-table.xlsx create mode 100644 test/xlsx/data-table/one-variable.xlsx create mode 100644 test/xlsx/date-cell/input.xlsx create mode 100644 test/xlsx/date-time/input.xlsx create mode 100644 test/xlsx/doc-structure/unordered-sheet-positions.xlsx create mode 100644 test/xlsx/empty-shared-strings/check.txt create mode 100644 test/xlsx/empty-shared-strings/input.xlsx create mode 100644 test/xlsx/formatted-text/basic.xlsx create mode 100644 test/xlsx/formatted-text/bold-and-italic.xlsx create mode 100644 test/xlsx/formatted-text/colored-text.xlsx create mode 100644 test/xlsx/formula-array-1/check.txt create mode 100644 test/xlsx/formula-array-1/input.xlsx create mode 100644 test/xlsx/formula-cells/check.txt create mode 100644 test/xlsx/formula-cells/input.xlsx create mode 100644 test/xlsx/formula-shared/check.txt create mode 100644 test/xlsx/formula-shared/input.xlsx create mode 100644 test/xlsx/formula-simple.xlsx create mode 100644 test/xlsx/formula-with-string-results/check.txt create mode 100644 test/xlsx/formula-with-string-results/input.xlsx create mode 100644 test/xlsx/hidden-rows-columns/input.xlsx create mode 100644 test/xlsx/matrix-results/input.xlsx create mode 100644 test/xlsx/merged-cells/simple.xlsx create mode 100755 test/xlsx/named-expression-relative/input.xlsx create mode 100644 test/xlsx/named-expression-sheet-local/check.txt create mode 100644 test/xlsx/named-expression-sheet-local/input.xlsx create mode 100644 test/xlsx/named-expression/check.txt create mode 100644 test/xlsx/named-expression/input.xlsx create mode 100644 test/xlsx/number-format/date-time.xlsx create mode 100644 test/xlsx/pivot-table/chart-simple.xlsx create mode 100644 test/xlsx/pivot-table/error-values.xlsx create mode 100644 test/xlsx/pivot-table/group-by-dates.xlsx create mode 100644 test/xlsx/pivot-table/group-by-numbers.xlsx create mode 100644 test/xlsx/pivot-table/group-field.xlsx create mode 100644 test/xlsx/pivot-table/many-fields.xlsx create mode 100644 test/xlsx/pivot-table/mixed-type-field.xlsx create mode 100644 test/xlsx/pivot-table/three-pivot-tables-on-one-sheet.xlsx create mode 100644 test/xlsx/pivot-table/two-pivot-caches.xlsx create mode 100644 test/xlsx/pivot-table/two-tables-one-source.xlsx create mode 100644 test/xlsx/raw-values-1/check.txt create mode 100644 test/xlsx/raw-values-1/input.xlsx create mode 100755 test/xlsx/revision/cell-change-basic.xlsx create mode 100644 test/xlsx/styles/column-styles.xlsx create mode 100644 test/xlsx/styles/direct-format.xlsx create mode 100644 test/xlsx/table/autofilter-text-filter-1.xlsx create mode 100644 test/xlsx/table/autofilter.xlsx create mode 100644 test/xlsx/table/table-1.xlsx create mode 100644 test/xlsx/table/table-2.xlsx create mode 100644 test/xlsx/test.xlsx create mode 100644 test/xlsx/text-alignment/input.xlsx create mode 100644 test/xlsx/view/cursor-per-sheet.xlsx create mode 100644 test/xlsx/view/cursor-split-pane.xlsx create mode 100644 test/xlsx/view/frozen-pane.xlsx (limited to 'test/xlsx') diff --git a/test/xlsx/background-color/standard.xlsx b/test/xlsx/background-color/standard.xlsx new file mode 100644 index 0000000..91de475 Binary files /dev/null and b/test/xlsx/background-color/standard.xlsx differ diff --git a/test/xlsx/boolean-values/check.txt b/test/xlsx/boolean-values/check.txt new file mode 100644 index 0000000..db2adbf --- /dev/null +++ b/test/xlsx/boolean-values/check.txt @@ -0,0 +1,3 @@ +Sheet1/0/0:string:"Boolean Value" +Sheet1/0/1:boolean:true +Sheet1/0/2:boolean:false diff --git a/test/xlsx/boolean-values/input.xlsx b/test/xlsx/boolean-values/input.xlsx new file mode 100644 index 0000000..c2415cb Binary files /dev/null and b/test/xlsx/boolean-values/input.xlsx differ diff --git a/test/xlsx/borders/colors.xlsx b/test/xlsx/borders/colors.xlsx new file mode 100644 index 0000000..c1f5400 Binary files /dev/null and b/test/xlsx/borders/colors.xlsx differ diff --git a/test/xlsx/borders/directions.xlsx b/test/xlsx/borders/directions.xlsx new file mode 100644 index 0000000..ce293ca Binary files /dev/null and b/test/xlsx/borders/directions.xlsx differ diff --git a/test/xlsx/borders/grid-box.xlsx b/test/xlsx/borders/grid-box.xlsx new file mode 100644 index 0000000..9f52582 Binary files /dev/null and b/test/xlsx/borders/grid-box.xlsx differ diff --git a/test/xlsx/borders/single-cells.xlsx b/test/xlsx/borders/single-cells.xlsx new file mode 100644 index 0000000..95ed7ca Binary files /dev/null and b/test/xlsx/borders/single-cells.xlsx differ diff --git a/test/xlsx/cell-properties/wrap-and-shrink.xlsx b/test/xlsx/cell-properties/wrap-and-shrink.xlsx new file mode 100644 index 0000000..cfc98d5 Binary files /dev/null and b/test/xlsx/cell-properties/wrap-and-shrink.xlsx differ diff --git a/test/xlsx/column-width-row-height/input.xlsx b/test/xlsx/column-width-row-height/input.xlsx new file mode 100644 index 0000000..b488590 Binary files /dev/null and b/test/xlsx/column-width-row-height/input.xlsx differ diff --git a/test/xlsx/conditional-format/basic.xlsx b/test/xlsx/conditional-format/basic.xlsx new file mode 100644 index 0000000..58dd589 Binary files /dev/null and b/test/xlsx/conditional-format/basic.xlsx differ diff --git a/test/xlsx/conditional-format/data-bars.xlsx b/test/xlsx/conditional-format/data-bars.xlsx new file mode 100644 index 0000000..92abfab Binary files /dev/null and b/test/xlsx/conditional-format/data-bars.xlsx differ diff --git a/test/xlsx/data-table/multi-table.xlsx b/test/xlsx/data-table/multi-table.xlsx new file mode 100644 index 0000000..c2bf488 Binary files /dev/null and b/test/xlsx/data-table/multi-table.xlsx differ diff --git a/test/xlsx/data-table/one-variable.xlsx b/test/xlsx/data-table/one-variable.xlsx new file mode 100644 index 0000000..7ff098b Binary files /dev/null and b/test/xlsx/data-table/one-variable.xlsx differ diff --git a/test/xlsx/date-cell/input.xlsx b/test/xlsx/date-cell/input.xlsx new file mode 100644 index 0000000..e855f4d Binary files /dev/null and b/test/xlsx/date-cell/input.xlsx differ diff --git a/test/xlsx/date-time/input.xlsx b/test/xlsx/date-time/input.xlsx new file mode 100644 index 0000000..3f9bd7c Binary files /dev/null and b/test/xlsx/date-time/input.xlsx differ diff --git a/test/xlsx/doc-structure/unordered-sheet-positions.xlsx b/test/xlsx/doc-structure/unordered-sheet-positions.xlsx new file mode 100644 index 0000000..1669d2d Binary files /dev/null and b/test/xlsx/doc-structure/unordered-sheet-positions.xlsx differ diff --git a/test/xlsx/empty-shared-strings/check.txt b/test/xlsx/empty-shared-strings/check.txt new file mode 100644 index 0000000..44ade31 --- /dev/null +++ b/test/xlsx/empty-shared-strings/check.txt @@ -0,0 +1,8 @@ +Sheet1/0/2:numeric:1 +Sheet1/0/4:numeric:5 +Sheet1/1/2:numeric:2 +Sheet1/1/4:numeric:6 +Sheet1/2/2:numeric:3 +Sheet1/2/4:numeric:7 +Sheet1/3/2:numeric:4 +Sheet1/3/4:numeric:8 diff --git a/test/xlsx/empty-shared-strings/input.xlsx b/test/xlsx/empty-shared-strings/input.xlsx new file mode 100644 index 0000000..cf81cf2 Binary files /dev/null and b/test/xlsx/empty-shared-strings/input.xlsx differ diff --git a/test/xlsx/formatted-text/basic.xlsx b/test/xlsx/formatted-text/basic.xlsx new file mode 100644 index 0000000..ffeec9f Binary files /dev/null and b/test/xlsx/formatted-text/basic.xlsx differ diff --git a/test/xlsx/formatted-text/bold-and-italic.xlsx b/test/xlsx/formatted-text/bold-and-italic.xlsx new file mode 100644 index 0000000..40d4830 Binary files /dev/null and b/test/xlsx/formatted-text/bold-and-italic.xlsx differ diff --git a/test/xlsx/formatted-text/colored-text.xlsx b/test/xlsx/formatted-text/colored-text.xlsx new file mode 100644 index 0000000..4a85d37 Binary files /dev/null and b/test/xlsx/formatted-text/colored-text.xlsx differ diff --git a/test/xlsx/formula-array-1/check.txt b/test/xlsx/formula-array-1/check.txt new file mode 100644 index 0000000..7e457d3 --- /dev/null +++ b/test/xlsx/formula-array-1/check.txt @@ -0,0 +1,23 @@ +Sheet1/0/0:numeric:1 +Sheet1/0/2:numeric:4 +Sheet1/0/3:numeric:5 +Sheet1/0/4:numeric:6 +Sheet1/1/0:numeric:2 +Sheet1/2/0:numeric:3 +Sheet1/4/2:formula:{MMULT(A1:A3,C1:E1)}:4 +Sheet1/4/3:formula:{MMULT(A1:A3,C1:E1)}:5 +Sheet1/4/4:formula:{MMULT(A1:A3,C1:E1)}:6 +Sheet1/5/2:formula:{MMULT(A1:A3,C1:E1)}:8 +Sheet1/5/3:formula:{MMULT(A1:A3,C1:E1)}:10 +Sheet1/5/4:formula:{MMULT(A1:A3,C1:E1)}:12 +Sheet1/6/2:formula:{MMULT(A1:A3,C1:E1)}:12 +Sheet1/6/3:formula:{MMULT(A1:A3,C1:E1)}:15 +Sheet1/6/4:formula:{MMULT(A1:A3,C1:E1)}:18 +Sheet1/8/0:numeric:2 +Sheet1/8/2:numeric:10 +Sheet1/8/3:numeric:12 +Sheet1/8/5:formula:{MMULT(A9:A10,C9:D9)}:20 +Sheet1/8/6:formula:{MMULT(A9:A10,C9:D9)}:24 +Sheet1/9/0:numeric:4 +Sheet1/9/5:formula:{MMULT(A9:A10,C9:D9)}:40 +Sheet1/9/6:formula:{MMULT(A9:A10,C9:D9)}:48 diff --git a/test/xlsx/formula-array-1/input.xlsx b/test/xlsx/formula-array-1/input.xlsx new file mode 100644 index 0000000..18016f8 Binary files /dev/null and b/test/xlsx/formula-array-1/input.xlsx differ diff --git a/test/xlsx/formula-cells/check.txt b/test/xlsx/formula-cells/check.txt new file mode 100644 index 0000000..b6abe9c --- /dev/null +++ b/test/xlsx/formula-cells/check.txt @@ -0,0 +1,7 @@ +Sheet1/0/0:numeric:1 +Sheet1/0/1:formula:A1*2:2 +Sheet1/1/0:numeric:2 +Sheet1/1/1:formula:A2-10:-8 +Sheet1/2/0:numeric:3 +Sheet1/2/1:formula:A3/3:1 +Sheet1/4/0:formula:SUM(A1:A3):6 diff --git a/test/xlsx/formula-cells/input.xlsx b/test/xlsx/formula-cells/input.xlsx new file mode 100644 index 0000000..ce73c72 Binary files /dev/null and b/test/xlsx/formula-cells/input.xlsx differ diff --git a/test/xlsx/formula-shared/check.txt b/test/xlsx/formula-shared/check.txt new file mode 100644 index 0000000..8ffca11 --- /dev/null +++ b/test/xlsx/formula-shared/check.txt @@ -0,0 +1,29 @@ +Sheet1/0/0:numeric:10 +Sheet1/0/1:numeric:20 +Sheet1/0/3:numeric:11 +Sheet1/0/4:numeric:11 +Sheet1/0/6:numeric:100 +Sheet1/0/7:formula:G1+2:102 +Sheet1/0/8:formula:H1+2:104 +Sheet1/0/9:formula:I1+2:106 +Sheet1/0/10:formula:J1+2:108 +Sheet1/0/11:formula:K1+2:110 +Sheet1/1/0:formula:A1+1:11 +Sheet1/1/1:formula:B1+1:21 +Sheet1/1/3:formula:D1+1:12 +Sheet1/1/4:formula:E1+1:12 +Sheet1/2/0:formula:A2+1:12 +Sheet1/2/1:formula:B2+1:22 +Sheet1/2/3:formula:D2+1:13 +Sheet1/2/4:formula:E2+1:13 +Sheet1/3/0:formula:A3+1:13 +Sheet1/3/1:formula:B3+1:23 +Sheet1/3/3:formula:D3+1:14 +Sheet1/3/4:formula:E3+1:14 +Sheet1/4/0:formula:A4+1:14 +Sheet1/4/1:formula:B4+1:24 +Sheet1/4/3:formula:D4+1:15 +Sheet1/4/4:formula:E4+1:15 +Sheet1/5/0:formula:A5+1:15 +Sheet1/5/1:formula:B5+1:25 +Sheet1/5/3:formula:D5+1:16 diff --git a/test/xlsx/formula-shared/input.xlsx b/test/xlsx/formula-shared/input.xlsx new file mode 100644 index 0000000..6b31a3f Binary files /dev/null and b/test/xlsx/formula-shared/input.xlsx differ diff --git a/test/xlsx/formula-simple.xlsx b/test/xlsx/formula-simple.xlsx new file mode 100644 index 0000000..e60c1b0 Binary files /dev/null and b/test/xlsx/formula-simple.xlsx differ diff --git a/test/xlsx/formula-with-string-results/check.txt b/test/xlsx/formula-with-string-results/check.txt new file mode 100644 index 0000000..2148be4 --- /dev/null +++ b/test/xlsx/formula-with-string-results/check.txt @@ -0,0 +1,33 @@ +Sheet1/0/0:string:"A" +Sheet1/0/1:formula:CONCATENATE(A1,"-1"):A-1 +Sheet1/0/2:formula:LEFT(B1,2):A- +Sheet1/1/0:string:"B" +Sheet1/1/1:formula:CONCATENATE(A2,"-1"):B-1 +Sheet1/1/2:formula:LEFT(B2,2):B- +Sheet1/2/0:string:"C" +Sheet1/2/1:formula:CONCATENATE(A3,"-1"):C-1 +Sheet1/2/2:formula:LEFT(B3,2):C- +Sheet1/3/0:string:"D" +Sheet1/3/1:formula:CONCATENATE(A4,"-1"):D-1 +Sheet1/3/2:formula:LEFT(B4,2):D- +Sheet1/4/0:string:"E" +Sheet1/4/1:formula:CONCATENATE(A5,"-1"):E-1 +Sheet1/4/2:formula:LEFT(B5,2):E- +Sheet1/5/0:string:"F" +Sheet1/5/1:formula:CONCATENATE(A6,"-1"):F-1 +Sheet1/5/2:formula:LEFT(B6,2):F- +Sheet1/6/0:string:"G" +Sheet1/6/1:formula:CONCATENATE(A7,"-1"):G-1 +Sheet1/6/2:formula:LEFT(B7,2):G- +Sheet1/7/0:string:"H" +Sheet1/7/1:formula:CONCATENATE(A8,"-1"):H-1 +Sheet1/7/2:formula:LEFT(B8,2):H- +Sheet1/8/0:string:"I" +Sheet1/8/1:formula:CONCATENATE(A9,"-1"):I-1 +Sheet1/8/2:formula:LEFT(B9,2):I- +Sheet1/9/0:string:"J" +Sheet1/9/1:formula:CONCATENATE(A10,"-1"):J-1 +Sheet1/9/2:formula:LEFT(B10,2):J- +Sheet1/10/0:string:"K" +Sheet1/10/1:formula:CONCATENATE(A11,"-1"):K-1 +Sheet1/10/2:formula:LEFT(B11,2):K- diff --git a/test/xlsx/formula-with-string-results/input.xlsx b/test/xlsx/formula-with-string-results/input.xlsx new file mode 100644 index 0000000..ce95397 Binary files /dev/null and b/test/xlsx/formula-with-string-results/input.xlsx differ diff --git a/test/xlsx/hidden-rows-columns/input.xlsx b/test/xlsx/hidden-rows-columns/input.xlsx new file mode 100644 index 0000000..7ebc2f5 Binary files /dev/null and b/test/xlsx/hidden-rows-columns/input.xlsx differ diff --git a/test/xlsx/matrix-results/input.xlsx b/test/xlsx/matrix-results/input.xlsx new file mode 100644 index 0000000..c8e1b54 Binary files /dev/null and b/test/xlsx/matrix-results/input.xlsx differ diff --git a/test/xlsx/merged-cells/simple.xlsx b/test/xlsx/merged-cells/simple.xlsx new file mode 100644 index 0000000..ce3ed29 Binary files /dev/null and b/test/xlsx/merged-cells/simple.xlsx differ diff --git a/test/xlsx/named-expression-relative/input.xlsx b/test/xlsx/named-expression-relative/input.xlsx new file mode 100755 index 0000000..af8abe0 Binary files /dev/null and b/test/xlsx/named-expression-relative/input.xlsx differ diff --git a/test/xlsx/named-expression-sheet-local/check.txt b/test/xlsx/named-expression-sheet-local/check.txt new file mode 100644 index 0000000..321f221 --- /dev/null +++ b/test/xlsx/named-expression-sheet-local/check.txt @@ -0,0 +1,22 @@ +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 +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 diff --git a/test/xlsx/named-expression-sheet-local/input.xlsx b/test/xlsx/named-expression-sheet-local/input.xlsx new file mode 100644 index 0000000..6820085 Binary files /dev/null and b/test/xlsx/named-expression-sheet-local/input.xlsx differ diff --git a/test/xlsx/named-expression/check.txt b/test/xlsx/named-expression/check.txt new file mode 100644 index 0000000..d6d6ff0 --- /dev/null +++ b/test/xlsx/named-expression/check.txt @@ -0,0 +1,12 @@ +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):15 +Sheet1/6/1:formula:SUM(MyRange2):55 diff --git a/test/xlsx/named-expression/input.xlsx b/test/xlsx/named-expression/input.xlsx new file mode 100644 index 0000000..080521c Binary files /dev/null and b/test/xlsx/named-expression/input.xlsx differ diff --git a/test/xlsx/number-format/date-time.xlsx b/test/xlsx/number-format/date-time.xlsx new file mode 100644 index 0000000..0a8cccc Binary files /dev/null and b/test/xlsx/number-format/date-time.xlsx differ diff --git a/test/xlsx/pivot-table/chart-simple.xlsx b/test/xlsx/pivot-table/chart-simple.xlsx new file mode 100644 index 0000000..ec16b93 Binary files /dev/null and b/test/xlsx/pivot-table/chart-simple.xlsx differ diff --git a/test/xlsx/pivot-table/error-values.xlsx b/test/xlsx/pivot-table/error-values.xlsx new file mode 100644 index 0000000..9158a10 Binary files /dev/null and b/test/xlsx/pivot-table/error-values.xlsx differ diff --git a/test/xlsx/pivot-table/group-by-dates.xlsx b/test/xlsx/pivot-table/group-by-dates.xlsx new file mode 100644 index 0000000..73e4b23 Binary files /dev/null and b/test/xlsx/pivot-table/group-by-dates.xlsx differ diff --git a/test/xlsx/pivot-table/group-by-numbers.xlsx b/test/xlsx/pivot-table/group-by-numbers.xlsx new file mode 100644 index 0000000..a69a255 Binary files /dev/null and b/test/xlsx/pivot-table/group-by-numbers.xlsx differ diff --git a/test/xlsx/pivot-table/group-field.xlsx b/test/xlsx/pivot-table/group-field.xlsx new file mode 100644 index 0000000..053edef Binary files /dev/null and b/test/xlsx/pivot-table/group-field.xlsx differ diff --git a/test/xlsx/pivot-table/many-fields.xlsx b/test/xlsx/pivot-table/many-fields.xlsx new file mode 100644 index 0000000..157cee4 Binary files /dev/null and b/test/xlsx/pivot-table/many-fields.xlsx differ diff --git a/test/xlsx/pivot-table/mixed-type-field.xlsx b/test/xlsx/pivot-table/mixed-type-field.xlsx new file mode 100644 index 0000000..cf75f1a Binary files /dev/null and b/test/xlsx/pivot-table/mixed-type-field.xlsx differ diff --git a/test/xlsx/pivot-table/three-pivot-tables-on-one-sheet.xlsx b/test/xlsx/pivot-table/three-pivot-tables-on-one-sheet.xlsx new file mode 100644 index 0000000..19fdb1b Binary files /dev/null and b/test/xlsx/pivot-table/three-pivot-tables-on-one-sheet.xlsx differ diff --git a/test/xlsx/pivot-table/two-pivot-caches.xlsx b/test/xlsx/pivot-table/two-pivot-caches.xlsx new file mode 100644 index 0000000..d94790f Binary files /dev/null and b/test/xlsx/pivot-table/two-pivot-caches.xlsx differ diff --git a/test/xlsx/pivot-table/two-tables-one-source.xlsx b/test/xlsx/pivot-table/two-tables-one-source.xlsx new file mode 100644 index 0000000..bae1477 Binary files /dev/null and b/test/xlsx/pivot-table/two-tables-one-source.xlsx differ diff --git a/test/xlsx/raw-values-1/check.txt b/test/xlsx/raw-values-1/check.txt new file mode 100644 index 0000000..935cf22 --- /dev/null +++ b/test/xlsx/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/xlsx/raw-values-1/input.xlsx b/test/xlsx/raw-values-1/input.xlsx new file mode 100644 index 0000000..6754e81 Binary files /dev/null and b/test/xlsx/raw-values-1/input.xlsx differ diff --git a/test/xlsx/revision/cell-change-basic.xlsx b/test/xlsx/revision/cell-change-basic.xlsx new file mode 100755 index 0000000..29e8027 Binary files /dev/null and b/test/xlsx/revision/cell-change-basic.xlsx differ diff --git a/test/xlsx/styles/column-styles.xlsx b/test/xlsx/styles/column-styles.xlsx new file mode 100644 index 0000000..f757c43 Binary files /dev/null and b/test/xlsx/styles/column-styles.xlsx differ diff --git a/test/xlsx/styles/direct-format.xlsx b/test/xlsx/styles/direct-format.xlsx new file mode 100644 index 0000000..838060c Binary files /dev/null and b/test/xlsx/styles/direct-format.xlsx differ diff --git a/test/xlsx/table/autofilter-text-filter-1.xlsx b/test/xlsx/table/autofilter-text-filter-1.xlsx new file mode 100644 index 0000000..57b27e2 Binary files /dev/null and b/test/xlsx/table/autofilter-text-filter-1.xlsx differ diff --git a/test/xlsx/table/autofilter.xlsx b/test/xlsx/table/autofilter.xlsx new file mode 100644 index 0000000..ed81361 Binary files /dev/null and b/test/xlsx/table/autofilter.xlsx differ diff --git a/test/xlsx/table/table-1.xlsx b/test/xlsx/table/table-1.xlsx new file mode 100644 index 0000000..a936f8d Binary files /dev/null and b/test/xlsx/table/table-1.xlsx differ diff --git a/test/xlsx/table/table-2.xlsx b/test/xlsx/table/table-2.xlsx new file mode 100644 index 0000000..a29bae8 Binary files /dev/null and b/test/xlsx/table/table-2.xlsx differ diff --git a/test/xlsx/test.xlsx b/test/xlsx/test.xlsx new file mode 100644 index 0000000..95dadfb Binary files /dev/null and b/test/xlsx/test.xlsx differ diff --git a/test/xlsx/text-alignment/input.xlsx b/test/xlsx/text-alignment/input.xlsx new file mode 100644 index 0000000..6d35d2d Binary files /dev/null and b/test/xlsx/text-alignment/input.xlsx differ diff --git a/test/xlsx/view/cursor-per-sheet.xlsx b/test/xlsx/view/cursor-per-sheet.xlsx new file mode 100644 index 0000000..29d4fb0 Binary files /dev/null and b/test/xlsx/view/cursor-per-sheet.xlsx differ diff --git a/test/xlsx/view/cursor-split-pane.xlsx b/test/xlsx/view/cursor-split-pane.xlsx new file mode 100644 index 0000000..fd37d06 Binary files /dev/null and b/test/xlsx/view/cursor-split-pane.xlsx differ diff --git a/test/xlsx/view/frozen-pane.xlsx b/test/xlsx/view/frozen-pane.xlsx new file mode 100644 index 0000000..26e5558 Binary files /dev/null and b/test/xlsx/view/frozen-pane.xlsx differ -- cgit v1.2.3