diff options
Diffstat (limited to '')
| -rw-r--r-- | test/xlsx/formula-with-string-results/check.txt | 33 | ||||
| -rw-r--r-- | test/xlsx/formula-with-string-results/input.xlsx | bin | 0 -> 9384 bytes |
2 files changed, 33 insertions, 0 deletions
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 Binary files differnew file mode 100644 index 0000000..ce95397 --- /dev/null +++ b/test/xlsx/formula-with-string-results/input.xlsx |