diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:47:37 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:47:37 +0000 |
| commit | 00e2eb4fd0266c5be01e3a527a66aaad5ab4b634 (patch) | |
| tree | a6a58bd544eb0b76b9d3acc678ea88791acca045 /test/21-named-exp-worksheet-01.txt | |
| parent | Initial commit. (diff) | |
| download | libixion-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/21-named-exp-worksheet-01.txt')
| -rw-r--r-- | test/21-named-exp-worksheet-01.txt | 73 |
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 + |