slow spreadsheet problem

asked 2013-02-06 17:35:46 +0800

DonDiegoDellaVega gravatar image DonDiegoDellaVega

Hi all,

I use ZK spreadsheet and meet a big problem of slowness when I use it :
My excel source file contains about 30,000 rows * 40 columns. To avoid overloading the spreadsheet, I make a pagination system (500 displayable rows each time * 40 columns).

There are two problems with slow :
- the first delay occurs when I scroll down to see my 500th line: at least 8 seconds to load before I can see the last line (for the first scroll)
- the second problem, much more painful is that when I start to scroll on a page, and then I want to pass on the next page, the calculation takes almost 30 seconds (2 seconds if I didn't scroll on first page !!)
Note : I did tests with six columns, and it is much faster (instead of 30 seconds for case 2, it takes approximately 6 seconds, but I need to see all columns).

My spreadsheet configuration :
clientCacheDisabled="true" //I have only one page
maxRenderedCellSize="22000" //I try with 8000 and same problem

Do you have any ideas for me to optimize the spreadsheet?

thanks a lot (and sorry for my bad english but it's google who translate for me :) )

delete flag offensive retag edit
Be the first one to answer this question!
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

1 follower



Asked: 2013-02-06 17:35:46 +0800

Seen: 7 times

Last updated: Feb 06 '13

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More