Page Index Toggle Pages: 1 Send TopicPrint
Normal Topic Slow loading (Read 5957 times)
Damon
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 4
Joined: Feb 27th, 2014
Slow loading
Feb 27th, 2014 at 2:44pm
Print Post  
Hi, I am trying to populate a worksheet with data, roughly 10k cells. This takes more than a minute. Is this normal or can I do something to speed the process?

Damon
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Slow loading
Reply #1 - Feb 27th, 2014 at 3:36pm
Print Post  
Hi,

Try loading the cell data inside a BeginInit/EndInit block:

Code
Select All
worksheet.BeginInit();
// Populate the worksheet here
worksheet.EndInit(); 


Let me know if this helps.

Regards,
Meppy
  
Back to top
 
IP Logged
 
Damon
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 4
Joined: Feb 27th, 2014
Re: Slow loading
Reply #2 - Feb 28th, 2014 at 11:44am
Print Post  
This helped, thanks

Damon
  
Back to top
 
IP Logged
 
Damon
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 4
Joined: Feb 27th, 2014
Re: Slow loading
Reply #3 - Mar 3rd, 2014 at 10:21am
Print Post  
I'm trying to save the above worksheet (~10k cells) in a file using savetofile, it takes around a minute. The BeginInit trick does't appear to help.

Damon
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Slow loading
Reply #4 - Mar 4th, 2014 at 12:20pm
Print Post  
Hi,

We made some improvements to the binary serialization of the workbook. A new version of the control can be downloaded from the link below:

https://mindfusion.eu/_temp/MindFusion.Spreadsheet.trial.zip

Unfortunately, the new binary format is not backward compatible and any previously saved workbooks will not load.

I hope this helps.

Regards,
Meppy
  
Back to top
 
IP Logged
 
Damon
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 4
Joined: Feb 27th, 2014
Re: Slow loading
Reply #5 - Mar 6th, 2014 at 12:22pm
Print Post  
thank you
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send TopicPrint