scenarios_style: Change font of scenario_col values

In gpw13/rapporteur: Reports on triple billion data

Change font of scenario_col values

Description

scenarios_style() changes the font of time series values based on the indicator type it is:

Usage

scenarios_style(
  df,
  wb,
  sheet_name,
  start_row,
  start_col,
  scenario_col,
  ind_df,
  scenarios_order
)

Arguments

df	data frame to be written
wb	a openxlsx workbook to be edited.
sheet_name	character name of the sheet to update
start_row	integer start row of styling. Passed to openxlsx::addStyle()
start_col	integer start col of styling. Passed to openxlsx::addStyle()
scenario_col	Column name of column with scenario identifiers. Useful for calculating contributions on data in long format rather than wide format.
ind_df	data frame containing the indicators in the correct order and format to be used.
scenarios_order	(character) vector in which scenario_col should be dplyr::arrange

Details

• bold: reported

• normal: estimated

• faded: imputed or projected

Value

openxslx Workbook object. Output file is in output_folder.

gpw13/rapporteur documentation built on Sept. 24, 2022, 9:15 a.m.