[Libreoffice-bugs] [Bug 137521] New: Calc Formulas in adjacent cells ARE NOT UPDATED anymore

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137521

            Bug ID: 137521
           Summary: Calc Formulas in adjacent cells ARE NOT UPDATED
                    anymore
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: silvandy at katamail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201016/8cc67d4e/attachment.htm>