test/22-formulas-with-cached-results.txt


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

%% Test case for formula cells with cached results. This test case intentionally
%% does not calculate formula cells before checking their results.
%mode init
D2=RAND()
E6=RAND()+12
F7=145/RAND()
%mode result-cache
D2=12
E6=145
F7=#DIV/0!
%mode result
D2=12
E6=145
F7=#DIV/0!
%check