Format method slow

Hi syncfusion team,

We are currently working on a project in which we are using syncfusion.
This project is using speadsheets to allow users to edit data as if they were working with excel.

While developing we encountered some issue with the response time of the spreadsheet components.
If we use the recommended way to call the format method (by creating a client side event), the initialization of the component take around 20 seconds (which we found too slow considering our current clients).
We are thinking of deferring this formatting once the "dom" of the page is completely loaded with a "window.onload" method.

Still, we were wondering if it is possible to give us some advice in order to improve the performances while using the standard way.

You'll find attached to this a screenshot of the page with the performance from the chrome console.
You'll also find a copy of the page code, in which we declare a spreadsheet and configure a event when loaded in order to add style and formatting.

We observed that the bottom neck of the "loadComplete" method is when we call the "ej.spreadsheet" format method.
You'll find this method call on line 92 of the page file, and his definition on starting line 131.

If you need more information, please don't hesitate to contact me.

Thank you for your help. 

Regards,

Maurice.


Attachment: MDM_spreadsheets_e74ff60e.rar

1 Reply

SK Shanmugaraja K Syncfusion Team January 19, 2018 09:55 AM UTC

Hi Maurice, 
 
Thanks for using Syncfusion products, 
 
We have checked your provided attachment, we have created simple sample and applied format based on your code examples, which is in the “loadComplete” event. While applying format it will take around ~4 seconds only. We have attached the sample in the below location, 
 
 
Could you please try the above sample and check whether you can reproduce the same issue in that sample also? If not, please replicate the same issue in the above sample and get back to us and provide more information about the issue. So that we can able to sort out the issue and provide you a better solution quickly. 
 
Regards, 
Shanmugaraja K 


Loader.
Up arrow icon