#1 Summary of calculated fields

[Anonymous]

I love the idea mehind this software!!!

Flexisheet 0.5.6
Macosx 10.3

If I try to summarise calculated fields and put the formulas in "the
wrong" order, it doesn't work. The result is 0.

Example:

1 a3 = a1 * a2
2 r3:a3 = sum(r1:a3..r2:a3)

a1 a2 a3
r1 2 3 =6
r2 4 5 =20
r3 =0.0

If I swap the calculations, it works, but I think a specific reference
(r3:a3) should have precedence over a general reference (a3).

1 r3:a3 = sum(r1:a3..r2:a3)
2 a3 = a1 * a2

Took me a while to realize what was wrong. And It is more intuite
to enter the formulas in the first way.

Regards Sebastian Ware
ware@home.se