Description: If a document is on the larger side and takes a while to save, then saving dramatically slows down the insertion and deletion of rows (we are talking about a hundred times slower on my main doc, and I couldn't find a way to speed it up again without restarting the program) In this example, I opened a new calc doc, wrote random data in the first 26x26 range using a macro, put background colors and borders on random cells and copied that sheet 19 times for a total of 20 sheets. The deletion and insertion remained quick, however, if I save the document (even without changing any data at all) both the deletion and insertion becomes awfully slow. Steps to Reproduce: 1. Open Document 2. Run the deletion or insertion functions 3. Note the speed (should be fast) 4. Save Document (you can even undo the changes before saving) 5. Run the deletion or insertion functions again 6. Note the difference in speed Actual Results: Both Insertion and Deletion of rows becomes slow Expected Results: Insertion and Deletion should have kept their original speed Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2 CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: CL threaded
Created attachment 195114 [details] Demo file
*** This bug has been marked as a duplicate of bug 125619 ***
@Telesto, While I was not able to reproduce the problem described in comment 0, I also don't see the reason to claim that tdf#161900 is a dupe of bug 125619. Attachment 195114 [details] in comment 1 in this tdf#161900 has no comments (notes) in it, whereas tdf#125619 is directly focused on files with (many) comments (notes).
(In reply to ady from comment #3) > @Telesto, > > While I was not able to reproduce the problem described in comment 0, I also > don't see the reason to claim that tdf#161900 is a dupe of bug 125619. > > Attachment 195114 [details] in comment 1 in this tdf#161900 has no comments > (notes) in it, whereas tdf#125619 is directly focused on files with (many) > comments (notes). I mistakenly took hidden text indicator for comment... argh
No problem for me. Any change if you deactivate Tools - Options - LibreOffice - View - Use Skia for all rendering? Version: 24.8.0.3 (X86_64) / LibreOffice Community Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583 CPU threads: 2; OS: Windows 11 X86_64 (10.0 build 22621); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
(In reply to Buovjaga from comment #5) > No problem for me. Any change if you deactivate Tools - Options - > LibreOffice - View - Use Skia for all rendering? > > Version: 24.8.0.3 (X86_64) / LibreOffice Community > Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583 > CPU threads: 2; OS: Windows 11 X86_64 (10.0 build 22621); UI render: > Skia/Raster; VCL: win > Locale: en-US (en_US); UI: en-US > Calc: threaded I deactivated Skia rendering and the bug persisted. I also tested it on a different windows pc and was able to reproduce it. How many ticks did it take for you to run the subroutines before and after? For me, it takes around 10 ticks pre-saving and around 200 after.
(In reply to KosulinLeonidas from comment #6) > (In reply to Buovjaga from comment #5) > > No problem for me. Any change if you deactivate Tools - Options - > > LibreOffice - View - Use Skia for all rendering? > > > > Version: 24.8.0.3 (X86_64) / LibreOffice Community > > Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583 > > CPU threads: 2; OS: Windows 11 X86_64 (10.0 build 22621); UI render: > > Skia/Raster; VCL: win > > Locale: en-US (en_US); UI: en-US > > Calc: threaded > > I deactivated Skia rendering and the bug persisted. I also tested it on a > different windows pc and was able to reproduce it. > > How many ticks did it take for you to run the subroutines before and after? > For me, it takes around 10 ticks pre-saving and around 200 after. What do you mean by "ticks" and "subroutines"?
(In reply to Buovjaga from comment #7) > (In reply to KosulinLeonidas from comment #6) > > (In reply to Buovjaga from comment #5) > > > No problem for me. Any change if you deactivate Tools - Options - > > > LibreOffice - View - Use Skia for all rendering? > > > > > > Version: 24.8.0.3 (X86_64) / LibreOffice Community > > > Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583 > > > CPU threads: 2; OS: Windows 11 X86_64 (10.0 build 22621); UI render: > > > Skia/Raster; VCL: win > > > Locale: en-US (en_US); UI: en-US > > > Calc: threaded > > > > I deactivated Skia rendering and the bug persisted. I also tested it on a > > different windows pc and was able to reproduce it. > > > > How many ticks did it take for you to run the subroutines before and after? > > For me, it takes around 10 ticks pre-saving and around 200 after. > > What do you mean by "ticks" and "subroutines"? 1. Open the document 2. Go to tools-> Macros-> Edit Macros 3. Select either the "DeletionTest" or the "InsertionTest" Subroutines (DeletionTimeDemo.ods -> Standard -> Module1) 4. Run it 5. Note the "before" Result (A msgbox is supposed to pop up that tells you how many ticks it took for the subroutine/function to finish running) 6.save the document (Ctrl+S) 7. Run the Subroutines again 8. Note the "after" Result
Thanks, with the clearer steps I was able to reproduce. I had thought manual insertion and deletion would be enough. Bibisected changes with linux-64-7.4. There was about a 10x increase in the ticks with 4c5f8ccf0a2320432b8fe91add1dcadf54d9fd58, which changed the default number of Calc columns to 16384 The current state was introduced with 2e86718626a07e1656661df3ad69a64848bf4614 don't allocate unnecessary columns when inserting a row I will not call this a regression as the change is related to the bigger number of supported columns.