[Libreoffice-bugs] [Bug 137599] New: cells calculated value not recalculated until window refocus

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137599
           Summary: cells calculated value not recalculated until window
                    refocus
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: heather.ellsworth at canonical.com

Description:
This was reported by a user on launchpad:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454

The problem is better explained via steps to reproduce (see steps below) but
basically if a cell in calc is a *calculated value* based off of another cell,
and the original cell's value changes, then that change is not reflected in the
calculated cell's value until the cursor focus goes to another application and
comes back to libreoffice.

Steps to Reproduce:
1. Start calc; you'll get a new spreadsheet.
2. Fill in the following in cells A1-A3:

  A1: 1
  A2: =A1+1
  A3: =A1-1
As expected: A2 is calculated as 2, A3 is calculated as 0.

3. Change A1 to 2 and press enter. A2 is autocalculated to 3, but A3 remains at
0 (wrong!).
4. Now for the fun part: switch to a different application so LibreOffice
window loses focus, the put it back in focus. A3 is now recalculated to 1.

Actual Results:
The cell's values are updated only if the cursor focus goes to another
application and then back to libreoffice.

Expected Results:
The cell's values should be updated immediately.


Reproducible: Always


User Profile Reset: No



Additional Info:
This was first reported by a user running Ubuntu 20.10 with libreoffice
7.0.2-0ubuntu1 (repackaged 7.0.2.2 release).

I've also reproduced this on a debian testing system with the TDF
LibreOffice_7.0.2_Linux_x86-64_deb.tar.gz

-- 
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/20201019/50b1d5a5/attachment-0001.htm>