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 7.0.1.2 of LibreOffice.
Yes, I can confirm this issue with the spreadsheet not auto calculating values. Version: 7.0.2.2 (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
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.
*** This bug has been marked as a duplicate of bug 137248 ***