https://bugs.documentfoundation.org/show_bug.cgi?id=160286
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |perf --- Comment #7 from ady <[email protected]> --- I tested attachment 193784 on Windows (different OS and Hardware than comment 0) with several versions of LO Calc, starting from LO 7.3 up to a recent (but not the very latest) 24.8 alpha. With each newer version, it takes longer and longer time to open the file. STR (with each LO version): 1. Open attachment 193784. Take note of the time it takes to open. 2. Save as a new name_version (with the same xls file type). 3. Close the original file. 4. Open the newly created file. Take note of the time it takes to open. 5. Select all worksheets. 6. Select all cells. 7. Clear Direct Formatting (on Windows, [CTRL]+[M], or use the icon on the toolbar). 7.1. (Optional) Unselect worksheets. 8. Save and close the file. 9. Open the file saved in step 8. Note that now the time to open the file is much shorter than in step 4, whichever version of LO Calc is being used. I have also tested other properties in the original file (e.g. un-splitting each worksheet), but deleting the direct formatting has the most impact (of the properties I tested). Conclusions: * Newer versions are taking more time than older versions of Calc on the same xls file. * Something in the direct formatting is causing some delay on this XLS file. Whether there is some formatting attribute that was not supported before, IDK. Note: * I have not tested saving with other file formats. * In recent days, there have been some new commits aimed at improving XLS performance. This procedure might need to be re-tested in a few days (or weeks) with a newer LO 24.8 alpha in order to see whether the original delays are still reproduced. -- You are receiving this mail because: You are the assignee for the bug.
