Description:
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

Version: 7.0.2.2
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