See Also

IRange Interface  | IRange Members

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

Language

Visual Basic

C#

C++

C++/CLI

Show All

orientation
Specifies whether to sort rows or columns.
caseSensitive
Specifies whether sorting should be case sensitive.
keys
Specifies an array of sort keys.
See Also Languages SpreadsheetGear The Performance Spreadsheet Component Company 

Sort Method

SpreadsheetGear Namespace > IRange Interface : Sort Method

Sorts the cells represented by this range according to the specified options.

[Visual Basic]
Overridable Sub Sort( _    ByVal orientation As SortOrientation, _    ByVal caseSensitive As Boolean, _    ByVal ParamArray keys() As SortKey _ )
[C#]
virtual void Sort(    SortOrientation orientation,    bool caseSensitive,    params SortKey[] keys );
[C++]
virtual void Sort(    SortOrientation orientation,    bool caseSensitive,    params SortKey*[]* keys )
[C++/CLI]
virtual void Sort(    SortOrientation orientation,    bool caseSensitive,    ... SortKey^array<keys>^ keys )

Parameters

orientation
Specifies whether to sort rows or columns.
caseSensitive
Specifies whether sorting should be case sensitive.
keys
Specifies an array of sort keys.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IRange Interface  | IRange Members

 

 


See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.