VSTO and Excel-- End Cell Edit Mode Programmatically?

[htloop]

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,

 

[NickHK]

Excel is not designed to work this way.
If your code forced me out of Edit Mode whilst I was trying to enter some
complex text/formula, I would be somewhat annoyed and your addin would
immediately removed.
If your code is processing data, don't let me enter edit mode; i.e. don't do
it asynchronous.
Or arrange for the suspend itself until such time as further processing is
possible.

NickHK

 

[loop]

Thanks. I think you are right. Maybe I should avoid meeting this case.