If you want to display the formulae in the cells, for example in the form =SUM(A1:B5), proceed as follows:
Choose LibreOffice - PreferencesTools - Options - LibreOffice Calc - View.
In the Display area mark the Formulas box. Click OK.
If you want to view the calculation results instead of the formula, do not mark the Formulas box.