Bug 137521 - Calc Formulas in adjacent cells ARE NOT UPDATED anymore
Summary: Calc Formulas in adjacent cells ARE NOT UPDATED anymore
Status: RESOLVED DUPLICATE of bug 137248
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2020-10-16 07:30 UTC by Andy
Modified: 2020-10-16 07:35 UTC (History)
0 users

See Also:
Crash report or crash signature:

the sheet were you can check the problem as indicated in the Steps to reproduce (9.51 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-16 07:33 UTC, Andy

Note You need to log in before you can comment on or make changes to this bug.
Description Andy 2020-10-16 07:30:32 UTC
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: (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
Comment 1 Andy 2020-10-16 07:33:23 UTC
Created attachment 166401 [details]
the sheet were you can check the problem as indicated in the Steps to reproduce
Comment 2 Mike Kaganski 2020-10-16 07:35:37 UTC

*** This bug has been marked as a duplicate of bug 137248 ***