Navigation :

StyleCode Property: cellBackground

cellBackground

Specifies the background color of a cell in a show table.

Applies to	Type	Default
`table > column > append` `table > column > prepend` `table > column > value`	color, `default`	`default`

Examples

// Example: table > column > append
table Orders = with
  [| as Date, as Quantity |]
  [| date(2023,02,21), 150 |]
  [| date(2023,02,22), 250 |]

show table "My Table" a1c4 with
  Orders.Date { append { cellBackground: tomato } }
  Orders.Quantity

// Example: table > column > prepend
table Orders = with
  [| as Date, as Quantity |]
  [| date(2023,02,21), 150 |]
  [| date(2023,02,22), 250 |]

show table "My Table" a1c4 with
  Orders.Date { prepend { cellBackground: tomato } }
  Orders.Quantity

// Example: table > column > value
table Orders = with
  [| as Date, as Quantity |]
  [| date(2023,02,21), 150 |]
  [| date(2023,02,22), 250 |]

show table "My Table" a1c4 with
  Orders.Date { value { cellBackground: tomato } }
  Orders.Quantity

Details

By default, the background color of cells is white, and becomes #F8F8F8 when the table is zoomed in. This behaviour is retained when this property is default. Setting the property of a color uses that color for the background of the cells:

For header, the header cell.
For value, for all the value cells.

User Contributed Notes

0 notes + add a note