kendoSpreadsheet data not refreshing in the grid after update

3 posts, 0 answers
  1. Scot
    Scot avatar
    2 posts
    Member since:
    May 2014

    Posted 28 Apr 2017 Link to this post

    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. Scot
    Scot avatar
    2 posts
    Member since:
    May 2014

    Posted 28 Apr 2017 Link to this post

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

     

    cache: false

  3. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1201 posts

    Posted 02 May 2017 Link to this post

    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.
Back to Top