Bug 153301

Summary:	Calc slows down when changing sheets only after saving
Product:	LibreOffice	Reporter:	Ademas <ademar.mlf>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	stephane.guillou, telesto
Priority:	medium
Version:	7.4.5.1 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	File with many comments and 2 sheets

Description Ademas 2023-02-01 09:25:37 UTC

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.

Comment 1 Stéphane Guillou (stragu) 2023-02-01 11:05:47 UTC

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

Comment 2 Ademas 2023-02-01 14:30:28 UTC

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

Comment 3 Ademas 2023-02-01 14:31:08 UTC

Created attachment 185049 [details]
File with many comments and 2 sheets

Comment 4 Ademas 2023-02-01 14:45:13 UTC

as a symptom of the large MEMORY USE* after saving. But it is a different facet of it

Comment 5 Ademas 2023-02-01 14:56:50 UTC

Also happens with gen VCL

Comment 6 Stéphane Guillou (stragu) 2023-02-01 15:01:51 UTC

(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.

Comment 7 Ademas 2023-02-01 15:11:50 UTC


*** This bug has been marked as a duplicate of bug 119075 ***

Comment 8 Ademas 2023-02-01 15:16:08 UTC


*** This bug has been marked as a duplicate of bug 123542 ***

Comment 9 Stéphane Guillou (stragu) 2024-06-03 07:15:58 UTC


*** This bug has been marked as a duplicate of bug 131675 ***