Bug 137515 - EDITING: Auto-Recalculate Not Working Properly in LO Calc v7.0.2.2
Summary: EDITING: Auto-Recalculate Not Working Properly in LO Calc v7.0.2.2
Status: RESOLVED DUPLICATE of bug 137248
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2020-10-15 21:27 UTC by Jim Aragon
Modified: 2020-10-16 07:35 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Calc File Showing Auto-recalculate problem (19.63 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-15 21:27 UTC, Jim Aragon

Note You need to log in before you can comment on or make changes to this bug.
Description Jim Aragon 2020-10-15 21:27:51 UTC
Created attachment 166395 [details]
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 of LibreOffice.
Comment 1 Fabiano Freitas 2020-10-15 22:55:12 UTC
Yes, I can confirm this issue with the spreadsheet not auto calculating values.

Version: (x86)
Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: pt-BR (pt_BR); UI: en-US
Calc: CL
Comment 2 Ming Hua 2020-10-16 01:17:50 UTC
Setting to NEW according to comment #1.

This is most likely the same issue as in bug 137248 though, which has been fixed in master and 7-0 branches.

Please test a daily build (https://dev-builds.libreoffice.org/daily/master/) if you can or wait for 7.0.3 release scheduled mid-November.
Comment 3 Mike Kaganski 2020-10-16 07:35:18 UTC

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