Modify / get the default font for the workbook. This will alter the latin major and minor font in the workbooks theme.
Usage
wb_set_base_font(
wb,
font_size = 11,
font_color = wb_color(theme = "1"),
font_name = "Aptos Narrow",
...
)
wb_get_base_font(wb)Details
The font name is not validated in anyway. Spreadsheet software replaces unknown font names with system defaults.
The default base font is Aptos Narrow, black, size 11. If font_name differs
from the name in wb_get_base_font(), the theme is updated to use the newly
selected font name.
See also
Other workbook styling functions:
wb_add_dxfs_style(),
wb_add_style(),
wb_base_colors
Other workbook wrappers:
col_widths-wb,
creators-wb,
grouping-wb,
row_heights-wb,
wb_add_chartsheet(),
wb_add_data(),
wb_add_data_table(),
wb_add_formula(),
wb_add_hyperlink(),
wb_add_pivot_table(),
wb_add_slicer(),
wb_add_worksheet(),
wb_base_colors,
wb_clone_worksheet(),
wb_copy_cells(),
wb_freeze_pane(),
wb_merge_cells(),
wb_save(),
wb_set_last_modified_by(),
wb_workbook()
Examples
## create a workbook
wb <- wb_workbook(theme = "Office 2013 - 2022 Theme")
wb$add_worksheet("S1")
## modify base font to size 10 Aptos Narrow in red
wb$set_base_font(font_size = 10, font_color = wb_color("red"), font_name = "Aptos Narrow")
wb$add_data(x = iris)
## font color does not affect tables
wb$add_data_table(x = iris, dims = wb_dims(from_col = 10))
## get the base font
wb_get_base_font(wb)
#> $size
#> $size$val
#> [1] "10"
#>
#>
#> $color
#> $color$rgb
#> [1] "FFFF0000"
#>
#>
#> $name
#> $name$val
#> [1] "Aptos Narrow"
#>
#>