You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
Unfortunately, there are no technical possibilities to implement this feature in Cloud environment: it is just impossible to integrate with the editor there.
You are welcome, Debora! I'll reply here if something changes in the future.
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.
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?
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.
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
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.
It's insane that this is not possible in Confluence Cloud. Before migrating from Confluence Data Center to Cloud we used this feature all the time. Tables can get huge and the inability to filter so that one can update only specific rows is the most common use case on the planet. How on Earth did this get deprecated? The Confluence Product Managers should be enraged!
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.