Suspected Bug in SheetChange event

[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

 

[David M. Andersen]

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

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