Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,301,312
Community Members
 
Community Events
165
Community Groups

Macro for table with Merged cells

I want to create a table similar to the following:

 

Col4

Col3

Col2

Col1

1_4

1_3

1_2

1

2_4

2_3

2_2

2

3_4

3_3

3_2

4_4

4_3

4_2

4

One merged cell - which actually references 2 rows.

I dont mind achieving this by merging cells or creating a hierarchical table.

Any idea which Macro I should use, and how to do it?

 

Eyal

 

1 answer

Hi @Eyal Zmora ,

If you want to create this table manually (just merge several cells), then you don't need any macros: select your cells and choose to merge them from the menu.

Mon 4-1.png

If you mean that you want to group your data, to create an aggregated pivot table like in Excel, then you'll need additional apps from the Atlassian Marketplace.

For example, we can suggest trying our Table Filter and Charts for Confluence app and its Pivot Table macro.

Hi @Katerina Kovriga _Stiltsoft_  I am writing python code which generates csv/json files of some format. I'd like to use them as the basis for the Confluence table. So to your question - this is not manual. 

I looked at the Table Filter and Charts for Confluence, and as its name implies it allows filtering of the data and displaying charts of different types.

The Pivot Table macro allows aggregation of the data.

I am still not sure how to merge specific cells, or create a hierarchical table (A table with data which can be collapsed and expanded).

 

Thanks,

Eyal 

Thank you for the clarification - seems that our app is not exactly what you need.

We provide the Table from JSON/Table from CSV macros that can recreate tables in Confluence from json/csv attachments/URLs. These tables can be further filtered/aggregated.

But we don't have the hierarchical tables feature. Hope somebody else will come across this question, read this thread and suggest a solution.

Suggest an answer

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

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

434 views 2 13
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