I use my old ods file years ago. The formulas recalc does not work a few weeks ago.
If I press F2 to edit the formula and at the end of the formula I press a SPACE then ENTER it works.
When I edit C2 and press ENTER, D2 cell shows wrong value.
But if I edit D2 and I press SPACE (so I modify the D2 VALUE ) Calc can calculate the good value.
F9 works but I think I should not have to use F9 all the time.