blob: 6d49c8cd35be163efd35b08d2b8857a697ffd47b (
plain)
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
28
29
30
31
|
%mode session
insert-sheet:Sheet1
insert-sheet:Sheet2
insert-sheet:Sheet3
current-sheet:Sheet1
%mode init
A1=SHEET(Sheet1!B1)
A2=SHEET(Sheet2!B1)
A3=SHEET(Sheet3!B1)
B1=SHEET(Sheet1!D1:F10)
B2=SHEET(Sheet2!D1:F10)
B3=SHEET(Sheet3!D1:F10)
C1=SHEET("Sheet1")
C2=SHEET("Sheet2")
C3=SHEET("Sheet3")
C4=SHEET("DoesNotExist")
D1=SHEET()
%calc
%mode result
A1=1
A2=2
A3=3
B1=1
B2=2
B3=3
C1=1
C2=2
C3=3
C4=#N/A
D1=1
%check
|
