I have problem identically like described here: (LO 3.4.1)
LO behavior and solution is exactly the same as described in link.
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?
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":
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.
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.
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.
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.
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.
Known issue, dating back to 2000 in OOo time.
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?
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?
*** Bug 74394 has been marked as a duplicate of this bug. ***
*** Bug 67985 has been marked as a duplicate of this bug. ***
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.
*** Bug 54824 has been marked as a duplicate of this bug. ***
*** Bug 115114 has been marked as a duplicate of this bug. ***
*** Bug 122831 has been marked as a duplicate of this bug. ***
Changing priority back to 'medium' since the number of duplicates is lower than 5
The solution in Comment 7 works but it is not the most convenient way to do it to say the least. It is time consuming and intuitive. People who switch from excel must look for a way to do this on internet. I am not saying that everything should be similar to Excel but this is such a basic functionality that should really deserve attention of LO developers.
OnlyOffice, MS Office, WPS Office have it much better. When mouse is near the cell edge an icon of something like cross appears and user knows he can just click and drug. Just like this:
Please, do it in LibreOffice the same way.
I do a lot of drug and drop and this made me install WPS just for this task.
I can't wait to have it in LO.
Please put it on your priority list for Calc.