Bug 144612

Summary:	Calc is slow/lag when typing/inputing values in a cell in 7.2 for some users
Product:	LibreOffice	Reporter:	Vincent <n0p>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	major	CC:	adrian.vidrascu, aron.budea, bugzilla-tdf, ilmari.lauhakangas, n0p, ravenkwill, suokunlong, troedel+bugs-libreoffice
Priority:	medium	Keywords:	perf, regression
Version:	7.2.1.1 rc
Hardware:	x86-64 (AMD64)
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=144205
Whiteboard:
Crash report or crash signature:		Regression By:

Description Vincent 2021-09-19 23:11:40 UTC

Description:
keyboard input in an empty cell is slow.

I start calc with a empty spread sheet. After navigating with arrows or mouse clicking on a cell, entering a value is slow.


Steps to Reproduce:
1. Start Calc with an empty spreadsheet 
2. Navigating to a cell with keyboard arrows or by mouse clicking 
3. Begin to type anything

Actual Results:
It lags for more than 10 seconds. Everything (LibreOffice menu+rendering of cells) become unresponsive.

Expected Results:
I'd like to input my stuff in less than 2 seconds.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
- On 7.1.7, strangely, I enter the first character, it lags for 2 to 3 seconds and I am able to input the rest. Afterwards, inputting other values is fast.

- On 7.2.0 or 7.2.1, at the first attempt to enter something, it lags for more than 10 seconds. Everything become unresponsive.
   -I've tried to disable Skia, HW acceleration and OpenCL since I've a rather old GPU (+10 years).

Comment 1 Vincent 2021-09-19 23:14:21 UTC

mitigation: stick with 7.1

Comment 2 Telesto 2021-09-20 07:17:00 UTC

No repro.. This sounds like a profile corruption. Instructions how to reset the user profile can be found here:
https://wiki.documentfoundation.org/UserProfile

Comment 3 Telesto 2021-09-25 00:42:04 UTC Comment hidden (obsolete)

Setting to NEEDINFO for time being. Please report back if the issue has been solved.

Comment 4 Buovjaga 2021-10-21 14:38:17 UTC

*** Bug 144926 has been marked as a duplicate of this bug. ***

Comment 5 Buovjaga 2021-10-21 14:43:09 UTC

NEW per dupe, which also had a Linux reproducer.

As this only happens to a minority of users, it is hard to figure out what to try.

You could try a daily build from https://dev-builds.libreoffice.org/daily/master/current.html
Windows users can grab Win-x86_64@tb77-TDF

Troedel: you could install debug symbols for LibreOffice: https://wiki.ubuntu.com/Debug%20Symbol%20Packages

Then, you could take a perf trace of the slow typing: https://wiki.documentfoundation.org/Development/How_to_debug#Performance_debugging_.28perf.29

Instead of FlameGraph, you can also open the perf.data file in https://github.com/KDAB/hotspot and export a nice SVG.

Comment 6 Timur 2021-10-22 18:50:31 UTC

*** Bug 145217 has been marked as a duplicate of this bug. ***

Comment 7 Kevin Suo 2021-11-14 13:27:33 UTC

I do not see a reason marking Bug 145217 as a duplicate of this one.  Bug 145217 is related to the slowness at the time of start up (i.e. loading with an New / Empty document), while this one is about the slowness when type in a cell. They are different aspects. Remove accordingly.

Comment 8 Neb 2022-01-23 21:31:35 UTC

I get exactly these symptoms with Win10 Pro and Calc v7.2.5 - new install, default settings, new user profile, all graphic output settings tested, safe mode tested. All tests done with a blank spreadsheet. Writer did not seem to be affected in any discernible way.

Like Vincent, I also have an AMD system, but it is not very old - Ryzen 4650G APU (onboard graphics). I have the newest chipset and CPU/APU drivers from my motherboard's manufacturer (Gigabyte) dated Nov 2021. 

I also had to roll back to v7.1.8.1 in order to use Calc.

Sorry, I'm just an end user. I can't really test anything for you.

Comment 9 Kevin Suo 2022-01-24 01:03:41 UTC

(In reply to Neb from comment #8)
This had been reported to be reproducible on both linux and windows. Please do not change the OS field to be win only.

Comment 10 Timur 2022-02-01 15:28:48 UTC

*** Bug 146051 has been marked as a duplicate of this bug. ***

Comment 11 Timur 2022-03-17 12:18:21 UTC

This will stay like this until reproduced or bibisected (Comment 5). 
Aprat from that, test with master 7.4+ would be good to know if it's still a problem: https://dev-builds.libreoffice.org/daily/master/current.html

Comment 12 Vincent 2022-03-19 02:12:30 UTC

Thanks, Timur, for the follow-up!

I've tested the latest nightly 2022-03-17 04:39:14 as you suggested, and it worked like a charm. There is no longer lag of 10 seconds on empty spreadsheet.