Description: Slow response in the Formula Bar Steps to Reproduce: 1.Open a new spreadsheet. Cell A1 is selected. 2.Move the mouse pointer to the Formula Bar and immediately left click the mouse. Actual Results: There is up to 1 second delay before the cursor appears. Expected Results: The cursor immediately appears in the Formula Bar ready for entry of the formula (as in version 6.0.7). Reproducible: Always User Profile Reset: Yes Additional Info: 1. Select another cell and repeat. The same thing happens. 2. If the pointer is hovered over the formula bar for 1 second before clicking the mouse, the cursor appears immediately.
Not reproducible for me with LO 6.2.3.0.0+ under Ubuntu 18.04 x86-64. Perhaps there is some configuration settings to tweak how the change of the focus is managed by your OS. Best regards. JBF
Thank you for reporting the bug. I can not reproduce the bug in Version: 6.2.1.2 (x64) Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71 CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: CL Version: 6.3.0.0.alpha0+ (x64) Build ID: 91cdf22b88a4f7bec243c8fb187627e766d3294c CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-03-08_00:38:10 Locale: en-US (en_US); UI-Language: en-US Calc: CL
Could you please paste the info from Help - about LibreOffice ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the information has been provided
Created attachment 150382 [details] FlashBack recording Version: 6.2.1.2 (x64) Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71 CPU threads: 12; OS: Windows 10.0; UI render: default; VCL: win; Locale: en-GB (en_GB); UI-Language: en-GB Calc: threaded FlashBack recording attached showing the slow Formula Bar when a) Calc is first opened, b) after a new cell is selected and c) after hovering in the Formula Bar for 1 second.
(In reply to stepmotor from comment #4) > Created attachment 150382 [details] > FlashBack recording > > Version: 6.2.1.2 (x64) > Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71 > CPU threads: 12; OS: Windows 10.0; UI render: default; VCL: win; > Locale: en-GB (en_GB); UI-Language: en-GB > Calc: threaded > > FlashBack recording attached showing the slow Formula Bar when a) Calc is > first opened, b) after a new cell is selected and c) after hovering in the > Formula Bar for 1 second. The flashback recording is of no use as it is in some weird proprietary format. Next time you can encode them in some normal format and use .webm as the container. You can use a software such as https://obsproject.com/download I cannot repro with 6.2.2 on Win 10. You said you reset the user profile. If that is really so, I guess the problem is still seen in safe mode? In LibreOffice, Help - Restart in safe mode and then Continue in safe mode.
I've just found that the problem goes away if I uninstall the offline helppack. Version 6.0.7 has no delay with the helppack installed. Hence the helppack after v6.0.7, or LibreOffice's interaction with the helppack causes the performance hit.
I have offline help installed and do not see the problem. I even tried activating Tools - Options - LibO - General - Extended tips, but it still worked. Version: 6.2.3.2 (x64) Build ID: aecc05fe267cc68dde00352a451aa867b3b546ac CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: fi-FI (fi_FI); UI-Language: en-US Calc: threaded
Version: 6.2.3.2 (x64) Build ID: aecc05fe267cc68dde00352a451aa867b3b546ac CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: en-GB (en_GB); UI-Language: en-GB Calc: CL I have setup a second PC with Windows 7 and a clean install of Windows 10. I get the slow formula bar issue with Windows 10, but not with Windows 7. Both my PCs have AMD processors (Ryzen 5 & A8).
(In reply to stepmotor from comment #8) > Version: 6.2.3.2 (x64) > Build ID: aecc05fe267cc68dde00352a451aa867b3b546ac > CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; > Locale: en-GB (en_GB); UI-Language: en-GB > Calc: CL > > I have setup a second PC with Windows 7 and a clean install of Windows 10. > I get the slow formula bar issue with Windows 10, but not with Windows 7. > > Both my PCs have AMD processors (Ryzen 5 & A8). What if you go to Tools - Options - LibreOffice - OpenCL and uncheck the box?
No change when OpenCL is unchecked.
Created attachment 152461 [details] Normal reaction speed, arrow key movement + F2 edit.
Created attachment 152462 [details] Mouse movement reaction speed - slight lag.
Created attachment 152463 [details] Arrow key + f2 movement whilst the mouse is fidgeting around the formula bar - lags the entire program heavily.
Created attachment 152464 [details] Arrow keys + f2 whilst mouse is moving outside the formula bar - normal speed.
I've been experiencing the same issue since upgrading to the latest stable version the other day (from ~6.0.1 or 3). Curiously, I have the same en-GB locale + ui as the reporter. Version: 6.1.6.3 (x64) Build ID: 5896ab1714085361c45cf540f76f60673dd96a72 CPU threads: 4; OS: Windows 6.1; UI render: default; Locale: en-GB (he_IL); Calc: CL Would like to point out that this specifically occurs when using the mouse - arrow keys and F2 react in a timely manner. It seems as though specifically a move of the mouse anywhere within the vicinity of the formula bar triggers the lag. I've added some gifs to illustrate the observed behaviour.
Yep, Locale: en-GB is curious. symbioma.trix: the problem went away for the original reporter, if they uninstalled the local help. Do you have help installed?
Not that I'm aware. """ The LibreOffice built-in help for current UI language (English (UK)) is not installed on your computer. """
Anything else you'd like to try out or extract?
(In reply to symbioma.trix from comment #18) > Anything else you'd like to try out or extract? I think the ball is now in my court, I would have to experiment with en-GB locale
In v6.2.4 the problem is almost reversed: With helppack installed, the problem completely goes away. With helppack not installed, the mouse response lag remains. Version: 6.2.4.2 (x64) Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64 CPU threads: 12; OS: Windows 10.0; UI render: default; VCL: win; Locale: en-GB (en_GB); UI-Language: en-GB Calc: threaded I've installed and de-installed the helppack several times, and the outcome is consistent for populated and unpopulated spreadsheets. I confirm that using the arrow keys and F2 edit gives normal reaction speed.
A new major release of LibreOffice is available since this bug was reported. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
The lag problem has been fixed in v6.3.4. Prior to v6.2.4 I have installed the default helppack, which is the English US version. I have revisited the issue by installing previous LO versions with their helppacks. I found in all cases that the lag problem occurs when the en-US helppack is installed, but not when the en-UK helppack is installed. In v6.3.4 there is no lag problem with either helppack. Version: 6.3.4.2 (x64) Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa CPU threads: 12; OS: Windows 10.0; UI render: default; VCL: win; Locale: en-GB (en_GB); UI-Language: en-GB Calc: threaded
Wonderful, let's close