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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
