Bug 46930 - [UI] moving rows or columns by Drag and Drop of Row / Column Headings should be possible
Summary: [UI] moving rows or columns by Drag and Drop of Row / Column Headings should ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 120043 156695 (view as bug list)
Depends on:
Blocks: Cell-Management
  Show dependency treegraph
 
Reported: 2012-03-03 05:19 UTC by Nicolas Mailhot
Modified: 2023-12-05 04:07 UTC (History)
6 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 Nicolas Mailhot 2012-03-03 05:19:44 UTC
calc forces the user to click on one of the column/line cells to move it after selection, when the natural thing would be to drag the column/line button used to select it
Comment 1 Rainer Bielefeld Retired 2012-03-03 07:23:40 UTC
Sounds plausible at first sight. But I doubt that that will be modified because drag and drop Heading "B" behind "C" would let user expect that new order would be ACBD...

@reporter:
is there and Spreadsheet program doing it the way you request? Gnumeric does not.
Comment 2 Nicolas Mailhot 2012-03-03 08:15:31 UTC
That's how excel works for example and excel users have no such expectation as you describe:

1. they want to move column/lines
2. everywhere else in the office suite you can move items by selecting them, keeping the mouse button pressed, and dragging somewhere else
3. the column/line selection point is its heading

So having to switch selection point to start dragging is completely unatural and non-obvious
Comment 3 Nicolas Mailhot 2012-03-03 08:20:39 UTC
See how confusing the current UI is there:
http://www.oooforum.org/forum/viewtopic.phtml?t=56667
Comment 4 m_a_riosv 2015-11-21 15:34:10 UTC
*** Bug 95964 has been marked as a duplicate of this bug. ***
Comment 5 Buovjaga 2018-10-23 13:15:51 UTC
*** Bug 120043 has been marked as a duplicate of this bug. ***
Comment 6 Stéphane Guillou (stragu) 2022-12-28 22:42:45 UTC
Not possible in OOo 3.3 either:
OpenOffice.org 3.3.0
OOO330m20(Build:9567)

It would conflict with the current behaviour of multi-row/column selection.
It could instead require pressing Alt to make it consistent with the existing Alt + drag-and-drop of a selection.
Comment 7 libreoffice.kovacsbv@spamgourmet.com 2023-04-14 17:51:32 UTC
The excel approach is highly efficient to the point that I switch over to Excel because it has this feature.  Shift-drag allows moving with one drag, Ctrl-drag allows copying, and Shift-Ctrl-drag allows copying an extra set and shifting cells at the same time.  This without moving from HOKAM (Hands On Keyboard And Mouse).  Dragging anywhere on the border is currently unimplemented so leaving the button as is and implementing on the border would not affect existing users/methods.

Anyone arguing against this feature should give it an honest try in Excel.  Excel should be the reference implementation.
Comment 8 Stéphane Guillou (stragu) 2023-08-10 08:23:40 UTC
*** Bug 156695 has been marked as a duplicate of this bug. ***