Description:
In a calc sheet in LO7, formulas you write in some cells are not updated if you change some of their input values, even if automatic update is on (as default). This is actually a showstopper: it becomes impossible to rely on results in your spreadsheet, as you end up having some wrong numbers mixed with updated ones

Steps to Reproduce:
1.Open the attached sheet; in column A there are some numbers (A1:A6) and then some formulas, simple things like sum, mean, variance
2.Now click on any of the A1:A6 cell and write another number. when you press return, you expect to have all formulas updating their results
3. What actually happens is that only the first formula (A7) is updated, the following ones (A8:a10) are NOT. You have to press F9 to have a manual update to see them correctly
4. but it's even more complicated: now change a number in A1:A6 again: as before , only formula in A7 changes correctly. Now write something in some other cell, say d12: this will cause the formula in A8 to update, but NOT the formulas in A9:A10! So the mechanism managing cells update is really obscure.

Actual Results:
Due to what I described in the steps, it is impossible to be really safe and sure about which numbers are correct and which are wrong in a sheet. This actually makes Calc in LO7 strongly unrealiable and is forcing me to downgrade to LO6.

Expected Results:
As before, all formulas in a sheet should upgrade their results everytime som changes are made in the sheet, unless you manually disable automatic updating


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.2.2 (x64)
Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994
CPU threads: 8; OS: Windows 10.0 Build 17763; UI render: Skia/Raster; VCL: win
Locale: it-IT (it_IT); Interfaccia utente: it-IT
Calc: threaded