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.

[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.