[Solved] kendoSpreadsheet data not refreshing in the grid after update

[Scot]

I am very close to getting this working with all the help within the forums, I appreciate all the people whom have taken the time to post!! Including the KENDO administrators!

 

I can read json withing my transport with no issues and even do an update with no issues BUT after the update when I requery the database sometimes the grid is not refreshed with the new data but the database and the degugging shows the correct data. I use this onclick function to requey the database and was wondering if it is correct.

Thanks again!!

01.function getData(){
02.
03.    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
04.    var sheet = spreadsheet.activeSheet();
05.    sheet.dataSource.transport.options.read.url = "index.cfm?event=general.excel&action=load&startDate=" + $('#startDate').val() + "&endDate=" + $('#endDate').val() + "&lobID=" + $('#area').val();
06.    sheet.dataSource.read();
07.
08.
09.    $('#spreedsheetGrouping').show();
10.
11.} //end getData

 

[Scot]

I think the fix was adding thsi to the transport! UGGGGGGG

 

cache: false

[Veselin Tsvetanov]

Hi Scot,

As you correctly noticed, setting the cache property of the transport.read object to false would prevent the default browser caching.

Regards,
Veselin Tsvetanov
Telerik by Progress