Formulas displyed in LibreOffice Calc file

[mikejd]

I have a Calc file saved as .sxc which has a number of formulae in cells. I have amended some of these then saved the file. When I reopen the file the formulae are shown as the formula not the result ie

Code: Select all

ooow:=[.K14]*[.CZ14]

This happens every time I save the file. Can anyone tell me which setting causes this, as it has changed from what used to happen?

confused,
Mike

[johnhudson]

.sxc is now deprecated in LibreOffice. Save as .ods instead.

Have a look in Tools>Options>Calc>View to see if you have Formulae checked.