1 files changed, 73 insertions, 0 deletions
diff --git a/test/21-named-exp-worksheet-01.txt b/test/21-named-exp-worksheet-01.txt
new file mode 100644
index 0000000..0356c54
--- /dev/null
+++ b/test/21-named-exp-worksheet-01.txt
@@ -0,0 +1,73 @@
+%% Named expression in sheet scope.
+%% Sizes of the equally named sheet-local ranges are intentionally different,
+%% to easily test whether the correct range is picked on each sheet.
+%% --------------------------------------------------------------------------
+%mode session
+row-limit:1000
+column-limit:100
+insert-sheet:Sheet1
+insert-sheet:Sheet2
+current-sheet:Sheet1
+display-sheet-name:true
+%% --------------------------------------------------------------------------
+%mode init
+A1:1
+A2:2
+A3:3
+A4:4
+A5:5
+B1:6
+B2:7
+B3:8
+B4:9
+B5:10
+B7=SUM(MyLocalRange)
+%% --------------------------------------------------------------------------
+%mode session
+current-sheet:Sheet2
+%% --------------------------------------------------------------------------
+%mode init
+A1:10
+A2:20
+A3:30
+A4:40
+A5:50
+B1:60
+B2:70
+B3:80
+B4:90
+B5:100
+B7=SUM(MyLocalRange)
+%% --------------------------------------------------------------------------
+%mode named-expression
+name=MyLocalRange
+scope=Sheet1
+expression=Sheet1!$A$1:$A$5
+origin=Sheet1!$A$1
+%push
+%% --------------------------------------------------------------------------
+%mode named-expression
+name=MyLocalRange
+scope=Sheet2
+expression=Sheet2!$A$4:$B$5
+origin=Sheet2!$A$1
+%push
+%% --------------------------------------------------------------------------
+%calc
+%% --------------------------------------------------------------------------
+%mode result
+Sheet1!B7=15
+Sheet2!B7=280
+%check
+%% --------------------------------------------------------------------------
+%mode edit
+Sheet1!A5@some text
+Sheet2!B4@other text
+%recalc
+%% --------------------------------------------------------------------------
+%mode result
+Sheet1!B7=10
+Sheet2!B7=190
+%check
+%exit
+