It's not the same without you
Join the community to find out what other Atlassian users are discussing, debating and creating.
When I create tables in Confluence, I find that some tables become sortable (can click the header to sort a-z or z-a).
However, this isn't the case for every table.
What determines if a table is sortable or not?
In my experience often the cause of a Confluence table not being sortable is that it was initially created by copy/pasting from an excel file. In this case just converting the first row from from highlighted/bold to a header doesn't solve it. What does work is creating a new table with the same header plus a blank row then copy/pasting in the non-header rows of the existing table (max of 20 at a time it seems).
Steffen is basically correct.
If the first row is a heading row, then the table will be sortable. In addition though, if there are any merged cells in the table this will prevent it from being sortable.
Matt - it may be that the first row is just a highlighted row (select the row and highlight with a colour - including grey), rather than a heading row. The differences are subtle (heading rows should be bold text by default), but they are different.
You can make sure the first row is a header by clicking the "Heading Row" button in the table toolbar (it will appear not to do anything if the first row just looks like a heading row but wasn't).
Without seeing the raw table markup I don't think I can guess more than that.
I have opened a feature request for confluence server to make tables with merged cells sortable. If you are interested in this feature to be implemented, please vote for it.
I had the same issue with a one of my tables. Using the Confluence source editor add on - I noted that I had a <colgroup> section defined before the <th> definitions. This was causing the table to not "autosort"
What version of Confluence? - This is likely less important than I initally thought. I would bet Steffen has the right of things. Can we see tables with sample data to replicate locally?
Matt,
I was able to verify that those tables without header are unsortable in Cofluence 5.1.3.
Did you haev a chance to get us that sample data? I have a sneaking suspicion that your unsortable tables are missing the grey header rows.
I also have several tables that are unsortable. Something special about them is they contain Word macro inside of expand macro. Many cells with word files hidden under {expand}.
BTW Table filter macro refuses to work on that tables too. It complains "We can't filter this complex table because of merged cells. Sorry.". Also there are no merged cells in these tables.
I guess a Word macro has something that makes table like having merged cells. Is a bug?
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.
Read moreTo anyone who doubts that Atlassians are a little too obsessed with collaboration, and tools related thereto, let me describe a recent discussion we had (which took place on our internal Confluence, ...
Connect with like-minded Atlassian users at free events near you!
Find a groupConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.
Start an AUGYou're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.