Skip to content
Spreadsheet Engine

DataTableBlockedOperation

type DataTableBlockedOperation =
| "insert-rows"
| "insert-columns"
| "delete-rows"
| "delete-columns"
| "insert-cells"
| "delete-cells"
| "move-rows"
| "move-columns"
| "move-cells"
| "move-cells-onto"
| "overwrite";

The kind of edit a DataTableEditBlockedError refusal is about, for programmatic handling (e.g. a localized message) by the host application:

  • insert-rows / insert-columns --- an entire-line insert that would split the table;
  • delete-rows / delete-columns --- an entire-line delete taking part of the table;
  • insert-cells --- a bounded insertCells whose range touches the table’s block, or whose shift would move only part of it;
  • delete-cells --- a bounded deleteCells taking part of the table (short of removing it whole), or whose shift would move only part of it;
  • move-rows / move-columns --- an entire-line move taking part of the table;
  • move-cells --- a moveCells cutting part of the table (or exactly its result range);
  • move-cells-onto --- a moveCells landing on part of the table’s result range;
  • overwrite --- a write or clear changing part of the result range; also used by the fill and sort refusals, which refuse any touch of the result range (the message names the refused operation).