Linux Format forums Forum Index Linux Format forums
Help, discussion, magazine feedback and more
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Formulas displyed in LibreOffice Calc file

 
Post new topic   Reply to topic    Linux Format forums Forum Index -> Help!
View previous topic :: View next topic  
Author Message
mikejd
LXF regular


Joined: Fri Apr 08, 2005 5:46 pm
Posts: 131
Location: Huntly, Aberdeenshire

PostPosted: Wed Dec 12, 2012 12:07 pm    Post subject: Formulas displyed in LibreOffice Calc file Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website
johnhudson
LXF regular


Joined: Wed Aug 03, 2005 2:37 pm
Posts: 871

PostPosted: Wed Dec 12, 2012 10:24 pm    Post subject: Reply with quote

.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.
Back to top
View user's profile Send private message
View previous topic :: View next topic  
Display posts from previous:   
Post new topic   Reply to topic    Linux Format forums Forum Index -> Help! All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Linux Format forums topic RSS feed 


Powered by phpBB © 2001, 2005 phpBB Group


Copyright 2011 Future Publishing, all rights reserved.


Web hosting by UKFast