Bug 137784 - LibreOffice 7.0.2 Not Auto Calulating
Summary: LibreOffice 7.0.2 Not Auto Calulating
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-27 02:51 UTC by Travis
Modified: 2020-10-27 06:09 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Travis 2020-10-27 02:51:44 UTC
When I enter a formula in a cell based on another cell... i.e. in e9: =e8+d9 and I enter a new value in d9, that particular cell (e9) will calculate but all the cells below (same formula copied down the row to keep a running total of the values entered in column d).  It is as if the auto calculate only goes across the row but not down the column.  I have verified the auto calulate is turned on, and even turned on the always calculate options for older file version (which this is not).  Pressing F9 does force the calculation, but no matter the auto calculate setting, my sheets do NOT auto calculate.

Steps to Reproduce:
1. enter a formula in a column of cells (i.e. column D) that adds the above cell total to the value in the cell in the column to the left (i.e. column C)
2. enter values in column C.
3. column d should maintain a running total, but it only does this on the initial entry into column C.... if I then go to the top and change one of the column C entries, only that rows column D total updates, the ones below do not.

Actual Results:
Only the total in the same row as the entry was made in Column C did the total in column D update... the values in the below column D cells did not, and they should have since this is a running total... cell D formula is =D1+C2 and so on.  Pressing F9 works.

Expected Results:
The values in column D should total the values above it in column C.  This worked on the prior version of Libreoffice, and has never been an issue previously.  It seems like auto calculate is disabled even though it is turned on.  Pressing F9 works.

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 Ming Hua 2020-10-27 06:09:55 UTC
Thanks for reporting.  This issue has been reported as bug 137248 and since fixed.  The upcoming 7.0.3 release will include the fix.

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