Ask Your Question

functions do not execute in Calc cells. They just appear as text. This is in LibreOffice 4.1 running in Windows 7, 32 bit [closed]

asked 2014-01-08 00:03:00 +0100

psokolow gravatar image

updated 2016-02-18 14:02:59 +0100

Alex Kemp gravatar image

I have tried re-installing Libre Office, tried re-booting Windows, and all the usual procedures. I have previously run Calc satisfactorily, and opening an old spreadsheet allows me to enter formulas in an ordinary way. I'd appreciate any suggestions on dealing with this!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 14:03:07.704332


Can you expand on how you enter formulas, and give some example formulas that don't work?

bencomp gravatar imagebencomp ( 2014-01-08 00:20:28 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-01-08 00:19:21 +0100

Gerry gravatar image

Can you check whether you have in Extras(Tools) -> Otions -> LibreOffice Calc -> View the option "Show formulas" activated? If this is activated, Calc alwas shows the formula instead of the calculated value.

Another test: Please hit Ctrl + F8. In what colour do you see now your formulas? (Formulas should be green, values blue and text in black)

edit flag offensive delete link more


Thank you Gerry! Your instructions to un-check the "Display Formulas" in cells worked! You saved me from having to buy MS Excel, and instead I donated a few bucks ($) to Libre. I wonder why my installation of Libre 4 defaulted to "Display Formulas"? Users want to see output, not code, in screens. It's as though instead of a web page a URL just showed the HTML input! Whatever, a big thanks to you! psokolow

psokolow gravatar imagepsokolow ( 2014-01-08 14:32:10 +0100 )edit

I'm used to use "Ctrl ~" (Control + tilde) to toggle display formula on/off.

Paijo gravatar imagePaijo ( 2014-01-10 04:44:28 +0100 )edit

@psokolow could you mark the answer as 'correct' by clicking the check mark?

bencomp gravatar imagebencomp ( 2014-01-10 21:41:14 +0100 )edit

Question Tools

1 follower


Asked: 2014-01-08 00:03:00 +0100

Seen: 4,761 times

Last updated: Jan 09 '14