Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index


All,

I’m having a problem understanding the Help information for these functions (search for “recalculate” in the Help index).

The Help seems to state that choosing Data > Calculate > Recalculate (or its equivalent shortcut F9) “recalculates the currently selected cells and formula cells that depend on them”. Whatever I try in Calc, these interactions affect lots of cells, not just those currently selected.

In an empty spreadsheet, try the following:
(a) Set Data > Calculate > AutoCalculate to off.
(b) Type =a1+1 into cell a2.
(c) Type the value 1 into cell a1.
(d) Type =e5+1 into cell e6.
(e) Type the value 1 into cell e5.
(f) Select cells e5 and e6.
(g) Choose Data > Calculate > Recalculate or press F9.
When I do this, the value in the unselected cell a2 is updated.

Is the Help inaccurate or am I muddled?

And, if my example above is valid, what does Recalculate Hard do that Recalculate doesn’t?

Regards,

Steve


Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.