Formulas displyed in LibreOffice Calc file

The place to post if you need help or advice

Moderators: ChriThor, LXF moderators

Formulas displyed in LibreOffice Calc file

Postby mikejd » 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: Select all

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?

LXF regular
Posts: 141
Joined: Fri Apr 08, 2005 4:46 pm
Location: Huntly, Aberdeenshire

Postby johnhudson » 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.
LXF regular
Posts: 893
Joined: Wed Aug 03, 2005 1:37 pm

Return to Help!

Who is online

Users browsing this forum: No registered users and 3 guests