blob: f6f3fc12b5ffd219a5c5fa9f0afe5fc8f027b867 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
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
|
