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.
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.
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.
User Profile Reset: Yes
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
Created attachment 140201 [details]
Unwanted dragging of pasted selection
Created attachment 140202 [details]
Unwanted dragging of sheets
I cannot reproduce. I also tried with gtk3.
Tom: you might try launching from the command line with
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.
Set to NEEDINFO.
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
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
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.
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
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,
Modifying summary as the contents deletion was reported & confirmed now as bug 118302 (we take 1 issue per report anyway)
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.
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.
For more information about our NEEDINFO policy please read the
wiki located here:
If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
Thank you for helping us make LibreOffice even better for everyone!
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.
(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/