Thank you for reporting this issue to help improve Ubuntu! I've confirmed the issue in a groovy vm with 7.0.2-0ubuntu1, I also confirmed the issue in a debian testing vm with the upstream 7.0.2.2 packages, and I opened an upstream bug.
** Bug watch added: Document Foundation Bugzilla #137599 https://bugs.documentfoundation.org/show_bug.cgi?id=137599 ** Also affects: df-libreoffice via https://bugs.documentfoundation.org/show_bug.cgi?id=137599 Importance: Unknown Status: Unknown ** Changed in: libreoffice (Ubuntu) Status: New => Triaged ** Tags added: rls-gg-incoming -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1900454 Title: Calc doesn't recalculate formulas on cell content changes Status in LibreOffice: Unknown Status in libreoffice package in Ubuntu: Triaged Bug description: libreoffice-calc 1:7.0.2-0ubuntu1 (Groovy) The problem is better explained via 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!). 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. (Partially taken from: https://ask.libreoffice.org/en/question/271324/calc-v7022-cell- autocalculate-not-working-while-window-has-focus/) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1900454/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
