diff options
Diffstat (limited to 'test/04-function-counta-edit.txt')
| -rw-r--r-- | test/04-function-counta-edit.txt | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/test/04-function-counta-edit.txt b/test/04-function-counta-edit.txt new file mode 100644 index 0000000..f6f3fc1 --- /dev/null +++ b/test/04-function-counta-edit.txt @@ -0,0 +1,43 @@ +%% Test for COUNTA function. +%mode init +A1:1 +A2:2 +A3:3 +B1@A +B2@B +B3@C +C1=COUNTA(A1:B6) +%calc +%mode result +C1=6 +%check +%mode edit +A2@Two +A4@Four +%recalc +%mode result +C1=7 +%check +%mode edit +B6:10 +B7:11 +%recalc +%mode result +C1=8 +%check +%mode edit +A6=18+3 +A7=2/3 +%recalc +%mode result +A6=21 +C1=9 +%check +%mode edit +C2=COUNTA(A3:B3) +%recalc +%mode result +C1=9 +C2=2 +%check +%exit |