summaryrefslogtreecommitdiffstats
path: root/test/04-function-columns-rows.txt
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-15 05:47:37 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-15 05:47:37 +0000
commit00e2eb4fd0266c5be01e3a527a66aaad5ab4b634 (patch)
treea6a58bd544eb0b76b9d3acc678ea88791acca045 /test/04-function-columns-rows.txt
parentInitial commit. (diff)
downloadlibixion-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-columns-rows.txt')
-rw-r--r--test/04-function-columns-rows.txt20
1 files changed, 20 insertions, 0 deletions
diff --git a/test/04-function-columns-rows.txt b/test/04-function-columns-rows.txt
new file mode 100644
index 0000000..388c348
--- /dev/null
+++ b/test/04-function-columns-rows.txt
@@ -0,0 +1,20 @@
+%mode init
+A1=COLUMNS(A2:B10)
+A2=COLUMNS(C1)
+A3=COLUMNS(B2,A4:D100)
+%calc
+%mode result
+A1=2
+A2=1
+A3=5
+%check
+%mode edit
+A1=ROWS(A2:B10)
+A2=ROWS(C1)
+A3=ROWS(B2,A4:D100)
+%recalc
+%mode result
+A1=9
+A2=1
+A3=98
+%check