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.
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.
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.
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...
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?
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.
Thanks for the reply, alivedsn! Marking as "not a bug", as "fixed" is for when something has been resolved by a code change.