Bug 88582 - Features for rows, add menu Line Shift Up | Down
Summary: Features for rows, add menu Line Shift Up | Down
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Shortcuts-Accelerators Cell-Management
  Show dependency treegraph
Reported: 2015-01-19 12:45 UTC by alivedsn
Modified: 2023-11-27 10:41 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description alivedsn 2015-01-19 12:45:37 UTC
It would be very helpful to add the following to the menu:

- Line Shift Up -- shift the current line (row) upper (exchange it with previous line)

- Line Shift Down -- shift the current line (row) lower (exchange it with next line)

As this feature is very needed and wanted (though it is absent in MS Excel, too), we also could add default buttons for this to the toolbar.

The similar feature for columns (shift left-right) is far less needed.

For now, I can simulate this only by Macro recording, that is far less convenient.
Comment 1 m_a_riosv 2015-01-19 23:27:27 UTC
Hi @alivedsn, thanks for reporting.

Maybe using the option in Menu/Edit/Paste-Special - Shift cells down, can help a bit.

In any case looks fine.
Comment 2 andréb 2015-02-26 18:15:28 UTC
That sounds like something that should be put in a macro.
- Insert blank line (up or down)
- copy line
- delete copied line
Such a macro could be put in the tool bar.
Comment 3 alivedsn 2015-02-27 08:46:13 UTC
Thanks andréb, m.a.riosv,
Endeed, I already implemented this with macros.

But, having it internally (and having a pre-registered shortcut), will make this option available for everyone as standard - I'm sure this is a very useful thing. Very few users are able to define a macro, and even less are aware they need this...
Comment 4 Stéphane Guillou (stragu) 2023-11-21 20:11:55 UTC
It's possible to do that by drag-and-dropping with the Alt key pressed, for both rows and columns.
See https://help.libreoffice.org/latest/en-US/text/scalc/guide/move_dragdrop.html
Along with the new command requested in bug 39936, I think your use case is covered. What do you think?
Comment 5 alivedsn 2023-11-27 08:14:54 UTC
Many thanks Stéphane,

Though I prefer the keyboard shortcuts, the dragging with the mouse is also a fine solution. So I guess this case is to be closed.
Comment 6 Stéphane Guillou (stragu) 2023-11-27 10:41:39 UTC
Thanks for the reply, alivedsn!
Marking as "not a bug", as "fixed" is for when something has been resolved by a code change.