Katerina Kovriga {Stiltsoft} Expert

Hi there, As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet. This 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.,…

Hi there, As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet. This 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.,…

Not sure that the Page Properties Report works as a plain manually created table where you adjust width in the page edit mode by dragging the column borders.

Hi there, As this question mentions 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…

Hi there, As this question mentions 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…

Hi there, As this question mentions 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…

Hi there, As this question mentions 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…

Hi there, As this question mentions 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…

Hi @Luecke , If you use our Table Filter and Charts for Confluence app, you'll be able to adjust the cells' width with the help of the Table Transformer macro.

Hi @Charles Vanek , The header column can be chosen instead of the header row in the menu under the table. As far as I know, the table options are currently not accessible to a screen reader nor a keyboard.

Hi @Dimitar_Shenkov , Please clarify what exactly you want to achieve and where you are stuck. The Table Excerpt/Table Excerpt Include macros are rather popular among our Cloud customers. Maybe the problem is that you want to filter/aggregate/visualize the result table coming from the Table Excerpt Include macro? The new…

Hi @Marco Pistana , We can also suggest trying our app that is Table Filter and Charts for Confluence. The app allows you not only to add Excel functionality to native Confluence tables and tabular dynamic macros, such as Jira Issues, Page Properties Report, etc. - you'll be able to filter, aggregate and visualize them.…

Hi @Lisa Overall , If we are talking about Confluence, you may look into the standard Jira Chart macro. If nothing suits your case, then you'll need additional apps to create Jira dashboards right in Confluence. For example, we can suggest trying our add-on - Table Filter and Charts for Confluence. The app supports the…

The Chart from Table macro will check all the typed in headers: if there are any then they will be included into the graph. So, if you know all the possible variants, then just type them beforehand. If your columns have random unpredictable names, then there is nothing to be done at the moment.

Hi @Cheryl Mitchell , We can suggest trying our app - Table Filter and Charts for Confluence. We've tried to recreate all the basic Excel features right in Confluence with the help of our app, so you don't need to switch between Excel and Confluence. Maybe you'll be interested in a live demo from our team - we'll be glad…

Hi @Eyal Zmora , We've created a corresponding ticket in our backlog and added your vote to it. I'll get back to you here when the feature is implemented. As for now, you may insert all the possible column header' names into the Chart from Table macro manually beforehand. For example, if you have Test_1 and Test_2 columns…

Hi @Eyal Zmora , the Table from CSV and the Chart from Table macros indeed belong to the Table Filter and Charts for Confluence app, so it seems that you are using it successfully. To have several aggregated tables/charts based on the one source table (manually created or coming from the CSV table), you may use the Table…

Hi @Ksenia Potroklova , Try to use conditions to exclude other rows - for example, here I exclude empty cells: SELECT *, CASE WHEN T1.'SC' IS NOT NULL THEN (T1.'Date' - "120d")::Date->toLocaleDateString("en-AU") END AS 'Verg specials' FROM T1 I also see that your third row is meant to contain text - maybe it will be better…

This option is present for Server/Data Center users: go to the Edit mode and click the Show filter button. All the predefined filters as well as hidden columns will be immediately applied to the table in the Edit mode as well:

With the standard set of macros you'll be able to reuse your tables and place them on the master page (check the Excerpt/Excerpt Include macros). The conditional formatting is also not possible out-of-the-box.

Hi @Katrina Elliott , You may also watch our short video tutorial about tables in the new Cloud editor: you'll learn how to customize and format them.

Hi @BERKOWSKI, MAXX , If you keep your information in tables, we may suggest trying our app - Table Filter and Charts for Confluence app. Its Table Filter macro will help you to filter your tables and search the information very fast and easy. And Table Excerpt/Table Excerpt Include macros may help you to combine…

Hi @Lisa Hooper , We can suggest trying our Table Filter and Charts for Confluence app. At first you may reuse these tables using the Table Excerpt/Table Excerpt Include macros (especially the second one - it is very convenient if your source tables are placed on different pages). For simplicity, I've placed them on the…

Hi @David Allan Neuhaus , Unfortunately, this feature is not available for Cloud due to the limitations of its editor.

Hi @Kruul S , We can suggest trying our Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros. You can give unique names to your Table Excerpts (place several excerpts on the same page) and choose whatever excerpt you need to include into your table cell via the Table Excerpt Include…

Hi @Julian Walter , I see that you use our Table Filter and Charts for Confluence app - you may use the Table Excerpt/Table Excerpt Include macros instead of the Page Properties Report macro. The Table Excerpt/Table Excerpt Include macros allow you to collect tables by labels and show the page source meta data.

I'm afraid this is not an issue but expected behavior for Confluence Cloud. Maybe pagination will suit your case more.

Hi @katieabell , Do you mean the Jira Chart that looks like a pie chart based on statuses? Or the two-dimensional chart that looks like a table aggregated by statuses? By the drop down do you mean that you want to filter them (use a dropdown filter) and leave only that status that you currently need? Our Table Filter and…

Hi @Eyal Zmora , You may add a column with unique IDs (keys) to the source CSV file, then create a regular manual table in Confluence with the same column (equal header and IDs), wrap the Table from CSV macro and the manually created table in the Table Transformer macro and use the Look up preset. When the page is…

Hi @Tara Costa , Try the Content by Label macro: here you can use OR and AND operators in the Label field.