<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Help needs to be corrected and amended for Recalculation" href="https://bugs.documentfoundation.org/show_bug.cgi?id=107930#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Help needs to be corrected and amended for Recalculation" href="https://bugs.documentfoundation.org/show_bug.cgi?id=107930">bug 107930</a> from <a class="email" href="mailto:gtimur@gmail.com" title="Timur <gtimur@gmail.com>"> Timur</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>