Calc v5.1.5.2 - F9 won't recalculate. Auto recalculate also doesn't work. [closed]

edit

Yes, Hard Realc works.

But, why does auto-recalculate, and recalculate upon opening not work at all? If it is in the configuration and tools, it should work.

It does not.

Since it does not work, it is a bug, or it should be removed as a feature. I've suffered nearly a year with this non-functioning function.

From the Help:

"If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW."

WTF? Who decided this?

I do not believe this assertion of the online Help is correct: when AutoCalculate is enabled, even simple formulas (e.g. multiplying cells by numbers) appear to work with spreadsheets with LibreOffice 5.4.0.3 (x64) I use on my computer (when the alleged mysterious recalculate bug does not make an appearance).

@jllarson3, Who decided this?, maybe the common sense, or you can have a spreadsheet with a never end change.

'hard recalc' (forced recalc, ctrl-shift-F9) isn't a fix for broken functionality!
it's an analysis tool to check if something went wrong with the calculation chains,
the more we start using it as standard, the more the users get prone to errors reg. forgotten recalcs, and we to the complaints and reports about it,

and once it's the tool for normal work there is no tool to check if it failed,

it's not a tool, it's a crutch, don't get used to it!

thus i consider things like: 'The Add-In functions like RANDBETWEEN currently cannot respond to the Recalculate command or F9. Press Shift+Ctrl+F9 to recalculate all formulas, including the Add-In functions.' from the link in the answer a step in a wrong direction,