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

    Hello,

    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);
                                colPromiseDate.format("MM/dd/yyyy");
                                colPromiseDate.validation({
                                    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.. 

    Thanks. 

    Regards,

    Su Pei

  2. Plamen
    Admin
    Plamen avatar
    3049 posts

    Posted 20 Mar 2017 Link to this post

    Hello,

    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.

    Regards,
    Plamen
    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