Can you keep a sort on a column for a table?

[Lorraine Horine]

Using the up/down arrows to sort on a column but the sort won't "keep" - any suggestions? 

[Deleted user]

It's nuts that saving a sorted table requires a paid add-in, how is this not a normal table setting?

[Andrey Khaneev _StiltSoft_]

Hi Lorraine,

Table Filter macro can do the trick.  There are two approaches:

1. You can sort the table wrapped with Table Filter macro in page edit mode by Ctrl+Click on table heading. After you save the page, the applied sorting order will be saved. But each time you add new rows to the table you'll need to resort the table again.
2. Or you can set default sorting order in the Table Filter macro. In this case you will always see correctly sorted table.

[Thomas Bowskill]

@Lorraine Horine I literally just purchased this macro for the exact same reasons. The Table Filter macro works a charm for us -- one of the biggest gripes people had with Confluence tables was the sorting in both view and edit modes. Table Filter makes it easier to do this -- you can only sort by one column, but it is miles better than the lack of sorting present by default.

Plus there are plenty of other neat features like being able to add filters onto the table in view mode and export in PDF.

[Andrey Khaneev _StiltSoft_]

Tip: hold SHIFT button while clicking table headings to sort by multiple columns.

[Thomas Bowskill]

@Andrey Khaneev _StiltSoft_ many thanks -- this will help a lot :)

[John Taber]

Thanks for this post.  The Table Filter macro is great.  :)

[Øyvind Berget]

This isn't a plugin, this is a lack of feature from Atlassian. To have add ins for these kind of things is just bad programming.

[James Housley]

It's a bit hacky, but you can sort the table how you want in view-mode, copy the rows, then edit the page and paste them into the table. Saving this will set the table's default sort.

[Christian Rumswinkel]

Worked for me. Thanks @James Housley !

[weweave UG]

We would like to let you know that we developed the app "DataTables for Confluence" (see https://marketplace.atlassian.com/apps/1220302/datatables-for-confluence) for Confluence Cloud which supports table state saving, i.e. filtering, paging and sorting is automatically restored when the user reloads the page. The app also supports filtering tables by multiple columns (see https://weweave.net/blog/datatables-for-confluence-supports-multi-column-table-sorting/).