Bug 38994 - EDITING: improve single cell selection for Drag and Drop (by click on cell border?)
Summary: EDITING: improve single cell selection for Drag and Drop (by click on cell bo...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: high enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 54824 67985 74394 115114 122831 (view as bug list)
Depends on:
Blocks: Calc-Enhancements Cell-Selection
  Show dependency treegraph
 
Reported: 2011-07-06 00:41 UTC by gawkla
Modified: 2019-01-20 23:24 UTC (History)
10 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 gawkla 2011-07-06 00:41:48 UTC
Hi
I have problem identically like described here: (LO 3.4.1)
http://www.oooforum.org/forum/viewtopic.phtml?t=33714

LO behavior and solution is exactly the same as described in link.

[qote]
This is a strange problem. I just started to use Calc (v2.0, EN language). When I click on a cell to select it, the border becomes darker to show where the focus is. So far, so good.
But if I want to move that cell, I try to click and drag on the cell border and nothing happen. It seems like I can not move a single cell. I can move a group of cell tough.

So is it a normal (sic!) feature or my computer has a bug?

....
sloution:


It's strange. Hold the mouse key down, drag it over another cell, then drag back to the single cell and it becomes draggable (if that's a word). Help mentions this and some other method but I cannot find it now. Ok, found it now under, believe it or not, "Selecting Multiple Cells":
Comment 1 Jeffrey 2011-07-07 19:58:57 UTC
Reproduced on LibreOffice 3.4  340m1(Build:12) on OpenSuse Linux. 

I managed the work-around the same way you described:
1) Clicking on the cell to give it a black border.
2) Clicking on the cell again and dragging the blue background to another cell.
3) Hold the click and drag back to the single cell.

Maybe this workaround was the original intention LO's cell dragging design. But it would be a nice minor enhancement if included.
Comment 2 Arno Teigseth 2011-08-15 04:31:06 UTC
This is a very counter-intuitive behaviour.

My cow-orker, who's my Libreoffice test subject, complains very much on this lack of logic:

1) I select multiple cells, and can grab the border to move them around

2) I select one cell, and cannot grab the border to move it around.

I too think it would be more logical if the cell could be moved around when it's got focus (by dragging the border)

our 4 cents.
Comment 3 Rainer Bielefeld Retired 2011-12-21 22:35:19 UTC
EXCEL offers the possibility requested in original report:

Moving mouse pointer to the border of a cell with cell cursor, the mouse pointer view changes to "move" mode (arrow cross up-right-down-left), and drag + drop for that cell will become possible.
                             
@Kohei:
Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
Comment 4 ndw 2012-02-02 19:51:19 UTC
Interestingly on my mac if I select multiple cells or use Jeffreys workaround to select a single cell, I don't need to select the border to drag it - anywhere in the selected cells works. This is different in excel but I think is less counter-intuitive: I don't need to click on some small handle or the border around an icon to drag it around on my desktop, for example.
Comment 5 Kohei Yoshida 2012-02-02 19:57:09 UTC
Known issue, dating back to 2000 in OOo time.
Comment 6 gawkla 2013-01-26 21:38:51 UTC
Known? maybe, I am not sure but very probably this "feature" works different some time ago. Maybe you have right.

Any chance to fix this?
Comment 7 Jens 2013-11-13 12:58:04 UTC
I just found out that I have to mark the cell and then:
1. with mouse button still pressed move cursor to a neighbor cell and then move back again
2. this unlocks the cell and now it is possible to move or copy the cell just like in Excel
It is very time consuming for moving many individual cells.

Why not use the same method as in Excel?
Comment 8 dg1727 2014-12-01 12:38:39 UTC
*** Bug 74394 has been marked as a duplicate of this bug. ***
Comment 9 Roeland 2016-08-28 19:10:34 UTC
*** Bug 67985 has been marked as a duplicate of this bug. ***
Comment 10 Thomas Lendo 2016-11-11 10:47:56 UTC
Jens, as far as I know from an old OOo bug, there are (or were?) patent issues that prevent other products to implement this like Excel does.
Comment 11 Thomas Lendo 2017-09-02 21:38:41 UTC
*** Bug 54824 has been marked as a duplicate of this bug. ***
Comment 12 Thomas Lendo 2018-01-22 19:22:18 UTC
*** Bug 115114 has been marked as a duplicate of this bug. ***
Comment 13 m.a.riosv 2019-01-20 23:24:09 UTC
*** Bug 122831 has been marked as a duplicate of this bug. ***