Arch Linux

Description:

In libreoffice calc, chancing a value should cause recalculations if the respective setting is on. However, this seems utterly broken at the moment.

Additional info:
$ pacman -Qi libreoffice-fresh
Nimi : libreoffice-fresh
Versio : 7.0.2-1

Steps to reproduce:

1. Create a new libreoffice calc document. Make sure automatic recalculation is enabled (I started with a fresh configuration by deleting ~/.config/libreoffice).
2. Enter the following cells (this is an example - simplest one I can reproduce this reliably); format here is CELL:[VALUE]

A1:[1]
A2:[1]
A3:[=A1+A2]
A4:[1]
A6:[=A3+A4]

3. Change value in A1 to [2] and after that (but any value different from original should work ... or, rather, fail).

Observed results: Value in cell A3 updates to 3 (as it should), but value in A6 does not update to 4 but still displays 3.

Expected results: All cells should update, if the setting is on and cells referred from their formula has been changed.

Other observations:
a) order is important here. In case cell A1 or A2 is changed first, and after that A4 is changed, cell A6 does not update. The inverse is not true always (but sometimes is!).
b) pressing F9 will always update, and as such can be used as a workaround
c) changing any other cell not used as input in any of the formulas, does cause an update! (although, it should not cause a recalculation, as the data has not changed)

First I though this always needs formulas referring to formulas (as in my example), but I've reproduced this even with independent blocks of data (not referring to each other) with depth of 1 (i.e. no cell formula referring to a cell containing a formula), but I can not reproduce those reliably with any example. As such, I'm not sure what is going on.