Hi,
Recently I started to try the fpSpreadsheet and encountered the speed problem, too. Finally I find the bottleneck of my application and figured out a solution for it. Although this topic is over 2 years old, I think it's still worthy to reply here for those who have the same issue.
As what wp explained, the visual component, WorksheetGrid, is notified of refreshment by the Workbook when the content changed. Sometimes my application may change a lot of cells in one procedure, and it causes lots of notification, too. That's why the application slows down so much, right? But actually, I just want to see the result of procedure, the visual changes/refreshment/update during operation is not needed.
I tried to use WorksheetGrid.Workbook.DisableNotifications at the beginning of the procedure and put WorksheetGrid.Workbook.EnableNotifications before procedure end, but I found that the WorksheetGrid hanged and didn't update anymore.
After many tests, I realized that the WorksheetGrid hanged because there was no furthur refresh notification after EnableNotifications. So, I modified my code and put the WorksheetGrid.Workbook.EnableNotifications before the last cell change. It works like a charm! Everything runs as good as what I want. The attachment is a small sample to show how much improvement it goes. I wish this tip could help somebody in similar situation.
BTW, is it possible to send the notification once in WorksheetGrid.Workbook.EnableNotifications? Thanks!
Best Regards,
ChenYuChih