How to create a table with calculation formulas?

[Sereima Kavetani]

Hi Team,

I have a table created in excel, which contains calculation on rows/ columns (simple calculation like adding/multiplying/ dividing numbers). I want to create the same table in Confluence. So including the calculations/formulas so that the table is updated if the numbers change. I have looked at Macros ->other Macros but this table doesn't allow me to calculate. It would be perfect if I could import the excel table into Confluence and the calculations would remain. Is this (or something similar) possible in Confluence? If so, how to do it? Appreciate if someone can please assist me with this.

Thanks

[Katerina Kovriga {Stiltsoft}]

Hi @Sereima Kavetani ,

as it was mentioned before, there is no such feature in Confluence out-of-the box, so you'll need additional apps.

For example, you may use the Table Filter and Charts for Confluence app. Its Table Transformer macro allows you to perform a wide range of table calculations as well as conditional formatting.

[Stiltsoft support]

And an update from our side: you may also use our Table Spreadsheet macro if you prefer to work with Excel-like features and cell formulas.

And if you have already created manual tables or macro generated tables (Jira Issues, Page Properties Report, etc.), you may take the Spreadsheet from Table macro.

These macros are also provided by the Table Filter, Charts & Spreadsheets for Confluence app that we develop.

[George Rozakis]

Are the above solutions applicable to a Confluence Database as well?

[Mohamed Adel]

Hi @Sereima Kavetani ,

it is not out of the box macro in confluence , i recommend for you to take a look at this plugin qron-calc-macro-excel-formula-in-table 

[Sereima Kavetani]

Thank you @Mohamed Adel

[Defne Alpdogan]

Is there a template where I can see how Confluence takes the formulas on Excel ? My formulas from Excel do not work that is why I was wondering whether they use " ; " splitting arrays etc.

[Luiz Gregorio]

Indeed, Confluence does not have this feature out of the box, you must rely on plugins for that.

As mentioned by @Mohamed Adel Qron plugin is very good on that job.

[Sereima Kavetani]

Thanks. The only problem is that it has to be paid:) and am working in an organization so will need approvals and etc.