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: Shift+Ctrl+F9. 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 Menu/Data/Calculate/Recalculated hard.
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 > 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. @Kohei, 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 https://bugs.documentfoundation.org/show_bug.cgi?id=119623 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, Cor
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": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d8f8fa33f477ddb445ef7a89590ad2314e3f7cca 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: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Data - Calculate - Recalculate Hard (Control + Shift + F9) is available on this version. Version: 6.2.0.0.alpha0+ 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. ***