Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to create a table with calculation formulas?

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

3 answers

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.

1 vote
Mohamed Adel Community Leader Mar 17, 2021

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 

Like # people like this

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.

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Welcome to the Confluence Holiday Workshop 🎁

Welcome to Confluence’s Holiday Workshop, where knowledge and collaboration collide! This year come celebrate the holidays with brand-new Confluence features to kickoff your new year, best practice...

426 views 11 31
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you