Why are the formulas in Calc not giving results?

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?

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

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

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

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.

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

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!

Same here.
LibreOffice 4.2.4.2-15.fc20 (Fedora20 fully updated). Please, fix ASAP.

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