ListObject datasource doesn't show updated values in change event.

[Suresh3594]

[FONT=&quot]Hi,[/FONT]
[FONT=&quot]I am working with Excel tables in vsto addin. Following is the steps that I am following to create a table using VSTO.[/FONT]
[FONT=&quot]Create listObject-> Get data from server -> Bind data retrieved from server to listObject.[/FONT]
[FONT=&quot]I can see the table getting created in worksheet. Now the problem is edit. I am using Worksheet.Change event to capture edit on table. The issue I am facing here is, when the control reaches WorkSheet change event, List object data source shows old value, i.e value before edit. But I want to see the updated value in change event. Is there anything that I am missing here?

PS : When I edit for second time, ListObject shows values that was edited for the first time.[/FONT]

 

[Colin Legg]

I haven't done any work with the ListObject control, but on MSDN it shows there is a ListObject Change() event (or possibly ListObject DataSourceChanged() event) which you could use instead?

 

[Suresh3594]

I tried ListObject change event, but it did not work. It was still showing old values

 

[Suresh3594]

Need to try DataSourceChanged though

 

[Suresh3594]

DataSourceChanged event is raised when data source is changed, not when contents of data source is modified.