Format numeric cells in a flextable.
colformat_double(
x,
i = NULL,
j = NULL,
big.mark = get_flextable_defaults()$big.mark,
decimal.mark = get_flextable_defaults()$decimal.mark,
digits = get_flextable_defaults()$digits,
na_str = get_flextable_defaults()$na_str,
nan_str = get_flextable_defaults()$nan_str,
prefix = "",
suffix = ""
)
a flextable object
rows selection
columns selection.
see formatC()
string to be used for NA and NaN values
string to be used as prefix or suffix
Other cells formatters:
colformat_char()
,
colformat_datetime()
,
colformat_date()
,
colformat_image()
,
colformat_int()
,
colformat_lgl()
,
colformat_num()
,
set_formatter()
dat <- mtcars
ft <- flextable(head(dat))
ft <- colformat_double(x = ft,
big.mark=",", digits = 2, na_str = "N/A")
autofit(ft)
#> a flextable object.
#> col_keys: `mpg`, `cyl`, `disp`, `hp`, `drat`, `wt`, `qsec`, `vs`, `am`, `gear`, `carb`
#> header has 1 row(s)
#> body has 6 row(s)
#> original dataset sample:
#> mpg cyl disp hp drat wt qsec vs am gear carb
#> Mazda RX4 21.0 6 160 110 3.90 2.620 16.46 0 1 4 4
#> Mazda RX4 Wag 21.0 6 160 110 3.90 2.875 17.02 0 1 4 4
#> Datsun 710 22.8 4 108 93 3.85 2.320 18.61 1 1 4 1
#> Hornet 4 Drive 21.4 6 258 110 3.08 3.215 19.44 1 0 3 1
#> Hornet Sportabout 18.7 8 360 175 3.15 3.440 17.02 0 0 3 2