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
1 ●1 ●1 ●1

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

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

10514 ●14 ●42 ●42 http://etmg.altervista...

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!

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

Comments

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

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

add a comment

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

Gerry
219 ●1 ●6 ●8

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

Comments

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 ( 2014-01-08 14:32:10 +0100 )edit

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

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

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

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

add a comment

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]

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

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

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] edit

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

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

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]

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