flextable (version 0.4.0)

set_formatter: set column formatter functions

Description

Define formatter functions associated to each column key. Functions have a single argument (the vector) and are returning the formatted values as a character vector.

Usage

set_formatter(x, ..., part = "body")
set_formatter_type(x, fmt_double = "%.03f", fmt_integer = "%.0f",
  fmt_date = "%Y-%m-%d", fmt_datetime = "%Y-%m-%d %H:%M:%S",
  fun_any = "format")

Arguments

x

a regulartable object

...

Name-value pairs of functions, names should be existing col_key values

part

partname of the table (one of 'body' or 'header')

fmt_double, fmt_integer

arguments used by sprintf to format double and integer columns.

fmt_date, fmt_datetime

arguments used by format to format date and date time columns.

fun_any

function name (character) to use to convert other types of columns as characters. Note that factors and strings are not transformed by this function.

set_formatter_type

set_formatter_type is an helper function to quickly define formatter functions regarding to column types.

Examples

# NOT RUN {
ft <- regulartable( head( iris ) )
ft <- set_formatter( x = ft,
        Sepal.Length = function(x) sprintf("%.02f", x),
        Sepal.Width = function(x) sprintf("%.04f", x)
      )
ft <- theme_vanilla( ft )
ft
# }