Current https://help.libreoffice.org/Calc/Recalculate says: Choose Tools - Cell Contents - Recalculate while recalculation from LO 4.0 is in "Menu/Tools/Options/LibreOffice calc/Formula - Recalculation on file load". Default values should also be added, up to LO 3.6 it was "Always" and from 4.0 it's "Never recalculate". (I submitted a Bug 107929 on that). Also, recalculation and cached value import should be explained.
Yep.
You could propose the explanation and doc team can steal it from this report, if you don't want to set up the help git repository (which is somewhat annoying now).
Not sure. Please improve: Recalculates all changed formulas that otherwise have caches values which are normally used for performance reasons. Recalculation options are set in Menu/Tools/Options - LibreOffice calc/Formula/Recalculation on file load with values. If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW. Press F9 to recalculate selected cells. A soft recalculation only recalculates dirty cells and it' useful if you disable automatic recalculation. The Add-In functions like RANDBETWEEN currently cannot respond to the Recalculate command or F9. Press Shift+Ctrl+F9 to recalculate all formulas in the document, including the Add-In functions. The hard recalculation should correctly recalculate all the cells. After the document has been recalculated, the display is refreshed. All charts are also refreshed.
Recalculate Recalculates all changed formulas that otherwise have caches values which are normally used for performance reasons. Recalculation options are set in Menu/Tools/Options - LibreOffice Calc/Formula/Recalculation on file load with values: Always Recalculate, Never Recalculate (default option), Prompt User. Press F9 to recalculate selected cells. A soft recalculation only recalculates dirty cells and it' useful if you disable automatic recalculation. Press Shift+Ctrl+F9 to recalculate all formulas in the document, including the Add-In functions. The hard recalculation should correctly recalculate all the cells. After the document has been recalculated, the display is refreshed. All charts are also refreshed. If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW. The Add-In functions like RANDBETWEEN currently cannot respond to the Recalculate command or F9.
Better matching reality ;-) Recalculate If AutoCalculate is disabled, the Recalculate command recalculates all (so-called dirty) formula cells that depend on changed cell content and their dependents, and formula cells containing volatile functions such as RAND() or NOW() and formula cells that depend on them. If AutoCalculate is enabled, the Recalculate command applies only to formula cells containing volatile functions like RAND() or NOW() and formula cells that depend on them. In either mode, with formula cell(s) selected pressing F9 recalculates the currently selected cells and formula cells that depend on them. This can be useful after reading documents with recalculation disabled and individual cells need recalculation. Recalculation options are set in menu Tools -> Options -> LibreOffice Calc -> Formula, Recalculation on File Load, with values: Always recalculate, Never recalculate (default option), Prompt user. Press Shift+Ctrl+F9 to recalculate all formulas in the document, including Add-In functions. The hard recalculation correctly recalculates all formula cells. After the document has been recalculated, the display is refreshed. All charts are also refreshed.
Haha, Eike changed the reality in Bug 102257 and than matched the text.
*** Bug 113985 has been marked as a duplicate of this bug. ***
As Dan Dascalescu noticed in duplicated bug, documentation should be updated also for the menu location of recalculating formulas: https://help.libreoffice.org/Calc/Recalculate points to the old location of "Recalculate" Actual Results: Tools - Cell Contents - Recalculate Expected Results: Data -> Calculate -> Recalculate
Mark-R committed a patch related to this issue. It has been pushed to "master": https://gerrit.libreoffice.org/#/c/67237/
Thanks, Mark, but this does not seem to be fully done. The text in Eike's comment 5 was supposed to replace the contents of 06080000.xhp.
Mark committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/+/328abcbac6eba3c0bcfcd9fc82c5afd79d6e8d05%5E%21 tdf#107930 - Help needs to be corrected and amended for Recalculation
Thanks, let's set to FIXED.
(In reply to Buovjaga from comment #12) > Thanks, let's set to FIXED. Buovjaga, how is this fixed when on this link is the same old explanation? https://help.libreoffice.org/Calc/Recalculate "Choose Tools - Cell Contents - Recalculate"
(In reply to BogdanB from comment #13) > (In reply to Buovjaga from comment #12) > > Thanks, let's set to FIXED. > > Buovjaga, how is this fixed when on this link is the same old explanation? > > https://help.libreoffice.org/Calc/Recalculate > "Choose Tools - Cell Contents - Recalculate" Because that is the obsolete wikihelp that has not been regenerated for years. Please look at https://helponline.libreoffice.org/6.3/en-US/text/scalc/01/06080000.html