Performance issue on spreadsheet data validation

[Su Pei]

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

[Plamen]

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