<?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/. * --> <meta> <topic id="recalculate hard" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Recalculate hard</title> <filename>/text/scalc/01/recalculate_hard.xhp</filename> </topic> </meta> <body> <bookmark id="bm_id581645217532281" xml-lang="en-US" branch="hid/.uno:CalculateHard" localize="false"/> <bookmark xml-lang="en-US" branch="index" id="bm_id351645231629404"> <bookmark_value>calculate;recalculate hard</bookmark_value> <bookmark_value>formulas;recalculate hard</bookmark_value> <bookmark_value>calculate;force recalculation</bookmark_value> <bookmark_value>formulas;force recalculation</bookmark_value> <bookmark_value>non volatile functions;force recalculation</bookmark_value> <bookmark_value>cell contents;force recalculation</bookmark_value> </bookmark> <section id="recalculate_hard_head"> <h1 id="hd_id611645217532285"><variable id="recalculatehardh1"><link href="text/scalc/01/recalculate_hard.xhp">Recalculate Hard</link></variable></h1> <paragraph id="par_id631645217532291" role="paragraph" xml-lang="en-US">Recalculates all formulas in the document, including Add-In functions and non-volatile functions.</paragraph> </section> <section id="howtoget"> <embed href="text/scalc/00/00000406.xhp#recalculate_hard"/> </section> <paragraph role="paragraph" id="par_id361645227084327">The <menuitem>Recalculate Hard</menuitem> command forces recalculation of all formula cells of the spreadsheet document, including explicit non-volatile functions, even if no new input event exist. Examples of explicit non-volatile functions are <link href="text/scalc/01/04060106.xhp#rand_nv">RAND.NV</link> and <link href="text/scalc/01/04060106.xhp#randbetween_nv">RANDBETWEEN.NV</link>.</paragraph> </body> </helpdocument>