[Libreoffice-bugs] [Bug 137515] New: EDITING: Auto-Recalculate Not Working Properly in LO Calc v7.0.2.2
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Thu Oct 15 21:27:51 UTC 2020
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>
More information about the Libreoffice-bugs
mailing list