Built-in Worksheet Actions

This page lists the actions ReoGrid emits internally (undo/redo-enabled) and the other built-in actions that are available to call manually via Worksheet.DoAction.

Actions triggered by built-in UI

User operation	Action	What it does
Finish editing a cell; change value in built-in checkbox/dropdown/combobox cell types	`SetCellDataAction`	Stores the new cell value.
Press Delete to clear selection	`RemoveRangeDataAction`	Removes data in the current selection.
Paste ReoGrid rich content/`PartialGrid`	`SetPartialGridAction`	Pastes data including styles, borders, and merges.
Paste plain text (tab-separated, etc.)	`SetRangeDataAction`	Converts text to a 2D array and pastes into the selection.
Drag a selection to a new location	`MoveRangeAction`	Moves the selected range.
Ctrl + drag a selection	`CopyRangeAction`	Copies the selected range.
Drag fill handle to extend series	`AutoFillSerialAction`	Auto-fills data from the selection (when built with FORMULA).
Drag row header separator	`SetRowsHeightAction`	Records the new row height.
Drag column header separator	`SetColumnsWidthAction`	Records the new column width.
Double-click column header separator (auto-fit enabled)	`AutoFitColumnsWidthAction`	Auto-fits column width to content.
Use the style brush to copy style/format	`SetRangeStyleAction` / `SetRangeDataFormatAction`	Applies source range style and data format to another range.

Other provided actions (not issued by built-in UI)

These actions are available for apps to call via Worksheet.DoAction but are not triggered automatically by the standard UI.

InsertRowsAction, RemoveRowsAction
InsertColumnsAction, RemoveColumnsAction
HideRowsAction, HideColumnsAction, UnhideRowsAction, UnhideColumnsAction
MergeRangeAction, UnmergeRangeAction
SetRangeBorderAction, RemoveRangeBorderAction, RemoveRangeStyleAction
StepRangeFontSizeAction
Outline actions: AddOutlineAction, RemoveOutlineAction, ClearOutlineAction, CollapseOutlineAction, ExpandOutlineAction
Filtering: CreateAutoFilterAction
Workbook actions: InsertWorksheetAction, RemoveWorksheetAction

DoAction examples

// Set a single cell
worksheet.DoAction(new SetCellDataAction("B2", "Hello"));

// Paste a 2×2 value array starting at C3
var data = new object[,] { { 1, 2 }, { 3, 4 } };
worksheet.DoAction(new SetRangeDataAction(new RangePosition("C3:D4"), data));

// Move selection to a new top-left position
worksheet.DoAction(new MoveRangeAction(worksheet.SelectionRange, new CellPosition(10, 2)));

// Insert two rows before row 5
worksheet.DoAction(new InsertRowsAction(5, 2));

// Apply borders to the current selection
worksheet.DoAction(new SetRangeBorderAction(
    worksheet.SelectionRange,
    BorderPositions.Outside,
    new RangeBorderStyle { Color = Colors.Black, Style = BorderLineStyle.Solid }));

Learn more about the Action Framework.