Reordering rows/columns in spreadsheet

This thread is for discussion about workflows for reordering rows and columns in Collabora spreadsheets, since it is currently more difficult to do it than in many other spreadsheet programs. For example, there is no way to drag-and-drop rows/columns, nor are there options for “move rows/columns in direction”.

GitHub thread Use also Ctrl or Alt when dragging rows, columns, cells · Issue #8033 · CollaboraOnline/online · GitHub tracks the enhancement request for being able to reorder rows and columns by drag-and-drop. This forum discussion may be helpful for users who want to emulate such functionality, or discuss workarounds.

A very useful workaround was mentioned Use also Ctrl or Alt when dragging rows, columns, cells · Issue #8033 · CollaboraOnline/online · GitHub copy the row(s)/column(s) to the clipboard, and then use the “paste special” feature, which has an option in the dialog box to shift rows/columns out of the way instead of overwriting them. This is still unwieldy but is a lot better than the alternatives that currently exist.

1 Like

For anyone who is wondering about use cases, there are plenty… For example, I maintain a spreadsheet of recurring monthly expenses. I keep the rows in an order that makes sense to me for reviewing easily, which means sometimes they have to be reordered when expense categories are added, removed, or changed. It’s also popular to work on puzzle hunts (Introduction to Puzzlehunts) using spreadsheets, in which case it is very helpful to be able to quickly move data from one place to another within the spreadsheet, to see if it produces novel insights.

Sometimes one wants to keep rows in a mostly sorted order, and it is possible to work around the lack of easy reordering functionality by simply sorting repeatedly. It is less convenient than drag-and-drop when there is only one row that needs to be moved, and fails when there is not an existing column that one wants to strictly sort by.

1 Like