This has happened since upgrading top v5.x
F9 does not recalculate. Recalculate on Open doesn’t recalculate. Auto Recalculate doesn’t recalculate.
Shift+Ctrl+F9 will force recalculate OK.
What got broken? How do I fix it?
John L
Same functions needs a hard recalc try with [Ctrl+Shift+F9].
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,
On a LibreOffice Calc 5.4.0.3 sheet, an initial version of which was imported from an Excel 2016 file, I confirm that automatic recalculation occasionally stops working; it takes closing and opening the document to have recalculate work again.
Opening the *.ods file in Excel 2016 works flawlessly as far as recalculation is concerned.
This is very annoying, because one cannot trust that a spreadsheet will be properly calculated at any point in time.
Initially, I thought that this might be related to importing a *.xlsx file. But after doing some research, it may be a bug. I have posted more here: