This is a migrated thread and some comments may be shown as answers.

kendoSpreadsheet data not refreshing in the grid after update

2 Answers 201 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Scot
Top achievements
Rank 1
Scot asked on 28 Apr 2017, 04:11 PM

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

 

2 Answers, 1 is accepted

Sort by
0
Scot
Top achievements
Rank 1
answered on 28 Apr 2017, 06:48 PM

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

 

cache: false

0
Veselin Tsvetanov
Telerik team
answered on 02 May 2017, 01:13 PM
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
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Spreadsheet
Asked by
Scot
Top achievements
Rank 1
Answers by
Scot
Top achievements
Rank 1
Veselin Tsvetanov
Telerik team
Share this question
or