diff options
Diffstat (limited to 'test/04-function-columns-rows.txt')
| -rw-r--r-- | test/04-function-columns-rows.txt | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/test/04-function-columns-rows.txt b/test/04-function-columns-rows.txt new file mode 100644 index 0000000..388c348 --- /dev/null +++ b/test/04-function-columns-rows.txt @@ -0,0 +1,20 @@ +%mode init +A1=COLUMNS(A2:B10) +A2=COLUMNS(C1) +A3=COLUMNS(B2,A4:D100) +%calc +%mode result +A1=2 +A2=1 +A3=5 +%check +%mode edit +A1=ROWS(A2:B10) +A2=ROWS(C1) +A3=ROWS(B2,A4:D100) +%recalc +%mode result +A1=9 +A2=1 +A3=98 +%check |