Add a setting to automatically alternate row colors for Confluence tables

Sarah Holdgrafer October 7, 2022

We build a lot of reference pages for our products' features and integrations in Confluence - we rely heavily on tables to organize certain types of content in an easily scannable/readable format for our internal teams. 

Once a table has more than 5-6 rows, though, we've found that formatting it with alternating row colors improves the readability significantly. However, we sometimes have to remove a row with outdated info or insert a new row with new info within the table, causing us to have to manually recolor the rows to maintain the alternating row color scheme. It's super tedious. 

It would be great if there was a table setting that could automatically alternate the row colors, so if we add or remove rows the alternating colors remain consistent (would be cool if this worked for alternating column colors too, btw). 

I do see this is possible with the Elements Spreadsheet add-on: https://community.atlassian.com/t5/Confluence-articles/How-to-alternate-color-rows-in-Confluence-tables/ba-p/1788022

But, that is really more functionality than we need and the tables in our use case tend to be only 3-4 columns wide (I'm also not keen to replace the tables in literally hundreds of pages with an add-on).

Would this be useful to anyone else? Any chance of this type of enhancement happening?

Thanks!

2 comments

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 8, 2022

I'm unsure if Atlassian would make this a priority or not. I used the alternating shading a couple of times. What I did was to not delete any rows but would replace content with "-".

Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 10, 2022

Hi @Sarah Holdgrafer ,

If your company uses the Table Filter and Charts for Confluence app (that is our add-on), note that you can apply conditional formatting via its Table Transformer macro.

It is not exactly your case as I see it, but if you already have the app installed for your instance, the coloring based on condition will make your tables more easy-to-read.

You may check here for an example.

Like # people like this
Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 10, 2022

And an update from me - the Table Spreadsheet macro that also belongs to our Table Filter and Charts for Confluence app and is compatible with our other macros can do the trick: go to the Background colors icon -> Alternating colors -> select the required cells' range and the type of formatting.

Mon 12-1.png

This feature copies the "Format as a table" feature in Excel. If you add/remove rows, the coloring is also adjusted automatically.

Like # people like this
Sarah Holdgrafer October 10, 2022

Hi Katerina, 

The Table Toolbox macro you suggest is in our account - and looks like it can do what I need - but I am not familiar with how to write the necessary SQL query to achieve alternating row colors. The examples on the developer's page haven't helped here.

Can you point me somewhere that might give me more direction?

Thanks!

Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 10, 2022

Hi @Sarah Holdgrafer ,

Please raise a support request - our portal is based on the Jira Service Desk and it's confidential. Attach a screenshot of your table with the headers visible and describe what exactly you need to get (on what condition to color rows, use alternating colors, etc.). We'll try to guide you through the case.

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events