Bug 137941 - Version Not all cells in Calc are automatically recalculating.
Summary: Version Not all cells in Calc are automatically recalculating.
Status: RESOLVED DUPLICATE of bug 137248
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2020-11-02 17:05 UTC by mikehaag314
Modified: 2020-11-02 17:26 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Simple spreadsheet to test autocalculation. (8.80 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-11-02 17:07 UTC, mikehaag314

Note You need to log in before you can comment on or make changes to this bug.
Description mikehaag314 2020-11-02 17:05:12 UTC
Not all cells are recalculating. In particular, cells that depend on summary cells (for example, "grand total" cell that depends on two or more "sub-total" cells) fails to automatically recalculate.

Steps to Reproduce:
1. Set up a simple spreadsheet:
A1 = 1000
A2 = 1000
A3 = SUM(A1:A2)

A5 = 1000
A6 = 1000
A7 = SUM(A5:A6)

A9 = SUM(A3,A7)

2. Assure Data > Calculate > AutoCalculate is checked.
3. Observe A3 = 2000, A7 = 2000, and A9 = 4000

Actual Results:
1. Change A1 to 2000 and <Enter or Return>

2. Observe A3 updates to 3000, but A9 is still 4000.
3. Push F9, save the file, or click to another desktop window (so the spreadsheet loses focus) and observe that A9 updates to 5000.

Expected Results:
Expect all cells to recalculate when AutoCalculate is checked.

Reproducible: Always

User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes

Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.2-0ubuntu1
Calc: threaded
Comment 1 mikehaag314 2020-11-02 17:07:31 UTC
Created attachment 166951 [details]
Simple spreadsheet to test autocalculation.
Comment 2 Aron Budea 2020-11-02 17:26:52 UTC
This is fixed in 7.0.3, please download the latest version.

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