Suspected Bug in SheetChange event

I

Iain

Hi

I'm using OWC10 (XP) and am having problems with the SheetChange
event. It doesn't seem to fire if a cell is changed as a result of
recalculation rather than by the user modifying it manually. Is this
deliberate? I can do a workaround by trapping the Calculate event as
well, but it would be nice to have consistency with the way Excel
treats these events.

Has anyone else found this?

Iain
 
D

David M. Andersen

Iain said:
Hi

I'm using OWC10 (XP) and am having problems with the SheetChange
event. It doesn't seem to fire if a cell is changed as a result of
recalculation rather than by the user modifying it manually. Is this
deliberate? I can do a workaround by trapping the Calculate event as
well, but it would be nice to have consistency with the way Excel
treats these events.

Has anyone else found this?

Iain
Click to expand...


It would probably be deliberate. Technically, the contents of the cell
aren't changing. Just the dependencies.
 
Top