The MindFusion Forums
Grid and Spreadsheet Components >> Windows Forms >> Slow loading
https://mindfusion.eu/Forum/YaBB.pl?num=1393512279

Message started by Damon on Feb 27th, 2014 at 2:44pm

Title: Slow loading
Post by Damon on 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

Title: Re: Slow loading
Post by Meppy on 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();[/code]
Let me know if this helps.

Regards,
Meppy

Title: Re: Slow loading
Post by Damon on Feb 28th, 2014 at 11:44am
This helped, thanks

Damon

Title: Re: Slow loading
Post by Damon on 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

Title: Re: Slow loading
Post by Meppy on 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:

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

Title: Re: Slow loading
Post by Damon on Mar 6th, 2014 at 12:22pm
thank you

The MindFusion Forums » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.