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 = "" )
Arguments
| x | a flextable object |
|---|---|
| i | rows selection |
| j | columns selection. |
| big.mark, digits, decimal.mark | see |
| na_str | string to be used for NA and NaN values |
| nan_str | string to be used for NA and NaN values |
| prefix | string to be used as prefix or suffix |
| suffix | string to be used as prefix or suffix |
Illustrations
See also
Other cells formatters:
colformat_char(),
colformat_datetime(),
colformat_date(),
colformat_image(),
colformat_int(),
colformat_lgl(),
colformat_num(),
compose(),
set_formatter()
Examples
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