doubling entry problem in List - Excel Vsto 2010

Question

Hi 

I have a very strange strange issue. 

I created a document customised excel template which has a listobject bound to the database. 

I added a table in Data source and dragged it to a worksheet. (so they are bound).

Sometimes when I add some information in a cell, it also adds to other cells in the same column.. it gets copied into the cells below. 

I wonder why this happens..  

I have already distributed the application and this is very embarrassing. 

Has anyone had this problem before? 

I am thinking to rewrite the entire application again. I just can not think how to tackle this issue. 

Hope someone can help me a solution soon. 

Cheers!!!

Answer 1

Are you trying to edit the cells within the range of the bound data source?

That is, if you imported the data source to, say, A1:E25, are you adding information to cell(s) within the range of A1:E25?

Answer 2

Yes. 

Answer 3

I know what happened now. 

It was Sort Issue on listobject with bindingsource.

http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/d6644f8d-3726-4087-83cc-665143a9ffd0

I wasn't sure what was causing the issue. Now I know and it seems it is still an issue.