From 00e2eb4fd0266c5be01e3a527a66aaad5ab4b634 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Mon, 15 Apr 2024 07:47:37 +0200 Subject: Adding upstream version 0.19.0. Signed-off-by: Daniel Baumann --- test/20-table-reference-01.txt | 37 +++++++++++++++++++++++++++++++++++++ 1 file changed, 37 insertions(+) create mode 100644 test/20-table-reference-01.txt (limited to 'test/20-table-reference-01.txt') diff --git a/test/20-table-reference-01.txt b/test/20-table-reference-01.txt new file mode 100644 index 0000000..0e99185 --- /dev/null +++ b/test/20-table-reference-01.txt @@ -0,0 +1,37 @@ +%% Basic table reference test. Set C3:D9 to be a table range with 2 columns +%% 'Category' and 'Value'. +%mode init +C3@Category +C4@A +C5@B +C6@C +C7@D +C8@E +C9@Total +D3@Value +D4:1 +D5:2 +D6:3 +D7:4 +D8:5 +D9=SUBTOTAL(109,[Value]) +E1=SUM(Table1[Value]) +E2=COUNTA(Table1[#Headers]) +E3=COUNTA(Table1[[#Headers],[Category]]) +E4=COUNTA(Table1[[#Headers],[#Data],[Category]]) +%mode table +name=Table1 +range=C3:D9 +columns=Category,Value +totals-row-count=1 +%push +%calc +%mode result +D9=15 +E1=15 +E2=2 +E3=1 +E4=6 +%check +%exit + -- cgit v1.2.3