%% Table reference test for dependency tracking.  Formulas referencing a
%% table must get recalculated when cells inside the referenced table area
%% are modified.  Both named and unnamed table references are covered.
%mode table
name=Table1
range=C3:D9
columns=Category,Value
totals-row-count=1
%push
%mode init
C3@Category
C4@A
C5@B
C6@C
C7@D
C8@E
C9@Total
D3@Value
D4:1
D5:2
D6:3
D7:4
D8:5
D9=SUBTOTAL(109,[Value])
E1=SUM(Table1[Value])
E2=COUNTA(Table1[#Headers])
%calc
%mode result
D9=15
E1=15
E2=2
%check
%mode edit
D5:12
%recalc
%mode result
D9=25
E1=25
%check
%mode edit
D8:50
%recalc
%mode result
D9=70
E1=70
%check
%exit
