%% --------------------------------------------------------------------------
%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
%% --------------------------------------------------------------------------