SSpread.UserColAction Property
Sets the action to be taken when a column header is clicked.
Specify the following values. The initial value is $UserColActionDefault .
| Constant | Value | Explanation |
|---|---|---|
| $UserColActionDefault | 0 | Select a column |
| $UserColActionSort | 1 | Sort (sort indicator display) |
| $UserColActionSortNoIndicator | 2 | Sort (hide sort indicator) |
| $UserColActionAutoSize | 3 | Automatically adjust column width |
Specifying $UserColActionSort , $UserColActionSortNoIndicator allows the user to sort by clicking on the column header. Sorting is done for the entire spreadsheet, keyed by one particular column. Detailed settings can be made by combining with the ColUserSortIndicator property.
If you specify $UserColActionAutoSize , double-clicking the column header will adjust the column width.
Related item ColUserSortIndicator property