Spread Windows Forms 6.0 Product Documentation
SetColumnSortIndicator Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : SetColumnSortIndicator Method

Index of column to set
SortIndicator enumeration setting

Glossary Item Box

Sets the sort indicator for the specified column on this sheet.


Visual Basic (Declaration) 
Public Sub SetColumnSortIndicator( _
   ByVal column As Integer, _
   ByVal order As SortIndicator _
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim column As Integer
Dim order As SortIndicator
instance.SetColumnSortIndicator(column, order)
public void SetColumnSortIndicator( 
   int column,
   SortIndicator order


Index of column to set
SortIndicator enumeration setting


The SheetView.SetColumnShowSortIndicator method and the Column.ShowSortIndicator property set whether the column shows the sort indicator the next time that the SheetView.AutoSortColumns method is called for that column. It has no effect until AutoSortColumns is called for that column index.

If you want to change the sort indicator shown for a column, use the SheetView.SetColumnSortIndicator method or the Column.SortIndicator property. These change the sort indicator in the column header and do not affect whether the column is sorted or not.


This example illustrates the use of this member by returning the sort indicator for the specified column header.
C#Copy Code
fpSpread1.ActiveSheet.SetColumnSortIndicator(0, FarPoint.Win.Spread.Model.SortIndicator.Descending); 
FarPoint.Win.Spread.Model.SortIndicator si;
si = fpSpread1.ActiveSheet.GetColumnSortIndicator(0);
Visual BasicCopy Code
FpSpread1.ActiveSheet.SetColumnSortIndicator(0, FarPoint.Win.Spread.Model.SortIndicator.Descending)
Dim si As FarPoint.Win.Spread.Model.SortIndicator
si = FpSpread1.ActiveSheet.GetColumnSortIndicator(0)


Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.