summaryrefslogtreecommitdiffstats
path: root/test/04-function-countblank.txt
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--test/04-function-countblank.txt38
1 files changed, 38 insertions, 0 deletions
diff --git a/test/04-function-countblank.txt b/test/04-function-countblank.txt
new file mode 100644
index 0000000..7ce2706
--- /dev/null
+++ b/test/04-function-countblank.txt
@@ -0,0 +1,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
+%% --------------------------------------------------------------------------
+
+