Ask Your Question

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

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

jllarson3 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 close merge delete

2 Answers

Sort by » oldest newest most voted

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

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 1,962 times

Last updated: Aug 06 '17