[Libreoffice-bugs] [Bug 137941] New: Version 7.0.2.2: Not all cells in Calc are automatically recalculating.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137941

            Bug ID: 137941
           Summary: Version 7.0.2.2: Not all cells in Calc are
                    automatically recalculating.
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikehaag314 at gmail.com

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

-- 
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/20201102/a4623b75/attachment.htm>