Launchpad has imported 2 comments from the remote bug at https://bugs.documentfoundation.org/show_bug.cgi?id=137599.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2020-10-19T17:24:58+00:00 Heather Ellsworth wrote: 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 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/1 ------------------------------------------------------------------------ On 2020-10-19T17:54:01+00:00 Eike Rathke wrote: *** This bug has been marked as a duplicate of bug 137248 *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/3 ** Changed in: df-libreoffice Status: Unknown => Invalid ** Changed in: df-libreoffice Importance: Unknown => Medium -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1900454 Title: Calc doesn't recalculate formulas on cell content changes To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1900454/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs