Ask Your Question
0

Please Help someone

asked 2019-12-01 02:12:42 +0100

benji87 gravatar image

updated 2019-12-01 10:30:12 +0100

keme gravatar image

Hi my name is Benji,

I dont know if anyone will answer this,

I am trying to move away from MS office suite permanently. Trying to use librecalc for the "SUM" function.

When I hit return, I am just left with the argument. like this

=SUM(A6:A11)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-12-01 04:10:44 +0100

Ratslinger gravatar image

Hello,

When posting a question please include your OS and specific LibreOffice version being used. This can affect answers like this one.

You probably have a selection to display formulas. From the menu select Tools->Options. Then double click on LibreOffice Calc in left column. Click on View. Then in right pane see if Formulas under Display section is checked. If so un-check it with a mouse click.

edit flag offensive delete link more

Comments

1

Another option is cells having Text format string; in that case, typing anything into the cell is interpreted as plain text, and not attempted to be interpreted as numbers/formulas/whatever.

Mike Kaganski gravatar imageMike Kaganski ( 2019-12-01 10:14:36 +0100 )edit

Thanks you guys so much !!! its fixed.

are there any tutorials to familiarize myself with the libre office suite? Coming from 20 years of MS Office.

benji87 gravatar imagebenji87 ( 2019-12-03 07:21:08 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-12-01 02:12:42 +0100

Seen: 36 times

Last updated: Dec 01