mpkirby wrote:
contender wrote:
Conditional formatting recalculates normally.
I found an instance where it does not. That was a case where the cell
contained a formula referencing the last cell in a column. When the
column was extended (so that, consequentially, a different cell became
the last cell), the conditional formatting did not register the change.
This was canvassed in the Calc forum many months ago and an issue may
have been filed.
I'm not sure it's a legitimate issue. You can force a recalculation
with Shift+Ctrl+F9. Whether that is equal to a change thus removed, I
have never tested.
ctrl-shift-f9 doesn't do it for me (nor does apple-shift-f9). What's that
do? Is there a menu function for it?
I am running on an apple, so perhaps the windows behavior is different (I'll
check tomorrow at work).
In my case the cell with the conditional formatting is referencing the cell
in the column immediately to the left. (e.g. b2's conditional formatting is
referencing a2).
I'd argue that conditional formatting should either be affected by turning
off auto-calculate, and be amenable to manual recalculate, or it should be
immune from it. (probably the former, because you could reference a custom
function in conditional formatting that could take a long time).
Mike
Without a bloodhound I couldn't find it in the list in Help.
In Tools >Customise, look in the Category "Options" (?!#¿), Function
"Recalculate Hard".
There is no need to switch off AutoCalculate in order to force a
recalculation.
--
Xfce on PCLinuxOS, OOo 2.0.2 (en_GB).
Direct mail to teaman is not opened; if necessary, email realmail.
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
