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
--
View this message in context:
http://www.nabble.com/Conditional-Formatting-in-Calc-tf2748429.html#a7670506
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
