Is there anyway I can filter spreadsheets/table and create pivot tables in Confluence ?
Hello Ron,
There is Table Filter macro and Pivot Table macro in Table Filter and Charts add-on.
Did some recent cloud version lose this ability to filter tables? I recall being able to do this previously. Or has this always required a macro?
There was never built-in filtration feature. Most likely you used Table Filter macro previously.
I cannot find Table Filter among the macros list. Is this something to do with the version I use?
Since 2019... since Confluence has evolved, is this feature not embedded without any add on ?
Thanks
Hi @Sébastien NOEL ,
I'm afraid that you are right - at the moment it is not possible to filter, aggregate and calculate tabular data in Confluence out-of-the-box.
So, again we can suggest trying our app - Table Filter and Charts for Confluence (it is available for Cloud/Server/Data Center).
Maybe you'll be interested in a live demo from our team - please book a suitable time slot here.
Edit the page and click into the table then select the filter icon from the table options in the menu.
To filter tables in Confluence, you need additional apps. Please, specify which add-on you recommend.
For example, we suggest using our Table Filter and Charts for Confluence and its Table Filter macro (see the answer above).
Hi there,
As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.
Our new 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 and edit mode.
The Table Spreadsheet macro is available for Cloud and Server/Data Center.
An update: And you may also check out two additions to our spreadsheet family - Spreadsheet from Table and Table Spreadsheet Include macros.
The first one turns manually created and macro generated (Jira Issues, Page Properties Report) tables into fully functional Excel-like spreadsheet. The second one - helps to reuse parts of your sheets across your Confluence instance.
Hope you may find it useful.
It looks like you're new here. Sign in or register to get started.