Ask Your Question

Why are the formulas in Calc not giving results? [closed]

asked 2014-06-04 16:54:08 +0200

Jemerys gravatar image

updated 2014-06-23 22:44:16 +0200

bencomp gravatar image

None of the existing formulas are working nor will new formulas work. This is occurring on all my spreadsheets.

I now only have this occurring in one spread sheet and I will create a new one to replace it. Unfortunately this is a very large spread sheet and will take many hours to recreate. Is there a setting that might have been changed on this file to prevent any formulas from working?

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-26 09:22:29.629582


Hi Jeremys, close is not for when a question is solved, please take a look at the help.

m.a.riosv gravatar imagem.a.riosv ( 2014-06-05 16:01:30 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-06-05 02:01:47 +0200

m.a.riosv gravatar image

updated 2014-06-23 23:10:42 +0200

Have you enable: Menu/Tools/Cell Contents/Autocalculate., it is an option per file.

Some formulas need a hard recalc [Ctrl+Shift+F9]

edit flag offensive delete link more


Thank you for your response! I do not see any way to pull up a menu - I guess I am not experienced enough to follow through on your first suggestion. The second hard recalc does work but I would need to do it with every entry I make in to the spread sheet.

Jemerys gravatar imageJemerys ( 2014-06-05 02:46:13 +0200 )edit

[Alt+t] calls Menu/Tools [F10] calls the Menu.

m.a.riosv gravatar imagem.a.riosv ( 2014-06-05 15:47:51 +0200 )edit

Thank you - not sure how many times I looked at tools and never saw what I needed. That did the trick - I appreciate your help!

Jemerys gravatar imageJemerys ( 2014-06-05 15:55:26 +0200 )edit

answered 2014-06-04 17:16:39 +0200

Same here. LibreOffice (Fedora20 fully updated). Please, fix ASAP.

edit flag offensive delete link more


Please use the comments to respond to answers or questions; your "answer" does not answer the question.

bencomp gravatar imagebencomp ( 2014-06-23 22:42:23 +0200 )edit

Question Tools

1 follower


Asked: 2014-06-04 16:54:08 +0200

Seen: 114 times

Last updated: Jun 23 '14