Bug 144612 - Calc is slow/lag when typing/inputing values in a cell in 7.2 for some users
Summary: Calc is slow/lag when typing/inputing values in a cell in 7.2 for some users
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.1.1 rc
Hardware: x86-64 (AMD64) All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf, regression
: 144926 146051 (view as bug list)
Depends on:
Blocks:
 
Reported: 2021-09-19 23:11 UTC by Vincent
Modified: 2023-03-19 00:13 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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)
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.