CALC: can't drag&drop a single cell in the same sheet

[Omar_ElMalo]

Binary package hint: openoffice.org

if a single cell is selected, it's not possible to drag it and drop it in another position of the same sheet
-----
ubuntu 7.04
oo 2.2.0

[Dead (deadpda)]

This is a fairly important problem, as it is one of the coomn tasks performed in this app by real users.

[Tom (tom6)]

I have been using CtrlX, CtrlV but it's not always convenient. I think Excel users will miss this feature severely
Regards from
Tom )

[Bruce Dunn (brucedunn)]

Open Office Calc has a "feature" that it doesn't treat single cells like multiple cells when dragging and dropping. If I remember correctly, this has been a point of contention in Calc design for years, as it doesn't behave the way that people expect (ie. the way that Excel does it). It has been brought up as a bug in the Open Office forums, and the response has sort of been "we are not going to fix it - that is the way that it was designed to work"

In order to drag and drop, the cell or cells have to be highlighted first. If you are trying to highlight several adjacent cells, just drag the pointer over them and they change background color to indicate that they have been highlighted. Then, use the mouse to drag and drop the highlighted cells in the normal way.

If you are trying to drag and drop a single cell, this doesn't work. Clicking on a single cell doesn't highlight it. In order to get the needed highlight do one of two things:

1) Hold down the CTRL key, and click on the single cell

OR

2) Click on the single cell, and while holding move the mouse cursor into any adjacent cell - this highlights the two cells. Then, without letting go of the mouse button, change your mind and move the pointer back into the original cell. The highlighted area retreats from two cells to the single cell that you wanted to highlight in the first place. Then, go ahead with the drag and drop. I think of this as the "Calc Wiggle".

I would love for someone to write a patch for Calc so that individual users can make it behave the way that Excel does.

[Tom (tom6)]

Hi Bruce :)

Thanks for the tip about doing the "Calc Wiggle". I doubt i would remember the Ctrl route as it seems a bit quirky but it is good to know too, thx

Thanks and regards from
Tom :)

[penalvch (penalvch)]

Omar_ElMalo, not having the ability to drag and drop a single cell as desired is keeping with Excel behavior expectations. Hence, this is a Wishlist. Marking as such.

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

[Björn Michaelsen (bjoern-michaelsen)]

This is:
- a clearcut upstream issue
- wishlist/feature request unlikely to be fixable with a simple patch
- wont be fixed in libreoffice packaging
Resolving as WONTFIX in libreoffice packaging. This does not mean the issue will not be cared about, but if it is cared about (even by Ubuntu/Canonical contributors), it is done upstream at LibreOffice.

Libreoffice (Ubuntu) => WONTFIX

Please file a upstream bug against Libreoffice: http://wiki.documentfoundation.org/BugReport

Libreoffice => Incomplete (missing upstream bug URL)

[Tom (tom6)]

Hi :)
I think there is already a bug-report up-stream at LibreOffice. Here is a guide to help you search through or file a decent a report about it.
http://wiki.documentfoundation.org/BugReport
It would be great if anyone does get time to look through if they could link from here to there and vice versa so that people can see what is going on easily.
regards from
Tom :)