Formulas displyed in LibreOffice Calc file

The place to post if you need help or advice

Moderators: ChrisThornett, 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
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
mikejd
LXF regular
 
Posts: 132
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.
johnhudson
LXF regular
 
Posts: 881
Joined: Wed Aug 03, 2005 1:37 pm


Return to Help!

Who is online

Users browsing this forum: No registered users and 7 guests