https://bugs.documentfoundation.org/show_bug.cgi?id=107930
--- Comment #5 from Eike Rathke <[email protected]> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
