The `merge_column()` function can be used to merge and style values from two columns within a reactable table. `merge_column()` works with both numeric and non-numeric columns. The style/format of both the current column and merged column can be controlled via size, color, weight, and text decoration. Any style parameters that start with "merged_" will control the column that is being merged and specified by `merged_name`. Any style parameters that do not start with "merged_" control the current column you are within. The position of the column to be merged relative to the current column can be controlled with `merged_position`. The position options for the merged column are above, below, left, or right to the current column. The spacing between the current column and the merged column can be controlled with `spacing`. `merge_column()` needs to placed within the cell argument in reactable::colDef.
Usage
merge_column(
data,
merged_name = NULL,
merged_position = "right",
merged_size = 12,
merged_color = "#777",
merged_weight = "normal",
merged_style = "normal",
merged_decoration = "normal",
size = 14,
color = NULL,
weight = "bold",
style = "normal",
decoration = NULL,
spacing = 0
)Arguments
- data
Dataset containing either a text or numeric column.
- merged_name
The name of the column to merge with the existing column. The column can contain either numeric or non-numeric data. Only a single column can be provided. Default is NULL.
- merged_position
The position of the merged column in relation to the existing column. Options are 'right', 'left', 'above', or 'below'. Default is right.
- merged_size
The size of the text of the merged column. Default is 12.
- merged_color
The color of the text of the merged column. Default is #777.
- merged_weight
The font weight of the text of the merged column. Options are "bold" or "normal". Default is "normal".
- merged_style
The style of the text of the merged column. Options are "normal" or "italic". Default is "normal".
- merged_decoration
The decoration of the text of the merged column. For example, add an underline, overline, or line-through to the text. Default is NULL.
- size
The size of the text displayed in the current column. Default is 12.
- color
The color of the text displayed in the current column. Default is NULL.
- weight
The font weight of the text displayed in the current column. Options are "bold" or "normal". Default is "normal".
- style
The style of the text displayed in the current column. Options are "normal" or "italic". Default is "normal".
- decoration
The decoration of the text displayed in the current column. For example, add an underline, overline, or line-through to the text. Default is NULL.
- spacing
The spacing between the merged and existing columns. A value greater than 0 creates more space between, a value less than 0 creates less space. Default is 0.
Examples
data <- MASS::Cars93[20:49, c("Manufacturer", "Model", "MPG.city", "MPG.highway")]
## Stack text from one column with another column:
reactable(
data,
columns = list(
Manufacturer = colDef(name = "Manufacturer/Model",
cell = merge_column(data, merged_name = "Model"
)),
Model = colDef(show = FALSE)))
#> Error in x$width %||% settings$fig.width * settings$dpi: non-numeric argument to binary operator
## Control the appearance of both the current and merged columns:
reactable(
data,
columns = list(
Manufacturer = colDef(name = "Manufacturer/Model",
cell = merge_column(data,
merged_name = "Model",
merged_size = 16,
merged_color = "blue",
merged_style = "italic",
size = 18,
color = "red"
)),
Model = colDef(show = FALSE)))
#> Error in x$width %||% settings$fig.width * settings$dpi: non-numeric argument to binary operator
## Combine both numeric and non-numeric columns together:
reactable(
data,
columns = list(
Model = colDef(name = "Model/MPG Highway",
cell = merge_column(data,
merged_name = "MPG.highway",
merged_position = "below",
merged_size = 20,
merged_color = "green"
)),
MPG.highway = colDef(show = FALSE),
MPG.city = colDef(show = FALSE)))
#> Error in x$width %||% settings$fig.width * settings$dpi: non-numeric argument to binary operator