Autocalc not working as expected (2nd-order formulas)

asked 2017-10-11 19:07:48 +0100

voxorg gravatar image

Calc version 5.4.3.2 (x64).

Sheet is created brand new in this version of Calc. Doesn't matter if it's an unsaved Untitled-1 or has been saved - same behavior either way.

There is only one sheet. There are columns of raw data, and columns of formulas that use data (1st-level formulas). Then there are additional columns of raw data, and columns of formulas that use the results of the 1st-level formulas and the additional raw data.

To make this a little clearer as an example: A1 = 1 A2 = 1 A3 = sum(a1:a2) A4 = 1 A5 = sum(a3:a4)

The sheet is using min,max,abs, and sum in various ways.

If A1 or A2 is changed, A3 automatically updates. If A1 or A2 or A4 is changed, A5 is not automatically updating - this is my problem.

Autocalc is on. F9 doesn't update A5, even though it's only a single sheet. Control-Shift-F9 works, or copy+pasteover.

So, help?

edit retag flag offensive close merge delete