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 Formulae check box. Click OK.
If you want to view the calculation results instead of the formula, do not mark the Formulae check box.