How to refresh speadsheet control after adding data from code

[Jason Plank]

I hope someone can help me.

I am working on a program where I get data from a website, and then display certain parts in a Spreadsheet control. When I initialize my app, I make a new single-page workbook, and add the first row headers. When I process and change pages, in the page loaded method I get the data I want and add it to the next row in the worksheet. My problem is it doesn't reflect in the spreadsheet unless I click in the columns. I want it to display the data as soon as I add it, but I can't find anyway to refresh it. I tried using the SfSpreadSheet control as well, but when I add this to my WPF window, my visual studio crashes.

[Kanimozhi Bharathi]

Hi Jason Plank,

Thank you for contacting Syncfusion Support

We recommend you to use SfSpreadsheet which is an alternate to SpreadsheetControl for better stability and performance and please find the response for your queries below,

QUERY	RESPONSE
I tried using the SfSpreadSheet control as well, but when I add this to my WPF window, my visual studio crashes.	We are unable to reproduce the issue with our sample. Please check with the sample from the below link, Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/CS-2048599566 Could you please update us the exact replication procedure to reproduce the issue and also about the OS , Microsoft Visual Studio version  and .Net framework version details to sort out the issue and provide appropriate solution.
I want it to display the data as soon as I add it, but I can't find anyway to refresh it	You need to invalidate the cells to update the cell values in the view. Please find the UG link below, UG: http://help.syncfusion.com/wpf/sfspreadsheet/working-with-sfspreadsheet#setting-the-cellvalue-at-runtime

Please let us know if you have any query.

Regards
Kanimozhi B