Bug 143235 - Calc drag and drop of rows or columns should be more user friendly
Summary: Calc drag and drop of rows or columns should be more user friendly
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.4.2 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Management Drag-and-Drop
  Show dependency treegraph
 
Reported: 2021-07-07 13:55 UTC by M-Rick
Modified: 2024-03-21 01:00 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Moving rows in Apple Numbers. (969.93 KB, image/png)
2021-07-07 13:56 UTC, M-Rick
Details
Trying to move a column pressing the alt key under MacOS (234.83 KB, image/png)
2021-08-04 12:51 UTC, M-Rick
Details
Trying to move a column pressing the alt key under MacOS (232.12 KB, image/png)
2021-08-04 12:52 UTC, M-Rick
Details
Moving the column with a single click (16.01 KB, image/png)
2023-02-04 18:48 UTC, M-Rick
Details
Drag-and-dropping rows and columns in Apple Numbers (468.12 KB, video/mp4)
2023-12-31 11:41 UTC, M-Rick
Details

Note You need to log in before you can comment on or make changes to this bug.
Description M-Rick 2021-07-07 13:55:27 UTC
Description:
LibreOffice should add drag-and-drop of rows or columns just like Apple Numbers or Quip do it. That's way more convenient than inserting then copying then pasting and finally removing the previous raws/columns.

Currently, to move a column or a row, it necessary co copy its whole content, then insert a new column or row, paste the content inside and delete the previous one.

By enabling drag-and-drop it would save time and bring things easier.
You click on the field and move it away. Several columns or rows should be movable together.

Actual Results:
Currently, to move a column or a row, it necessary co copy its whole content, then insert a new column or row, paste the content inside and delete the previous one.

Expected Results:
You click on the field and move it away. Several columns or rows should be movable together.


Reproducible: Always


User Profile Reset: No



Additional Info:
/
Comment 1 M-Rick 2021-07-07 13:56:05 UTC
Created attachment 173411 [details]
Moving rows in Apple Numbers.
Comment 2 Buovjaga 2021-07-19 17:40:13 UTC
Hold down Alt key while dragging after selecting the row or column
Comment 3 M-Rick 2021-07-19 18:34:21 UTC
It doesn't work for me. Tried with under MacOS X 10.14 and under Xubuntu 20.04 with both LibreOffice 7.1.4.
Comment 4 Buovjaga 2021-07-19 18:44:40 UTC
(In reply to M-Rick from comment #3)
> It doesn't work for me. Tried with under MacOS X 10.14 and under Xubuntu
> 20.04 with both LibreOffice 7.1.4.

Just to check, you need to click at the selection, not the row or column header.
Comment 5 M-Rick 2021-07-20 00:05:39 UTC
(In reply to Buovjaga from comment #4)
> (In reply to M-Rick from comment #3)
> > It doesn't work for me. Tried with under MacOS X 10.14 and under Xubuntu
> > 20.04 with both LibreOffice 7.1.4.
> 
> Just to check, you need to click at the selection, not the row or column
> header.

It duplicates de row or the column, it does't love it. You still have to erase the old one. Plus de cursor is not very convenient, just a small black square dot.
Comment 6 Buovjaga 2021-07-20 05:09:13 UTC
(In reply to M-Rick from comment #5)
> (In reply to Buovjaga from comment #4)
> > (In reply to M-Rick from comment #3)
> > > It doesn't work for me. Tried with under MacOS X 10.14 and under Xubuntu
> > > 20.04 with both LibreOffice 7.1.4.
> > 
> > Just to check, you need to click at the selection, not the row or column
> > header.
> 
> It duplicates de row or the column, it does't love it. You still have to
> erase the old one. Plus de cursor is not very convenient, just a small black
> square dot.

1. It does not duplicate
2. The cursor is not a small black square dot

So it seems you are not doing it the same way as me.
Comment 7 M-Rick 2021-08-04 12:49:40 UTC
I only press down the alt key and this this what I get.
It works under Linux, but not Macos.
Comment 8 M-Rick 2021-08-04 12:51:18 UTC
Created attachment 174070 [details]
Trying to move a column pressing the alt key under MacOS

Trying to move a column pressing the alt key under MacOS.
Comment 9 M-Rick 2021-08-04 12:52:07 UTC
Created attachment 174071 [details]
Trying to move a column pressing the alt key under MacOS

Trying to move a column pressing the alt key under MacOS.
The column has been duplicated instead of being moved.
Comment 10 M-Rick 2021-08-04 12:57:09 UTC
Comment on attachment 174070 [details]
Trying to move a column pressing the alt key under MacOS

The cursor becomes a small black square dot.
Comment 11 Buovjaga 2021-08-04 14:42:58 UTC
(In reply to M-Rick from comment #7)
> I only press down the alt key and this this what I get.
> It works under Linux, but not Macos.

Ok, so I guess your alt key is also the Option key, with ⌥ symbol.

Then we need a macOS tester
Comment 12 Denys Prokhorov 2021-08-05 08:15:52 UTC
I did not find similar functionality for Alt keys in OS X.

Option key ⌥ on OS X works like Alt + Ctrl and Alt + Ctrl + Shift on Win.

Additional Info:
Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 246f24ebc8227345f13784d9e2f055d813f3d24f
CPU threads: 12; OS: Mac OS X 10.15.7; UI render: default; VCL: osx
Locale: ru-RU (ru_UA.UTF-8); UI: en-US
Calc: threaded

Version: 7.1.5.2 / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 12; OS: Mac OS X 10.15.7; UI render: default; VCL: osx
Locale: ru-RU (ru_UA.UTF-8); UI: en-US
Calc: threaded
Comment 13 M-Rick 2023-02-04 18:48:05 UTC
I made a try under Windows, it's not a real drag-and-drop feature anyway.
First the cursor must be placed exactly on the border of the selected column. If you don't have a good view or working on a laptop with the trackpad, it's a nightmare to be done.
Then, once the column has been moved, the older one still remains in position. Only the datas are moved. So it needs anyway to remove the previous column at the end.

The expected behaviour is to click on the column header and move it to its new location just like on this screenshot, without any special additional pressed key, something simple and easy.
Comment 14 M-Rick 2023-02-04 18:48:51 UTC
Created attachment 185118 [details]
Moving the column with a single click
Comment 15 eisa01 2023-12-29 17:55:50 UTC
So I think what you're saying is that this should be more user friendly?

I tested a bit in macOS Excel and there's no easy way there either as far as I can tell

FYI: There's a separate bug 58440 on quite a bit of this functionality being broken/not as described in the help
Comment 16 M-Rick 2023-12-31 11:41:42 UTC
Created attachment 191667 [details]
Drag-and-dropping rows and columns in Apple Numbers
Comment 17 M-Rick 2023-12-31 11:42:00 UTC
(In reply to eisa01 from comment #15)
> So I think what you're saying is that this should be more user friendly?
> 
> I tested a bit in macOS Excel and there's no easy way there either as far as
> I can tell
> 
> FYI: There's a separate bug 58440 on quite a bit of this functionality being
> broken/not as described in the help

If you tried in macOS, Excel is not a quite good example in terms of ergonomic, like most of Microsoft softwares anyway.

Give a try with Numbers instead. If this can be done with LibreOffice, that's gonna be a feature killer.
Just like on this screenshot above.
https://bugs.documentfoundation.org/attachment.cgi?id=191667
https://bugs.documentfoundation.org/attachment.cgi?id=173411