1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
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
|
