summaryrefslogtreecommitdiffstats
path: root/test/xlsx/formula-with-string-results/check.txt
diff options
context:
space:
mode:
Diffstat (limited to 'test/xlsx/formula-with-string-results/check.txt')
-rw-r--r--test/xlsx/formula-with-string-results/check.txt33
1 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-