PivotBlockedOperation

type PivotBlockedOperation =
  | "insert-rows"
  | "insert-columns"
  | "delete-rows"
  | "delete-columns"
  | "insert-cells"
  | "delete-cells"
  | "move-rows"
  | "move-columns"
  | "move-cells"
  | "move-cells-onto"
  | "clear-cells"
  | "fill"
  | "sort";

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

• insert-rows / insert-columns --- an entire-line insert landing strictly inside the pivot table’s footprint (insertion at the top/left boundary is allowed and shifts it);
• delete-rows / delete-columns --- an entire-line delete covering some but not all of the pivot table on the deleted axis;
• insert-cells / delete-cells --- a bounded insertCells/deleteCells whose range or shift path would change or move only part of the pivot table;
• move-rows / move-columns --- an entire-line move pulling lines out of the pivot table, or inserting them strictly inside it;
• move-cells --- a moveCells whose source range touches the pivot table;
• move-cells-onto --- a moveCells whose destination range touches the pivot table;
• clear-cells --- a clearCells touching the pivot table;
• fill --- a fill whose written region touches the pivot table;
• sort --- a sortCells whose range touches the pivot table.