summaryrefslogtreecommitdiffstats
path: root/test/04-function-sheets.txt
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--test/04-function-sheets.txt27
1 files changed, 27 insertions, 0 deletions
diff --git a/test/04-function-sheets.txt b/test/04-function-sheets.txt
new file mode 100644
index 0000000..c427fda
--- /dev/null
+++ b/test/04-function-sheets.txt
@@ -0,0 +1,27 @@
+%% SHEETS returns the number of sheets contained in the reference, or the total
+%% number of sheets in the whole document.
+%mode session
+insert-sheet:Sheet1
+insert-sheet:Sheet2
+insert-sheet:Sheet3
+current-sheet:Sheet1
+%mode init
+A1=SHEETS()
+A2=SHEETS(A1)
+A3=SHEETS(Sheet2!B1:C4)
+A4=SHEETS("str")
+A5=SHEETS(1.2)
+A6=SHEETS(Sheet1:Sheet2!A1)
+A7=SHEETS(Sheet2:Sheet3!B2)
+A8=SHEETS(Sheet1:Sheet3!B10)
+%calc
+%mode result
+A1=3
+A2=1
+A3=1
+A4=#N/A
+A5=#N/A
+A6=2
+A7=2
+A8=3
+%check