Ask Your Question

Libreoffice Calc v6.1.3.2: Recalculate (F9) only works when a single cell is highlighted. How can I apply recalculate to the entire sheet?

asked 2020-10-17 18:30:42 +0100

DWLOffice gravatar image

Recalculate (F9) only works when a single cell is highlighted. I want the complete sheet, with several randbetween() cells to recalculate.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-10-18 02:15:33 +0100

newbie-02 gravatar image

hello @DWLOffice,

i understand your question as if sometimes not all cells are recalculated, may be there are some 'non volatile' values, strings or formulas,

F9 is intended to recalculate the selected cell, in some versions (tested 7.1) it also affects some other - volatile - formulas, independent what's actually selected,

to recalculate the whole sheet use [strg-shift-F9], that triggers a 'hard recalc' which should - with some small limitations - recalculate the whole sheet,


P.S. 'solved marks' and 'likes' welcome,
click the grey circled hook - ✓ - top left to the answer to turn it green if the problem is solved,
click the "^" above it if you 'like' the answer,
"v" if you don't,
do not! use 'answer' to add info to your question, either edit the question or add a comment,
'answer' only if you found a solution yourself ...

edit flag offensive delete link more


For those using English keyboards it is Ctrl+Shift+F9

Cheers, Al

Earnest Al gravatar imageEarnest Al ( 2020-10-18 08:35:18 +0100 )edit

answered 2020-10-17 20:58:23 +0100

m.a.riosv gravatar image

RANDBETWEEN() it's a volatile function so it is recalculated every time a cell change. If you want it only recalculated with [F9] there is a new function recently added RANDBETWEEN.NV() .
LibreOffice 7.0 release notes

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-10-17 18:30:42 +0100

Seen: 52 times

Last updated: Oct 18