diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:47:37 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:47:37 +0000 |
| commit | 00e2eb4fd0266c5be01e3a527a66aaad5ab4b634 (patch) | |
| tree | a6a58bd544eb0b76b9d3acc678ea88791acca045 /test/04-function-counta-edit.txt | |
| parent | Initial commit. (diff) | |
| download | libixion-00e2eb4fd0266c5be01e3a527a66aaad5ab4b634.tar.xz libixion-00e2eb4fd0266c5be01e3a527a66aaad5ab4b634.zip | |
Adding upstream version 0.19.0.upstream/0.19.0upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
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 |