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)Arguments
- wb
A workbook object
- font_size
Font size
- font_color
Font color
- font_name
Name of a font
- ...
Additional arguments
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_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"
#>
#>