conditional formatting for public/private view

Is there a way in Confluence to reveal only certain columns from a table for public view?

There’s a situation in my group where in a table with many columns, some of the columns are private info while the rest of the columns are okay for the public. Any ideas on how to dice this?

I tried using:

only:: Partners 

designation on select private columns and nothing happened!



5 answers

1 accepted

Hello Udhaya Kulandaivelu,

I'm afraid to say that we do not have this level of customization where you can set selected content of a public page into private, but I agree with you that this feature would be useful, and Atlassian too.

They raised the suggestion CONF-42844 - Possibility to turn private selected content in a public page regarding your request, please vote on it, to increase the suggestion visibility and you can set yourself as watcher to receive notifications about any updates on this page.

Feel free to add comments on this suggestion if you think that you have any information to improve the suggestion or explaining how it can be useful for your environment.



0 vote
Davin Studer Community Champion Jun 09, 2016

I would say maybe put the data into an SQL table and then use an SQL addon to select the columns that you want to display and pipe it out to a table. Here are some SQL addon's that might do what you want.

SQL for Confluence

Play SQL Base



Thanks for the suggestions. Will try them.

not a definitive answer but can you use the Excerpt and Excerpt Include macros somehow??  Might not wok well as part of a table

But perhaps in your public page have a table but in the private page have the Excerpt Include from the public page plus a second table??

Does sound a tad messy ....


For conditional formatting in Confluence you may use CelesteCS Conditions for Confluence.

Assume you need to set a specific background color for some values on your table, for example, for 'Yes' make it light-green and for 'No' make it light-red. You just put your table into Conditional Rules Manager macro and add two Conditional Rule macros to specify rules of type 'Element Value Is Equal To', which is by default. In one of the rules you specify 'Value 1' = 'Yes' and 'Background color' = 'highlight-green' and in another one 'Value 1' = 'No' and 'Background color' = 'highlight-red'. That's it! The cells will be formatted appropriately.

As you see, it's very simple - just add a couple of macros and configure it properly. No need for doing it manually, writing user macros or use source code editors.

There are more than a dozen of conditional rule types supported. Plus, you may replace the text, not just to format it.

We are the CelesteCS Conditions for Confluence plugin vendor, so you may contact us directly if you have any additional questions or suggestions.



Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

2,811 views 26 10
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you