summaryrefslogtreecommitdiffstats
path: root/test/21-named-exp-workbook-01.txt
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--test/21-named-exp-workbook-01.txt54
1 files changed, 54 insertions, 0 deletions
diff --git a/test/21-named-exp-workbook-01.txt b/test/21-named-exp-workbook-01.txt
new file mode 100644
index 0000000..ee55057
--- /dev/null
+++ b/test/21-named-exp-workbook-01.txt
@@ -0,0 +1,54 @@
+%% Basic named expression support.
+%% --------------------------------------------------------------------------
+%mode session
+row-limit:1000
+column-limit:100
+insert-sheet:Sheet1
+insert-sheet:Sheet2
+current-sheet:Sheet1
+%% --------------------------------------------------------------------------
+%mode init
+A1:1
+A2:2
+A3:3
+A4:4
+A5:5
+B1:6
+B2:7
+B3:8
+B4:9
+B5:10
+A7=SUM(MyRange)
+B7=SUM(MyRange2)
+%% --------------------------------------------------------------------------
+%mode named-expression
+name=MyRange
+expression=Sheet1!$A$1:$A$5
+origin=Sheet1!$A$1
+%push
+%% --------------------------------------------------------------------------
+%mode named-expression
+name=MyRange2
+expression=Sheet1!$A$1:$B$5
+origin=Sheet1!$A$1
+%push
+%% --------------------------------------------------------------------------
+%calc
+%% --------------------------------------------------------------------------
+%mode result
+A7=15
+B7=55
+%check
+%% --------------------------------------------------------------------------
+%mode edit
+A1:10
+%% --------------------------------------------------------------------------
+%recalc
+%% --------------------------------------------------------------------------
+%mode result
+A7=24
+B7=64
+%check
+%% --------------------------------------------------------------------------
+%exit
+