OWC Cut and Paste Event

[texlnghorn]

What event is triggered when a cut and paste operation is executed in an OWC
spreadsheet? I thought the EndEdit event would be triggered but that appears
not to be the case. I am trying to validate whether or not a speadsheet has
been changed whn I cut and paste data. To get my spreadsheet to function
properly I have to go back into my cell and hit enter to force the EndEdit
event to fire.

Thanks,
Mike

 

[Alvin Bruney - ASP.NET MVP]

You can either check the dirty property of the spreadsheet to determine if
it changed, check the range in question, or sheetchange event. However, for
the latter, the event is only fired when the range loses focus NOT when the
cell changes. For instance, while you are entering data, the event is not
fired.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006