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. ***