Ask Your Question
1

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

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

jllarson3 gravatar image

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

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
1

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

m.a.riosv gravatar image

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

https://help.libreoffice.org/Calc/Rec...

edit flag offensive delete link more

Comments

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 +0100 )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 +0100 )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 5.4.0.3 (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 +0100 )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 +0100 )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 +0100 )edit
1

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

paravantis gravatar image

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

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:

https://ask.libreoffice.org/en/question/120044/autocalculate-stops-working-when-column-is-inserted/

edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 2,726 times

Last updated: Aug 06 '17