writexl (version 2.0.0)

xl_outline: Control how outline (grouping) symbols are drawn

Description

Grouping itself comes from `level` in [xl_col_spec()] / [xl_row_spec()]. `xl_outline()` only changes how the controls are *displayed*, which is rarely needed --- the defaults match Excel's own.

Usage

xl_outline(
  visible = TRUE,
  symbols_below = TRUE,
  symbols_right = TRUE,
  auto_style = FALSE
)

Value

An `xl_outline` object, for [xl_sheet()]'s `outline` argument.

Arguments

visible

Show the outline symbols at all. `FALSE` keeps the grouping (and so the collapsing) but hides the +/- controls.

symbols_below

Put the summary row *below* the detail rows, which is Excel's default. `FALSE` puts it above.

symbols_right

Put the summary column to the *right* of the detail columns, Excel's default. `FALSE` puts it to the left.

auto_style

Apply Excel's automatic outline styling to the grouped rows and columns.

See Also

[xl_sheet], [xl_colrow_spec]

Other worksheet layout: xl_colrow_spec, xl_page_setup(), xl_sheet(), xl_sheet_view()

Examples

xl_outline(symbols_below = FALSE)
xl_outline(visible = FALSE)