Description: Whenever I start working on my spreadsheet everything is fine and fast, but as soon as I save the file once, or the file autosaves, the time to change between sheets increases drastically. From instant, it takes a few seconds, which really disrupts the workflow. Sequential saves dont seem to further increase this delay. FILESAVE Steps to Reproduce: 1.Open an ods file with at least 2 sheets with a lot of data 2.Swap between the 2 sheets a few times to get a feeling of the time it takes to swap 2.Make any small change to the document 3.Save it manually (Or wait for autosave if it is enabled) 4.Swap between the 2 sheets a few times to notice a substantial increase in the time to swap Actual Results: Substantial increase in the time to swap between sheets Expected Results: 1.Open an ods file with at least 2 sheets with a lot of data 2.Swap between the 2 sheets a few times to get a feeling of the time it takes to swap 2.Make any small change to the document 3.Save it manually (Or wait for autosave if it is enabled) 4.Swap between the 2 sheets a few times and notice no difference from the time before saving Reproducible: Always User Profile Reset: No Additional Info: I am using a 4.1MB spreadsheet with several sheets, some sheets have thousands or dozens of thousands of lines and dozens of columns, no images, only hyperlinks. But mostly with sparse data and lots of stylization and formatting for cells. I use it on Linux Mint 20.3, Cinnamon 5.2.7 I believe I didnt experience this delay in 6.2. But on version 7.2 this bug is also present. In previous versions I experienced general delays after saving, but now with 7.4.5.1 I only experience this when swapping sheets.
Thanks, Ademas. - Do you have many comments in the file? See potential duplicates bug 119075 and bug 123542 - Please attach an example file if possible, for us to test - Please paste here the full version information from Help > About LibreOffice
I do have many comments in the file! I am sending an attachment. It seems to be connected to Bug 123542 as a symptom of the large file size after saving. But it is a different facet of it. I used to have Bug 119075 in older versions, but not on this one. Version: 7.4.5.1 / LibreOffice Community Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f CPU threads: 12; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Created attachment 185049 [details] File with many comments and 2 sheets
as a symptom of the large MEMORY USE* after saving. But it is a different facet of it
Also happens with gen VCL
(In reply to Ademas from comment #2) > I used to have Bug 119075 in older versions, but not on this one. It looks like bug 119075 started as a scrolling bug and then morphed into the sheet-switching bug it is now around 2018. The performance trace there is related to the sheet-switching, and given how similar your issue is (document with many comments, starts after saving, slow switching of sheets, sheet-switching issue appeared around the same version), I think it should be marked as a duplicate. Don't you agree, seeing the last few comments there? Reproduced with your example document with: Version: 7.4.5.1 / LibreOffice Community Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded and: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 9740331d8bc56a9b6fbe3e4c1b26fb97f6639cc6 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Opening document is slow, saving is slow, after saving: memory and CPU usage increase and stay high, switching sheets is slow.
*** This bug has been marked as a duplicate of bug 119075 ***
*** This bug has been marked as a duplicate of bug 123542 ***