number_format: Column formatter

In cheetahR: High Performance Tables Using 'Cheetah Grid'

Column formatter

Description

Format numeric and date columns using international formatting standards. Use number_format() to add data formatting to numeric columns and date_format() to format date columns according to the Intl.DateTimeFormat API.

Usage

number_format(
  style = c("decimal", "currency", "percent", "unit"),
  currency = NULL,
  currency_display = c("symbol", "code", "narrowSymbol", "name"),
  currency_sign = c("standard", "accounting"),
  unit = NULL,
  unit_display = c("short", "narrow", "long"),
  locales = NULL,
  locale_options = NULL,
  digit_options = NULL,
  other_options = NULL
)

date_format(
  locales = NULL,
  day = c("numeric", "2-digit"),
  year = c("numeric", "2-digit"),
  hour = c("numeric", "2-digit"),
  minute = c("numeric", "2-digit"),
  second = c("numeric", "2-digit"),
  month = c("numeric", "2-digit", "long", "short", "narrow"),
  weekday = c("long", "short", "narrow"),
  day_period = c("narrow", "long", "short"),
  hour12 = FALSE,
  time_zone = NULL,
  date_style = c("none", "full", "long", "medium", "short"),
  time_style = c("none", "full", "long", "medium", "short"),
  more_date_options = NULL,
  locales_date_options = NULL
)

Arguments

style	The formatting style to use. Must be one of the following: "decimal" for plain number formatting action columns. Default. "currency" for currency formatting "percent" for percent formatting. "unit" for unit formatting.
currency	The ISO 4217 currency code to use for currency formatting. Must be provided if style is "currency".
currency_display	The display format for the currency. Must be one of the following: "symbol" for the currency symbol. Default. Use the localized currency symbol e.g. $ for USD. "code" for the currency code. Use the ISO 4217 currency code e.g. USD for US Dollar. "narrowSymbol" for the narrow currency symbol. Use the narrow currency symbol e.g. ⁠$100⁠ instead of ⁠$USD100⁠. "name" for the currency name. Use the localized currency name e.g. Dollar for USD.
currency_sign	The sign to use for the currency. Must be one of the following: "standard" for the standard format. Default. "accounting" for the accounting format. Use the accounting sign e.g. $100 instead of $USD100.
unit	The unit to use for the unit formatting. Must be provided if style is "unit".
unit_display	The display format for the unit. Must be one of the following: "short" for the short format. Default. E.g., 16 l "narrow" for the narrow format. E.g., 16l "long" for the long format. E.g., 16 liters
locales	A character vector of BCP 47 language tags (e.g. "en-US" for English, "ja-JP" for Japanese) specifying the locales to use for formatting. If NULL, the runtime's default locale is used. See BCP 47 language tags for reference.
locale_options	A named list of options to customize the locale.
digit_options	A named list of options to customize the digit.
other_options	A named list of other options to customize the number formatting.
day, month, year, hour, minute, second	The format to use for the day, month, year, hour, minute, and second. The possible values are "numeric", and "2-digit" except month, with more options i.e "long", "short", and "narrow". Default for all is "numeric".
weekday, day_period	The format to use for the weekday and day period. The possible values are "long", "short", and "narrow".
hour12	Whether to use 12-hour time format or the 24-hour format. Default is FALSE.
time_zone	The time zone to use for the date formatting. E.g. "America/New_York".
date_style, time_style	The format to use for the date and time styles. The available values are "none", "full", "long", "medium", and "short". Note: date_style and time_style can be used together, but not with other date-time component options like weekday, hour, or month.
more_date_options	A named list of other options to customize the date formatting.
locales_date_options	A named list of options to customize the locales for the date. @note Further details on customizing numeric formatting can be found in the Intl.NumberFormat documentation. Further details on customizing date formatting can be found in the Intl.DateTimeFormat documentation

Value

For number_format(): A list containing number formatting options that can be used to format numeric data in a column. For date_format(): A list containing date formatting options that can be used to format date data in a column.

Examples

# Number formatting examples
data <- data.frame(
  price_USD = c(125000.75, 299.99, 7890.45),
  price_EUR = c(410.25, 18750.60, 1589342.80),
  liter = c(20, 35, 42),
  percent = c(0.875, 0.642, 0.238)
)

cheetah(
  data,
  columns = list(
    price_USD = column_def(
      name = "USD",
      column_type = number_format(
        style = "currency",
        currency = "USD"
      )
    ),
    price_EUR = column_def(
      name = "EUR",
      column_type = number_format(
        style = "currency",
        currency = "EUR",
        locales = "de-DE"
      )
    ),
    liter = column_def(
      name = "Liter",
      column_type = number_format(
        style = "unit",
        unit = "liter",
        unit_display = "long"
      )
    ),
    percent = column_def(
      name = "Percent",
      column_type = number_format(style = "percent")
    )
  )
)

# Date formatting examples
date_data <- data.frame(
  date = as.Date(c("2024-01-01", "2024-01-02", "2024-01-03"))
)

cheetah(
  date_data,
  columns = list(
    date = column_def(
      name = "Date",
      column_type = date_format(
        locales = "en-US",
        day = "2-digit",
        month = "long",
        year = "numeric"
      )
    )
  )
)

cheetahR documentation built on Aug. 9, 2025, 1:07 a.m.