Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
90
UI freeze during copy/paste operation inside spreadsheet
posted

Hello.
I have met one very strange case, during working with UltraSpreadsheet. There is an Excel file, which, when loaded in the control, cause freezes on copy or paste. (At the moment, I have only single example of such an Excel, and I can't reproduce freezes with any other file, even if I copy full context to it.)

TD_CopyPaste_copy.xlsx


The freeze is not so big, but still kind of noticeable. It can become more noticeable if you quickly press Ctrl-C for a couple of times in a row.
I understand that this is not a common use case, but still, I guess it might hide some problem under the hood.

To reproduce the defect, following scenario might be used:
1) load attached Excel into UltraSpreadsheet control;
2) Select any cell or region
3) Quickly press Ctrl-C for 5 times in a row
 => UI tread is blocked for 2-5 seconds
 
 I made a quick trace of the scenario and found out that the major time is spend in Workbook.Save() method, which serialize different parts of the document.


 Can you, please, fix that, or, at least, tell me what is so special about this particular Excel document to cause such kind of behavior?

Parents Reply Children