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
|
%% --------------------------------------------------------------------------
%mode session
row-limit:1000
column-limit:100
%% --------------------------------------------------------------------------
%mode init
A1:1
A2:2
A3:3
D1=COUNTBLANK(A1:A3)
D2=COUNTBLANK(A3)
D3=COUNTBLANK(A1:A4)
D4=COUNTBLANK(B1:B10)
D5=COUNTBLANK(A4)
D6=COUNTBLANK(B2)
D7=COUNTBLANK(E:E)
%calc
%% --------------------------------------------------------------------------
%mode result
D1=0
D2=0
D3=1
D4=10
D5=1
D6=1
D7=1000
%check
%% --------------------------------------------------------------------------
%mode edit
E5:20
E10:100
%recalc
%mode result
D7=998
%check
%% --------------------------------------------------------------------------
|
