I’m having a hard time getting Calc to evaluate functions and can’t tell if it’s a bug or if I’ve just missed some fundamental change in how functions are supposed to be evaluated.
If I open a new document and enter
2 in cell A1 and
3 in cell A2, then enter
=SUM(A1,A2) in cell A3, when I press Enter, the formula is entered as text and is not evaluated. This even happens if I use a formula that doesn’t depend on cell values, such as
This is happening with LibreOffice 126.96.36.199 from the Fedora 31 repository.
Edit: If I go to Data > Calculate > Formula to Value, it will replace the formula with the calculated value, but the formula is gone. Autocalculate is checked and using Recalculate does nothing.