summaryrefslogtreecommitdiffstats
path: root/test/04-function-mmult.txt
blob: 84eda1c9a503aef68790dd6eb96e66870373dacc (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
32
33
34
35
36
37
38
39
40
41
42
43
%% Test built-in MMULT function which performs a matrix multiplication whose
%% result is a matrix spanning over a range of cells.
%mode init
A1:1
A2:2
A3:3
C1:4
D1:5
E1:6
{C5:E7}{=MMULT(A1:A3,C1:E1)}
E11=E7*10
%calc
%print dependency
%mode result
C5=4
D5=5
E5=6
C6=8
D6=10
E6=12
C7=12
D7=15
E7=18
E11=180
%check
%mode edit
A1:2
A2:4
A3:6
%recalc
%mode result
C5=8
D5=10
E5=12
C6=16
D6=20
E6=24
C7=24
D7=30
E7=36
E11=360
%check
%exit