Handle and display heavy data in spreadsheet

[LW]

Hi,

 

We had been using kendo spreadsheet with heavy load of data around 200+ columns and 500+ rows on one sheet. Each cell width and height is around 10 - 15px respectively which we want user to overview their data. Hence, displaying and rendering a lot of cells of data which will cause overloading of memory and performance. The problem is we also keep fetching and rendering the data from server after some modification. This causing the website will drop framerate and causing the website "not responding" for few seconds.

Is there any solution to render the spreadsheet "smoother"? And we are thinking of solution to render the spreadsheet at the background but not sure how. OR is there other solution or component to load this heavy load of data? Any solution is welcome.

 

Thanks,

Fungus.

 

[Neli]

Hello,

In some scenarios loading large data in the Spreadsheet could lead to performance issues. However, I have tested to load 20 columns and 4500 rows in Spreadsheet (90000 cells), and the data was loaded on my end without any issue. Could you please let me know if the issue occurs in all browsers or in a specific one? Could you please share the Spreadsheet configuration so we could perform tests with scenario closer to yours?

Looking forward to your reply.

Regards,
Neli
Progress Telerik

[zeeshan]

Neli

 

I am also facing rendering issue on jquery sheet and rendering issue occurs on google chrome browser

and working fine on mozilla firefox.

https://stackoverflow.com/questions/78186922/jquery-sheet-facing-rendering-issue

http://code.google.com/p/jquerysheet/

jquery sheet version "jQuery.Sheet v3.1 Release Candidate"

Looking Forward to your reply

 

Thanks & Regards,

Zeeshan Hyder

[Nikolay]

Hi Zeeshan,

I see this is related to jQuery.Sheet v3.1 and not Kendo UI for jQuery Spreadsheet. Am I wrong?

This is the forum for the Kendo UI library and we can only address inquiries regarding Kendo UI components.

Regards,

Nikolay

[LW]

Thanks for input.

The problem was due performance issue of loading large data and rendering numerous cell of kendo spreadsheet at once. The requirement needs that without kendo spreadsheet scrolling the page render the whole data (10000+ cells). In this circumstance, the issue mentioned will occur without doubt. It's not the issue for kendo spreadsheet but in our perspective using kendo spreadsheet rendering large data is the best for our requirement. Hence, we are seeking better solution to solve the heavy data rendering problem or render kendo spreadsheet in different way.

If I post in the wrong platform, please let me know. Thanks

Regards,

Fungus.

[zeeshan]

LW

I am also facing rendering issue on jquery sheet and rendering issue occurs on google chrome browser

and working fine on mozilla firefox.

https://stackoverflow.com/questions/78186922/jquery-sheet-facing-rendering-issue

http://code.google.com/p/jquerysheet/

jquery sheet version "jQuery.Sheet v3.1 Release Candidate"

Looking Forward to your reply

 

Thanks & Regards,

Zeeshan Hyder

[Neli]

Hi LW,

Could you please share more details about the implementation at your end? In order to be able to provide suggestions for resolving the issue, we will need more information about the performed operations related to the Spreadsheet and the modifications you mentioned. Also, more information about the widget configuration could be helpful.

For example, performance issues could be observed when the range method is called for a big number of cells. In such a case, after each call of the range method, the Spreadsheet is re-rendered and this could lead to performance issues. For such scenarios, we suggest using the batch method. Of course, this is just an example, and to provide a suitable suggestion we will need more details about the issue. 

Regards,
Neli
Progress Telerik