This page provides an example to override default Confluence styles and make user-defined styles persist for columns. For this example, you want to set background colors and borders of various columns, and auto-number all the rows.

Select this macro

*Macro name*	SQL Query
*Macro syntax*	{sql-query}

Define these parameters/values

*Column settings > Formatting > Column Styles (1* 2 3 4)	background:lightgrey; padding:15px; background:lightblue; color:teal background:lightyellow; border: 3px dotted green; 2
*Column settings > Numbering & Totaling > Insert auto number column*	On
*Column settings > Numbering & Totaling > Auto number column styles*	border: 5px solid #c1c7d0;
*Column settings > Numbering & Totaling > Apply Column styles to data column cells*	On

Observe that column 1 style is repeated in column 4, but, value 2 is used instead of 1. This is because Insert auto number column is On and it acts like the first column after the table is rendered.

Parameters to be set in the macro editor

Example result

When the Apply Column styles to data column cells is off, certain styles like the padding and the text color are not applied as shown:

When the Apply Column styles to data column cells is toggled on, the table is displayed with all the specified styles as shown:

Browser not supported