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

Performance issue on spreadsheet data validation

1 Answer 56 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Su Pei
Top achievements
Rank 1
Su Pei asked on 17 Mar 2017, 02:11 AM

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

1 Answer, 1 is accepted

Sort by
0
Plamen
Telerik team
answered on 20 Mar 2017, 12:32 PM
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.
Tags
Spreadsheet
Asked by
Su Pei
Top achievements
Rank 1
Answers by
Plamen
Telerik team
Share this question
or