RMarkdown Formattable Styling From kableExtra renders html code - not formatted value

Question

When using kableExtra's cell_spec function, I cannot get the rmd document to format the target cell correctly. I can see the html format being applied, but it is rendering the html code itself, not the formatted value. I'm trying to format the p-value of a simple summary stats output.

What ends up rendered in the .html file is below:

I'm doing the same thing as below but with my own real data. For reference, this chunk produces the same problem.

mtcars %>% 
  rownames_to_column('car') %>% 
  select(car, mpg, disp, hp, wt) %>% 
  mutate(wt = ifelse(wt < 2, 
                     kableExtra::cell_spec(wt, color = 'red', bold = TRUE), 
                     wt)) %>% 
  kableExtra::kable() %>% 
  kableExtra::kable_styling()

Paul Paul · Accepted Answer · 2019-04-09T01:25:33

kableExtra::kable(escape = F) is what you want:

library(kableExtra)
library(dplyr)

mtcars %>% 
  rownames_to_column('car') %>% 
  select(car, mpg, disp, hp, wt) %>% 
  mutate(wt = ifelse(wt < 2, 
                     kableExtra::cell_spec(wt, color = 'red', bold = TRUE), 
                     wt)) %>% 
  kableExtra::kable(escape = F) %>% 
  kableExtra::kable_styling()

RMarkdown Formattable Styling From kableExtra renders html code - not formatted value

1 Answers