Re: Formulas displyed in LibreOffice Calc file

johnhudson — Wed Dec 12, 2012 10:24 pm

Author: johnhudson

Posted: Wed Dec 12, 2012 10:24 pm

.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.

Formulas displyed in LibreOffice Calc file

mikejd — Wed Dec 12, 2012 12:07 pm

Author: mikejd

Posted: Wed Dec 12, 2012 12:07 pm

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:

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

Linux Format forums

Re: Formulas displyed in LibreOffice Calc file

Formulas displyed in LibreOffice Calc file