currently only "Recalculate F9" is available in menu "Data\Calculate".
a user, who needs a full hard recalc has to know about the shortcut keys:
from LO Online Help:
Recalculates all changed formulas. If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW. Press F9 to recalculate.
Press Shift+Ctrl+F9 to recalculate all formulas in the document.
After the document has been recalculated, the display is refreshed.
All charts are also refreshed.
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.
It is already implemented with 6.0.7 and 6.1
Created attachment 144671 [details]
lo 6.1.1 screenshot menu data calcuate
>It is already implemented with 6.0.7 and 6.1
it's possible to add "Recalculate Hard" via "Tools/Customize.../Menus"
but it is not existent in the standard configuration.
Eike, Moggi: was there a reason to not have this function in the menu? Something like potential damage to data.
Forgive Oliver, I have it added in both version, so I though it was already included.
If I remember fine, it was implemented by Samuel years ago, but was reverted. Kohei was against because there was the intention to avoid their need.
(In reply to m.a.riosv from comment #4)
> Forgive Oliver, I have it added in both version, so I though it was already
> If I remember fine, it was implemented by Samuel years ago, but was
> reverted. Kohei was against because there was the intention to avoid their
I thought you could have an opinion in this issue...
my intention was to make it easier for users to deal with
situations as - for example - described in issue:
[Bug 119623] Lonely SUM formula fails to update, and thus
can lead to a treacherously wrong result
where - for whatever reason - "AutoCalculate" and
"Recalculate F9" will not work.
btw: in writer we have: "Menu Tools/Update/Update All"
I support the request,
We discussed the request in the design meeting and don't see any reason why to not add the function. Patch is here https://gerrit.libreoffice.org/#/c/60422/
heiko tietze committed a patch related to this issue.
It has been pushed to "master":
tdf#119671 - UI: Add "Calculate All" to menu "Data\Calculate"
It will be available in 6.2.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Data - Calculate - Recalculate Hard (Control + Shift + F9) is available on this version.
Build ID: e005ab5d40d358adb75a64e140d46f4bf605647d
CPU threads: 4; OS: Linux 4.15; UI render: GL; VCL: gtk2;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-09-15_02:08:38
Locale: ro-RO (ro_RO.UTF-8); Calc: threaded
*** Bug 119971 has been marked as a duplicate of this bug. ***