Skip to content
Spreadsheet Engine

SortCellsBlockedReason

type SortCellsBlockedReason = "merged-cells" | "multi-row-spill" | "spill-from-outside";

Why a SortCellsBlockedError refused the sort:

  • merged-cells — the range contains merged cells;
  • multi-row-spill — the range contains a spill spanning more than one row, which sorting rows independently would split;
  • spill-from-outside — a spill anchored left of the range extends into it, so its spilled-into cells cannot move with the sorted rows.