Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,368,495
Community Members
 
Community Events
168
Community Groups

Is there a way of sorting a table in edit mode in Confluence?

I need to be able to sort tables in edit mode so that for large tables I can do reconciliation tasks. Anyone know if this is possible and how?

2 answers

Hi Andrew,

Yes, it is possible in Confluence Server: you need to wrap the table with Table Filter macro. Then the table can be sorted in the editor using Ctrl+Click.

What is the option for Confluence Cloud? I have the Table Filter macro but this functionality is not available in Cloud yet. Preferably, would want to edit the filtered table in view mode but that option is also not available for Cloud.

Like # people like this

Table Filter macro is available in Confluence Cloud, but it is not integrated with page editor, so there is no way to sort and filter table in edit mode.

Any plans to add it to Cloud soon?

Unfortunately, there are no technical possibilities to implement this feature in Cloud environment: it is just impossible to integrate with the editor there.

Sorry to hear that!! :(

Thanks so much for your quick responses!

You are welcome, Debora! I'll reply here if something changes in the future.

Like Oz Edri likes this

From above it sounds like not possible to filter a table while in Edit mode.   At Merck we have confluence internal  (Not cloud?)  (I believe)  Since we call confluence as:  https://share.merck.com/Display

Is there way to configure filter so it displays in Edit mode?    This is key benefit over using Excel when (even) a medium # of rows need maintenance.   Filtering and editing go hand in hand for most use cases. 

Yes, it is possible to filter and sort tables in edit mode (documentation). 

Like # people like this

Andrew,

So there is no way to achieve this functionality in the Cloud instance?  I have a very large table and want to sort it during editing.  I thought that your macro would achieve the functionality, however not in the Cloud.

Like dalia likes this

Andrew,

I am trialing your macro and can't get it to sort columns in Edit mode.  I wrap a table with Table Filter, then in Edit 'Table Filter' Macro menu I can sort any column, however when I save out of the Edit 'Table Filter' Macro menu the table reverts back to the unsorted state.  Any ideas?

George,

Is the table sorted in the page view mode in this case? Sorting doesn't apply to tables in the page edit mode in Confluence Cloud.

Not sure if this is your case. I wanted to have a table be sorted in Edit mode too after data was entered w/o any sorting. 

  • Sort the table in View mode;
  • Select, copy the whole table;
  • Switch to Edit Mode;
  • Paste the table as a new one;
  • Removed the unsorted table;
Like # people like this

Good and free solution!

Filter in edit mode is a much needed use case.  Imagine having a big table and you only need to edit one or a set of rows with some common attributes somewhere in the table, without the ability to filter during editing, it is necessary to

  • Keep scrolling and scrolling until you find the row to edit!
  • If the rows in the targeted edit set are scattered in different spots on the table, it becomes a nightmare.

My work around, for now, is always adding a numbered column to the table.  Remembering the row number(s) you attempt to edit makes it a bit better in hunting for the row(s) in edit mode.

Like Jason Lott likes this

Hi there,

As this Community thread concerns our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view&edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

A shame that Atlassian do not have this basic functionality to sort and filter tables as part of their Confluence product.  But good to see your solution.  Just confirming though that this macro is in fact theTable Filter and Charts for Confluence app that can be licensed from Stillsoft through the Atlassian market place?

Yes, this macro is provided by the Table Filter and Charts for Confluence app (that is our add-on).

The app is a paid one but it's free for Cloud 1-10 users.

If you already have the add-on and are on Server/Data Center but don't see the Table Spreadsheet macro, then ask your Confluence administrator to update the app. The macro was released in January and we still continue to add more and more features to it.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events