VSTO and Excel-- End Cell Edit Mode Programmatically?
Because of processing large data set, I used a second thread to fill
the data into the cells by asynchronous invoke. So that, the interface
can keep active, while filling the grids. Once user selected a cell and
entered into the edit mode, the problem came out. The program can't
access the Sheet object, can't visit the Range property. if tried, a
COMException is the result. So How can I end cell edit mode
programmatically?
I found a way to end cell edit mode in this forum, that is using
"SendKeys" method. But even calling this function will generate an
exception. How do I solve this problem? Or should I stop interface
responding when filling large data set?
Thanks,
|