Bug 127151 - Calc lock mouse scrolling for whole opened LO applications and does not show current cell normal cursor when opening complex files
Summary: Calc lock mouse scrolling for whole opened LO applications and does not show ...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.0.4 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-08-25 16:32 UTC by Paolo
Modified: 2019-12-13 08:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Complex file that causes the bug (122.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-08-25 16:32 UTC, Paolo 		Details
localc sheet (12.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-09-18 08:00 UTC, peter 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Paolo 2019-08-25 16:32:06 UTC 
Created attachment 153642 [details]
Complex file that causes the bug

When I open a complex CALC file (with a lot of sheets and macros in it) the whole opened LO applications can't be scrolled using mouse wheel.
In my case I had opened 3 applications:
CALC (4 files opened, including the complex one)
WRITE (1 file opened)
BASIC IDE

Another thing that happens is that cell cursor is no more visible and cells selected range is not highlighted.
When the file is closed, everything goes back to normal.

My LO release is 6.3.0.4, running on Ubuntu 18.04, Build ID: 1:6.3.0-0ubuntu0.18.04.1~lo2

I attach the file that gives me the problem (with previous LO version there were no problems opening this file). Although complex, this file is relatively small (125,3 kB).
Comment 1 peter 2019-08-26 11:56:17 UTC 
Also here the same problem with calc sheets with checkboxes, choice boxes and so on.
Comment 2 peter 2019-09-18 08:00:29 UTC 
Created attachment 154247 [details]
localc sheet
Comment 3 peter 2019-09-18 08:05:30 UTC 
In Addition to my previous comment I notized that LoCalc creates a hight CPU load with such a file but only in the working mode. If I change in the draft mode (extras->forms->draft mode) all seems o.k. 
It is a problem with LO version 6.3.1 because with version 6.1 all works fine. I attached a file which create such problems.
Comment 4 Victor Campillo 2019-11-09 17:55:56 UTC 
I have the same problem with Libreoffice 6.3.3.2 in Xubuntu 18.04

When I open a complex Calc sheet the mouse scrolling does not work and I see a high CPU usage. The 99% of the Calc files I work on have many macros, buttons, editboxes, etc, so for me the scrolling does not work in any of my files.

Everything works fine in Libreoffice 6.2.8.2.
Comment 5 Victor Campillo 2019-11-11 05:29:18 UTC 
I just tested with Libreoffice 6.4.0.0.alpha1 and the problem is there too, scrolling does not work in complex files.
Comment 6 Xisco Faulí 2019-12-12 14:08:16 UTC 
I believe this is a duplicate of bug 121963.
Could you please try to reproduce it with the latest version of LibreOffice ( 6.3.4.2 ) 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
Comment 7 Paolo 2019-12-12 18:34:32 UTC 
I've tested the new version and all, now, works as expected.
So the bug, for me, is solved.
I mark it as solved (don't know if it is my task, but I did it).

Thank you.
Comment 8 Xisco Faulí 2019-12-13 08:12:50 UTC 
Thanks for retesting with the latest version.
Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.