Case: LibreCalc (any OS) displaying formulas instead of their output, without any prior changes to settings and for any document.
- Close any open documents
- Create a new document (spreadsheet)
- Navigate to Tools -> Options -> LibreOffice Calc -> View
- Uncheck Formulas under Display and save settings
- Close the document
- Open your last document, should be fixed.