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. |