Public bug reported: 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/) ** Affects: libreoffice (Ubuntu) Importance: High Status: New ** Changed in: libreoffice (Ubuntu) Importance: Undecided => High -- 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 package in Ubuntu: New 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/ubuntu/+source/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
