[Libreoffice-bugs] [Bug 107930] Help needs to be corrected and amended for Recalculation

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed May 24 18:14:02 UTC 2017


https://bugs.documentfoundation.org/show_bug.cgi?id=107930

--- Comment #3 from Timur <gtimur at gmail.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170524/23da20d2/attachment-0001.html>


More information about the Libreoffice-bugs mailing list