From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/01/06080000.xhp | 57 ++++++++++++++++++++++++++ 1 file changed, 57 insertions(+) create mode 100644 helpcontent2/source/text/scalc/01/06080000.xhp (limited to 'helpcontent2/source/text/scalc/01/06080000.xhp') diff --git a/helpcontent2/source/text/scalc/01/06080000.xhp b/helpcontent2/source/text/scalc/01/06080000.xhp new file mode 100644 index 000000000..ddc72f6f2 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/06080000.xhp @@ -0,0 +1,57 @@ + + + + + + + +Recalculate +/text/scalc/01/06080000.xhp + + + +
+recalculating;all formulas in sheets +recalculate;all formulas in sheets +formulas; recalculating manually +cell contents; recalculating +mw changed "recalculating;...", "formulas;..." and "cell..." entries and deleted "recalculating formulas" + +
+

Recalculate

+Recalculates formula cells. +
+
+ +
+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. +Press F9 to recalculate. Press Shift+CommandCtrl+F9 to recalculate all formulas in the document. +
+
+ +
+Recalculation options are, Recalculation on File Load, with values: +Always recalculate, Never recalculate (default option), Prompt user. + +Press Shift+CommandCtrl+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. + + -- cgit v1.2.3