Link Search Menu Expand Document

SSpread.AfterUserSort Event

Occurs after the data sort is complete.

Specifically, an event occurs during the following operations.

  • User clicks column header

  • Set $ColUserSortIndicatorAscending (sort / ascending order) and $ColUserSortIndicatorDescending (sort / descending order) in the ColUserSortIndicator property.

  • Set $UserColActionSort (sort / indicator display) and $UserColActionSortNoIndicator (sort / indicator hidden) in the UserColAction property.

The following child objects are attached to the Event object.

Type Name Description
Number Col Column number of the sorted column

Added since Ver.5.0.2

Example of usage

AllowRowMove = $TRUE;
Function OnAfterUserSort (e) {
    MessageBox ( str ( e.Col ) + " columns have been sorted ");
}

Related Item
ColUserSortIndicator, UserColAction property
BeforeUserSort event