- Welcome, Guest. Please Login or Register
MindFusion  
  We are soon releasing MindFusion.JavaScript pack. Initial version includes chart, diagram, calendar, map, virtual keyboard, gauge and UI components. Here are the beta version and live demo for anyone interested.  
  HomeHelpSearchLoginRegister   
     
     
   
 
Page Index Toggle Pages: 1 Send Topic Print  
Slow loading
Read 2991 times

Damon   Offline
YaBB Newbies
*
Posts: 4
I Love MindFusion!


   
     
 
Slow loading
Feb 27th, 2014 at 2:44pm
 
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
 
 
 
IP Logged    
 
     

Meppy   Offline
YaBB Moderator
*****
Posts: 1783
Gender: male
MindFusion support


   
     
 
Re: Slow loading
Reply #1 - Feb 27th, 2014 at 3:36pm
 
Hi,

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

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


Let me know if this helps.

Regards,
Meppy
 
 
 
IP Logged    
 
     

Damon   Offline
YaBB Newbies
*
Posts: 4
I Love MindFusion!


   
     
 
Re: Slow loading
Reply #2 - Feb 28th, 2014 at 11:44am
 
This helped, thanks

Damon
 
 
 
IP Logged    
 
     

Damon   Offline
YaBB Newbies
*
Posts: 4
I Love MindFusion!


   
     
 
Re: Slow loading
Reply #3 - Mar 3rd, 2014 at 10:21am
 
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
 
 
 
IP Logged    
 
     

Meppy   Offline
YaBB Moderator
*****
Posts: 1783
Gender: male
MindFusion support


   
     
 
Re: Slow loading
Reply #4 - Mar 4th, 2014 at 12:20pm
 
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:

http://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
 
 
 
IP Logged    
 
     

Damon   Offline
YaBB Newbies
*
Posts: 4
I Love MindFusion!


   
     
 
Re: Slow loading
Reply #5 - Mar 6th, 2014 at 12:22pm
 
thank you
 
 
 
IP Logged    
 
     
Page Index Toggle Pages: 1 Send Topic Print