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.
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.
Hi @David Allan Neuhaus ,
This menu comes with our app - Table Filter and Charts for Confluence. If you don't see the panel, it means that the add-on is not installed by your Confluence administrator.
You may also try to find our macros through the macrobrowser - Table Filter, Pivot Table, for example. If the app is active, they should be present there as well.
@Katerina Kovriga _Stiltsoft_ Thanks for the info. I am an admin for my confluence account and did add this service from the Atlassian Marketplace. I am able to filter on tables and use the tool to great efficacy. However, the additional tool bar is still missing and I see nothing in the Application settings except a get started section that walks users through the functionality:
@Katerina Kovriga _Stiltsoft_ oh that makes me a sad panda. I loved the convenience of that bar.
Really I just love the convenience of this Tables App. Are there any other settings or configurations that I might be missing? Still getting used to navigating the Atlassian landscape as an Admin. Thanks and looking forward to the Stiltsoft Tables course when that is finished
The new Cloud editor is based on iFrames - you won't be able to wrap our macros directly into each other (for example, if you need to build a chart using the filtered table). So, you'll need the Table Toolbox macro to nest macros - this macro is provided especially for Cloud users.
But all the main features are the same.
@Katerina Kovriga _Stiltsoft_ I am having an issue with freezing the top row when editing the table macro. The row freezes fine, but makes the whole table a smaller frame in the main page where I created the table (ie the table now has a scrollbar as well as the main page). Basically it forces me to select a table height. Forcing a massive table height effectively unfreezes the top row. Is there a way to get the top row frozen without forcing a table height?
Also, I am not sure where to ask this or other questions. This and any further questions I have are no longer appropriate for this thread.
Calling all collaborators! Appy Hours on the Atlassian Community is a monthly event where 4 Partner and app vendor presenters go head-to-head with 5-minute demos for the title of Best App Demo. I...