Ask Your Question

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

asked 2016-10-31 19:37:23 +0200

jllarson3 gravatar image

updated 2020-10-12 17:58:32 +0200

Alex Kemp gravatar image

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

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 2020-10-12 17:58:16.492313

2 Answers

Sort by » oldest newest most voted

answered 2016-10-31 23:25:13 +0200

m.a.riosv gravatar image

Same functions needs a hard recalc try with [Ctrl+Shift+F9].

edit flag offensive delete link more


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.

jllarson3 gravatar imagejllarson3 ( 2016-11-01 04:04:51 +0200 )edit

From the Help:

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

WTF? Who decided this?

jllarson3 gravatar imagejllarson3 ( 2016-11-01 04:06:45 +0200 )edit

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 (x64) I use on my computer (when the alleged mysterious recalculate bug does not make an appearance).

paravantis gravatar imageparavantis ( 2017-08-06 23:18:59 +0200 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2017-08-07 01:37:34 +0200 )edit

'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,

newbie-02 gravatar imagenewbie-02 ( 2020-07-25 10:50:51 +0200 )edit

answered 2017-08-06 23:06:17 +0200

paravantis gravatar image

updated 2017-08-06 23:56:55 +0200

On a LibreOffice Calc 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:

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-10-31 19:37:23 +0200

Seen: 2,889 times

Last updated: Aug 06 '17