Search results

BeforeSortEventArgs API in JavaScript (ES5) Spreadsheet API control

Specifies the event arguments before the sorting operation begins.

Properties

cancel

boolean

Specifies whether the sorting operation should be prevented. If set to true, the sorting will not proceed.

previousSort

SortCollectionModel | SortCollectionModel[]

Specifies the previous sort collection model. This is used to track the previous sorting state before the current operation.

range

string

Specifies the range of cells that were sorted. This defines the area in the spreadsheet that was affected by the sorting operation.

sortOptions

SortOptions

Specifies the sorting options that were used. This could include which columns were sorted, the sort order, and whether headers were considered.