We are having a problem that I was actually able to duplicate using only MSDN sample code (found here) and a blank excel workbook project in Visual Studio. When you use databinding in an excel worksheet, Excel exhibits errant behavior when you insert a row.
When I paste the value of a cell into the newly inserted blank row, not only does that value initially get corrupted by the column title, excel is actually pasting the entire row, not only the selected cell.
On top of that, these two rows are becoming linked, and anything that I type in one, is reflected in the other.
If this sounds confusing, I have included a video that shows a complete demonstration of the issue
Here is that video.
Bookmarks