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.