Installed LO7 (currently at 7.0.2_rc2-0ubuntu0.20.04.2) via LibreOffice PPA on Ubuntu 20.04.
- When I start a new spreadsheet in Calc, and fill in the following in cells A1-A3:
A1: 1 A2: =A1+1 A3: =A1-1
A2 is calculated as 2
A3 is calculated as 0
- Now I change A1 to 2 and press enter:
A2 is autocalculated to 3
A3 remains at 0 (!)
- Now for the fun part - switch to a different application so LO window loses focus:
A3 is now autocalculated to 1.
Another part in the never ending story of AutoCalculate misbehaving, or is it just me?