Bug 116075 - EDITING: Unwanted dragging of sheets
Summary: EDITING: Unwanted dragging of sheets
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Sheet-Tabs-Bar
  Show dependency treegraph
Reported: 2018-02-28 00:14 UTC by Tom Stewart
Modified: 2019-05-18 09:52 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Unwanted dragging of pasted selection (26.82 KB, image/png)
2018-02-28 00:24 UTC, Tom Stewart
Unwanted dragging of sheets (25.59 KB, image/png)
2018-02-28 00:25 UTC, Tom Stewart

Note You need to log in before you can comment on or make changes to this bug.
Description Tom Stewart 2018-02-28 00:14:47 UTC
My OS is Ubuntu 17.10. When I try to navigate between sheets, it grabs and drags them along. I am not holding down on any button to drag them, but this happens anyway. Much worse: after it drags a sheet, it often deletes all of its contents!

Similarly, if I copy a selection of cells, and then paste them elsewhere, it won't let go of the pasted selection. It will keep dragging it around the sheet as if I am holding down on it.

Steps to Reproduce:
1. Open a file with >3 sheets, all with several columns. In each cell of each column, there are a few words of text.
2(a): Hover the cursor back and forth over the sheet names. Click on one sheet, then try to click on another.
2(b): Select and copy three cells in a row. Paste anywhere else. Try to click anywhere else in the sheet.

Actual Results:  
2(a): The user is not holding down any button, but the cursor grabs grabs the sheets, drags them along, and often then deletes their contents.
2(b): The pasted selection is dragged along, even though the user is not holding down any button.

Expected Results:
2(a): It should be possible to click on individual sheets, and then work on the selected sheet. It should be possible to hold down on a sheet and drag it left or right, and for this to be released when the user releases the hold-down button.
2(b): It should be possible to navigate away from pasted cells.

Reproducible: Sometimes

User Profile Reset: Yes

Additional Info:
This happens when I use my mouse, and also when I completely unplug the mouse and use the trackpad. This behaviour only happens within LibreOffice Calc, no other programme. This leads me to believe that the source of the problem is LibreOffice Calc, not my mouse/trackpad or my own behaviour.

This unwanted dragging has made the programme very difficult to use, and the deleting of contents has made me lose a lot of work.

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.186 Safari/537.36
Comment 1 Tom Stewart 2018-02-28 00:24:44 UTC
Created attachment 140201 [details]
Unwanted dragging of pasted selection
Comment 2 Tom Stewart 2018-02-28 00:25:25 UTC
Created attachment 140202 [details]
Unwanted dragging of sheets
Comment 3 Buovjaga 2018-03-08 20:19:34 UTC
I cannot reproduce. I also tried with gtk3.

Tom: you might try launching from the command line with
SAL_USE_VCLPLUGIN=gen libreoffice
and then try to bring about the problem.

Please also copy and paste here the contents of your Help - About. This allows us to know more about your system.

Change back to UNCONFIRMED after you have provided the information.

Arch Linux 64-bit
Build ID: b8fe96f1da2c42c04a8094ca8c57d49763b7bded
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on March 8th 2018
Comment 4 Tom Stewart 2018-03-11 16:00:45 UTC
The contents of my "Help - About". It is in language ga-IE:

Aitheantas an Leagain: 1:5.4.5-0ubuntu0.17.10.5
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; 
Locale: ga-IE (ga_IE.UTF-8); Calc: group
Comment 5 Buovjaga 2018-03-11 16:11:19 UTC
Thanks. The results of this would still be interesting to hear:

(In reply to Buovjaga from comment #3)
> Tom: you might try launching from the command line with
> SAL_USE_VCLPLUGIN=gen libreoffice
> and then try to bring about the problem.
Comment 6 Tom Stewart 2018-03-11 16:18:15 UTC
Hi Buovjaga,

Thanks for taking a look. I'm not very knowledgeable on using the command line, but I inputted the command you suggested. This is what it threw up:

javaldx: Could not find a Java Runtime Environment!
Please ensure that a JVM and the package libreoffice-java-common
is installed.
If it is already installed then try removing ~/.libreoffice/3/user/config/javasettings_Linux_*.xml
Warning: failed to read path from javaldx

However, it did launch LibreOffice Calc. Unfortunately, I couldn't reproduce the problem this way, or through the regular way I open Calc either. The problem occurs at random times, but when it does, it is quite destructive.

I will keep an eye on it, and the next time it occurs, if I can figure out a possible cause, I will post it here,

Comment 7 Buovjaga 2018-07-13 14:32:46 UTC
Modifying summary as the contents deletion was reported & confirmed now as bug 118302 (we take 1 issue per report anyway)
Comment 8 Xisco Faulí 2018-10-18 14:37:41 UTC
Hello Tom Stewart,
After bug 118302 got fixed, 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.
Comment 9 QA Administrators 2019-05-08 17:31:31 UTC Comment hidden (obsolete)
Comment 10 Tom Stewart 2019-05-18 08:40:42 UTC

Indeed, bug 118302 does seem to have resolved one of the problems listed here. I'm sorry for listing two issues here, but I thought they were related.

Then there is the problem of the dragging of cells after they have been pasted. This is my current version of LibreOffice:

Build ID: 1:6.0.7-0ubuntu0.18.04.5

(I don't want to jump through the hoops of installing 6.1 through the PPA because I already waste way too much time on stuff like this.)

I can't reproduce it, either via mouse or trackpad. Maybe it has been patched since I created this bug report. Since I can't reproduce, I will mark this as resolved for now.

Best regards,

Comment 11 Buovjaga 2019-05-18 09:52:09 UTC
(In reply to Tom Stewart from comment #10)
> (I don't want to jump through the hoops of installing 6.1 through the PPA
> because I already waste way too much time on stuff like this.)

If you want to save time in the future by avoiding hoop-jumping: https://libreoffice.soluzioniopen.com/