The cells_column_spanners() function is used to target the cells that
contain the table column spanners. This is useful when applying a footnote
with tab_footnote() or adding custom style with tab_style(). The function
is expressly used in each of those functions' locations argument. The
'column_spanners' location is generated by one or more uses of the
tab_spanner() function or the tab_spanner_delim() function.
cells_column_spanners(spanners = everything())
| spanners | The names of the spanners that are to be targeted. |
|---|
A list object with the classes cells_column_spanners and
location_cells.
Location helper functions can be used to target cells with virtually any
function that has a locations argument. Here is a listing of all of the
location helper functions, with locations corresponding roughly from top to
bottom of a table:
cells_title(): targets the table title or the table subtitle depending on
the value given to the groups argument ("title" or "subtitle").
cells_stubhead(): targets the stubhead location, a cell of which is only
available when there is a stub; a label in that location can be created by
using the tab_stubhead() function.
cells_column_spanners(): targets the spanner column labels with the
spanners argument; spanner column labels appear above the column labels.
cells_column_labels(): targets the column labels with its columns
argument.
cells_row_groups(): targets the row group labels in any available row
groups using the groups argument.
cells_stub(): targets row labels in the table stub using the rows
argument.
cells_body(): targets data cells in the table body using intersections of
columns and rows.
cells_summary(): targets summary cells in the table body using the
groups argument and intersections of columns and rows.
cells_grand_summary(): targets cells of the table's grand summary using
intersections of columns and rows
cells_stub_summary(): targets summary row labels in the table stub using
the groups and rows arguments.
cells_stub_grand_summary(): targets grand summary row labels in the table
stub using the rows argument.
cells_footnotes(): targets all footnotes in the table footer (cannot be
used with tab_footnote()).
cells_source_notes(): targets all source notes in the table footer
(cannot be used with tab_footnote()).
When using any of the location helper functions with an appropriate function
that has a locations argument (e.g., tab_style()), multiple locations
can be targeted by enclosing several cells_*() helper functions in a
list() (e.g., list(cells_body(), cells_grand_summary())).

7-7
Other Helper Functions:
adjust_luminance(),
cell_borders(),
cell_fill(),
cell_text(),
cells_body(),
cells_column_labels(),
cells_footnotes(),
cells_grand_summary(),
cells_row_groups(),
cells_source_notes(),
cells_stub_grand_summary(),
cells_stub_summary(),
cells_stubhead(),
cells_stub(),
cells_summary(),
cells_title(),
currency(),
default_fonts(),
escape_latex(),
google_font(),
gt_latex_dependencies(),
html(),
md(),
pct(),
px(),
random_id()
# Use `exibble` to create a gt table; add a # spanner column label over three column # labels and then use `tab_style()` to make # the spanner label text bold tab_1 <- exibble %>% dplyr::select(-fctr, -currency, -group) %>% gt(rowname_col = "row") %>% tab_spanner( label = "dates and times", id = "dt", columns = c(date, time, datetime) ) %>% tab_style( style = cell_text(weight = "bold"), locations = cells_column_spanners(spanners = "dt") )