[Libreoffice-bugs] [Bug 137515] New: EDITING: Auto-Recalculate Not Working Properly in LO Calc v7.0.2.2

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137515
           Summary: EDITING: Auto-Recalculate Not Working Properly in LO
                    Calc v7.0.2.2
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Jim at agdatasystems.com

Created attachment 166395
  --> https://bugs.documentfoundation.org/attachment.cgi?id=166395&action=edit
Calc File Showing Auto-recalculate problem

I'm using LibreOffice v7.0.2.2 on Windows 10.

I've attached a spreadsheet that is an anonymized sheet, with dummy values,
from a larger spreadsheet. The only calculations on this sheet are SUM() and
addition.

If I change one of the amounts for one of the checking accounts, the "Total
Checking" amount will update immediately, but totals farther down, such as
"Total Savings" and "Adjusted Total Savings" do not update until I press F9.
This is true on two different Windows 10 systems.

Data > Calculate > AutoCalculate is on. Tools > Options > LibreOffice Calc >
Formula > Recalculation on File Load is set to "Always recalculate" for both
"Excel 2007 and newer" and for "ODF spreadsheet (not saved by LibreOffice):"

All of the totals do update automatically on the same computers using the
latest PortableApps version of OpenOffice and using PortableApps version
7.0.1.2 of LibreOffice.

-- 
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/20201015/08d0b386/attachment.htm>