Spread 8.0 Documentation
ActiveX
Support Options

Glossary Item Box

ActiveX


To allow users to sort columns

  1. If you want to prevent the user from sorting on a specific column, set the ColUserSortIndicator property as follows.
    1. Specify the column number using the Col parameter.
    2. Set the property to 3 (Disabled).
  2. Set the UserColAction property to one of the following values to specify what action to perform when the user clicks any column header:
    • If you want the column to be sorted when the user clicks a column header and to display the sort indicator, set the UserColAction property to 1 (Sort).
    • If you want the column to be sorted when the user clicks a column header and to not display the sort indicator, set the UserColAction property to 2 (SortNoIndicator).
  3. If your sheet displays multiple headers and you want the sort indicator to display in a row other than the bottom-most header row, specify which column header row will display the indicator by setting the ColHeadersUserSortIndex property.
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.