Eike Rathke wrote:
Hi Peter,
On Sun, Mar 27, 2005 at 08:07:56 -0600, Peter Kupfer wrote:
But, in the shortcut keys list Tools > Configure > Keyboard, there is a
distinction between a recalc, and a recalc hard. Just want to know what
it is.
A normal recalc calculates formula cells that are marked "dirty", for
example because cells they depend on changed, and that aren't
recalculated yet by displaying or otherwise accessing results. A hard
recalc calculates _all_ formula cells, independent of state. Normally
you don't notice a difference because all that is displayed in a view is
already recalculated. You may notice a difference if formulas use macro
functions that have side effects, for example.
Eike
Thanks.
--
Peter Kupfer
OOo user since 'OO4
http://peschtra.tripod.com/open_office/ooo_front.htm
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]