在reactable()列添加图标失败：表格未生成问题排查

问题分析 #

• 函数使用场景错误：icon_sets是reactablefmtr包的列格式化函数，需直接作为colDef的formatter参数使用，不能嵌套在自定义cell函数中。你当前的用法会打乱表格渲染逻辑，导致表格无法生成。
• 分支缺失返回值：当COHORT=1时，代码仅定义了icon和color变量，但未返回任何内容，对应行的单元格无输出，进一步破坏表格结构。
• 图标名称无效：arrow-down-up-lock不是Font Awesome的标准图标名称（reactablefmtr依赖Font Awesome），需使用有效名称如arrow-down或lock等。

修复方案 #

方案1：使用reactablefmtr的icon_sets（推荐） #

直接将icon_sets作为列格式化器，无需自定义cell函数：

library(reactable)
library(reactablefmtr)

data <- data.frame(
  PAYER = c("A","B","A","B","A","B","A","A","B","A","A","B","A","B","A","A","B","A","B","B","A"),
  PERIOD = c("POST","PRE","POST","PRE","PRE","PRE","POST","PRE","POST","PRE","POST","PRE","POST","PRE","PRE","PRE","POST","PRE","PRE","POST","POST"),
  VALUE = c(100,100,200,250,500,150,400,500,350,200,500,350,200,500,350,200,250,500,150,400,500),
  COHORT = c(1,0,0,0,1,1,0,1,1,0,1,1,0,0,0,1,1,0,1,1,0)
)

data %>%
  reactable(columns = list(
    COHORT = colDef(
      formatter = icon_sets,
      icon_size = 20,
      icon_position = "right",
      icons = c("arrow-down", "arrow-up"), # 对应0和1的图标，注意顺序
      colors = c("red", "green")
    )
  ))

方案2：自定义HTML单元格（更灵活） #

若需同时显示数值和图标，用HTML标签构建单元格内容：

library(reactable)
library(htmltools)

data <- data.frame(
  PAYER = c("A","B","A","B","A","B","A","A","B","A","A","B","A","B","A","A","B","A","B","B","A"),
  PERIOD = c("POST","PRE","POST","PRE","PRE","PRE","POST","PRE","POST","PRE","POST","PRE","POST","PRE","PRE","PRE","POST","PRE","PRE","POST","POST"),
  VALUE = c(100,100,200,250,500,150,400,500,350,200,500,350,200,500,350,200,250,500,150,400,500),
  COHORT = c(1,0,0,0,1,1,0,1,1,0,1,1,0,0,0,1,1,0,1,1,0)
)

data %>%
  reactable(columns = list(
    COHORT = colDef(cell = function(value) {
      if (value == 1) {
        icon_html <- tags$i(class = "fa-solid fa-arrow-up", style = "color: green; margin-left: 8px; font-size: 20px;")
      } else {
        icon_html <- tags$i(class = "fa-solid fa-lock", style = "color: red; margin-left: 8px; font-size: 20px;")
      }
      # 返回包含数值和图标的HTML元素
      tags$span(value, icon_html)
    })
  ))

注意事项 #

• 确保已安装并加载对应依赖包：方案1需reactablefmtr，方案2需htmltools。
• 使用Font Awesome图标时，需使用官方提供的有效类名。
• 自定义cell函数必须返回HTML元素或文本，不能直接调用列格式化函数。

内容的提问来源于stack exchange，提问作者Annie