Performance issue on spreadsheet data validation

2 posts, 0 answers
  1. Su Pei
    Su Pei avatar
    11 posts
    Member since:
    Nov 2016

    Posted 16 Mar 2017 Link to this post


    I'm having slow performance in spreadsheet validation. 

        var sheets = $("#spreadsheet").data("kendoSpreadsheet").sheets();

          var colPromiseDate = sheets .activeSheet().range("C2:C" + sheets.activeSheet()._rows._count);
                                    dataType: "date",
                                    showButton: true,
                                    allowNulls: true,
                                    type: "reject",
                                    comparerType: "between",
                                    from: "01/01/2000",
                                    to: "01/01/2099",
                                    titleTemplate: "Date validaton error",
                                    messageTemplate: "Invalid Date"

    I had debug the script, only this part will affect the performance of the page. 

    My spreadsheet have 200 rows which get from kendo grid data source, so I can't do it in sheets.rows.cell validation. 

    FYI, I have tried to use for loop to put in validation on each cell, but the result is still the same. 

    Please advice.. 



    Su Pei

  2. Plamen
    Plamen avatar
    3080 posts

    Posted 20 Mar 2017 Link to this post


    I have tested a similar scenario bug could not observe the performance issue. would you please try to isolate it in a sample dojo page or send a runnable page so we could inspect it and be more helpful.

    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