This page provides an example to make user defined styles persist for rows. For this example, let's consider Monthly Temperatures table for which you want to set styles of various rows, including the header row.
Select this macro
Macro name | SQL Query |
Macro syntax | {sql-query} |
Define these parameters/values
Row formatting > Data rows > Row Styles (1 2
| background:lightgrey; font-size:1em; padding-top:25px; background:lightblue; font-size:1.2em; border: 2.5px dotted black font-style:italic; font-size: 1em; padding-left:35px |
Row formatting > Header & Footer rows > Header row styles | font-size: 1.5em; padding:20px; border: 5px solid #c1c7d0; |
Row formatting > Advanced settings > Apply Row styles to data row cells | On |
Screenshots
Example results
When the Apply Row styles to data row cells is off, certain styles for cell padding or borders are not applied as shown:
When the Apply Row styles to data row cells is toggled on, all the specified styles are applied as shown: