Ask Your Question
0

LibreOffice Calc not computing functions (showing function, not output)

asked 2016-02-23 22:51:24 +0200

brian15co gravatar image

Hi Everyone,

I cannot get libre office calc to recognize functions. I am being shown the formula as it is typed, not the desired output.

I have tried Tools > Options > LibreOffice Calc > View > Formulas. Either checked or unchecked gives the same result.

Also, if I press Ctrl-F8, text remains black, numbers turn blue, but nothing turns green (another question told me that formulas would turn green).

below are identical questions whose solutions do nothing.

https://ask.libreoffice.org/en/questi...

https://ask.libreoffice.org/en/questi...

http://en.libreofficeforum.org/node/2353

https://ask.libreoffice.org/en/questi...

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2016-02-24 22:20:18 +0200

erAck gravatar image

Check that the cell were you type the formula in is not formatted as text.

edit flag offensive delete link more
0

answered 2016-02-25 01:25:07 +0200

LibreGuy gravatar image

First of all, make sure your formula starts with the = character. Try this formula to test:

=IF(TRUE();"HELLO";"")

Normally you should see "HELLO" in the cell you pasted the formula into.

If not:

  1. Right-click the cell in which you pasted the formula and choose 'format cells'.
  2. Select 'number' and then 'standard' or 'default' (depending on your language). Click 'OK'.
  3. In the formula-bar (the bar on top where you can see your formula) click on the = button. The button will now turn into an Arrow. Click on the arrow.

Now you should see "HELLO".

edit flag offensive delete link more

Comments

This is not working for me , it still shows the formula and not the solution.

Shivaschandra gravatar imageShivaschandra ( 2016-02-26 06:10:05 +0200 )edit

Can you upload your spreadsheet?

LibreGuy gravatar imageLibreGuy ( 2016-02-26 11:58:20 +0200 )edit

You need to type a "space" between equal sign and the rest of formula. At least it worked for me

dvdsev gravatar imagedvdsev ( 2019-07-27 17:10:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-02-23 22:51:24 +0200

Seen: 3,075 times

Last updated: Feb 25 '16