1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<meta>
<topic id="textscalc0106080000xml" indexer="include">
<title id="tit" xml-lang="en-US">Recalculate</title>
<filename>/text/scalc/01/06080000.xhp</filename>
</topic>
</meta>
<body>
<section id="neu">
<bookmark xml-lang="en-US" branch="index" id="bm_id3157909"><bookmark_value>recalculating;all formulas in sheets</bookmark_value>
<bookmark_value>recalculate;all formulas in sheets</bookmark_value>
<bookmark_value>formulas; recalculating manually</bookmark_value>
<bookmark_value>cell contents; recalculating</bookmark_value>
</bookmark><comment>mw changed "recalculating;...", "formulas;..." and "cell..." entries and deleted "recalculating formulas"</comment>
<bookmark xml-lang="en-US" branch="hid/.uno:Calculate" id="bm_id2661876" localize="false"/>
<paragraph role="heading" id="hd_id3157909" xml-lang="en-US" level="1"><link href="text/scalc/01/06080000.xhp" name="Recalculate">Recalculate</link></paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000406.xhp#exnb"/>
</section>
<paragraph role="paragraph" id="par_id3154758" xml-lang="en-US"><ahelp hid=".uno:Calculate">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.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3154759" xml-lang="en-US"><ahelp hid=".uno:Calculate">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.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3154753" xml-lang="en-US"><ahelp hid=".uno:Calculate">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.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id315475899" xml-lang="en-US">Press F9 to recalculate. Press Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas in the document.</paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000406.xhp#exnbr"/>
</section>
<paragraph role="paragraph" id="par_id3150793" xml-lang="en-US">Recalculation options are, Recalculation on File Load, with values:</paragraph>
<paragraph role="paragraph" id="par_id3150795" xml-lang="en-US">Always recalculate, Never recalculate (default option), Prompt user.</paragraph>
<paragraph role="paragraph" id="par_id315475855" xml-lang="en-US">Press Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas in the document, including Add-In functions. The hard recalculation correctly recalculates all formula cells.</paragraph>
<paragraph role="paragraph" id="par_id3150799" xml-lang="en-US">After the document has been recalculated, the display is refreshed. All charts are also refreshed.</paragraph>
</body>
</helpdocument>
|
