Return to previous page Explore Spreadsheet SDK

RangeSort Method (String, SortOrder, String, SortOrder, String, SortOrder, Boolean, SortOrientation, SortDataOption, SortDataOption, SortDataOption)

Free Trial Web API version Licensing Request A Quote

HAVE QUESTIONS OR NEED HELP?SUBMIT THE SUPPORT REQUEST FORM or write email toSUPPORT@BYTESCOUT.COM

Sorts a range.

Namespace:Bytescout.Spreadsheet
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.0.2045-master

Syntax

C++

Copy

public void Sort(
	string Key1,
	SortOrder Order1,
	string Key2,
	SortOrder Order2,
	string Key3,
	SortOrder Order3,
	bool MatchCase,
	SortOrientation Orientation,
	SortDataOption DataOption1,
	SortDataOption DataOption2,
	SortDataOption DataOption3
)

Public Sub Sort ( 
	Key1 As String,
	Order1 As SortOrder,
	Key2 As String,
	Order2 As SortOrder,
	Key3 As String,
	Order3 As SortOrder,
	MatchCase As Boolean,
	Orientation As SortOrientation,
	DataOption1 As SortDataOption,
	DataOption2 As SortDataOption,
	DataOption3 As SortDataOption
)

public:
void Sort(
	String^ Key1, 
	SortOrder Order1, 
	String^ Key2, 
	SortOrder Order2, 
	String^ Key3, 
	SortOrder Order3, 
	bool MatchCase, 
	SortOrientation Orientation, 
	SortDataOption DataOption1, 
	SortDataOption DataOption2, 
	SortDataOption DataOption3
)

member Sort : 
        Key1 : string * 
        Order1 : SortOrder * 
        Key2 : string * 
        Order2 : SortOrder * 
        Key3 : string * 
        Order3 : SortOrder * 
        MatchCase : bool * 
        Orientation : SortOrientation * 
        DataOption1 : SortDataOption * 
        DataOption2 : SortDataOption * 
        DataOption3 : SortDataOption -> unit

Parameters

Key1: Type: SystemString
The first sort field.
Order1: Type: Bytescout.Spreadsheet.ConstantsSortOrder
The sort order for the field specified in Key1.
Key2: Type: SystemString
The second sort field.
Order2: Type: Bytescout.Spreadsheet.ConstantsSortOrder
The sort order for the field specified in Key2.
Key3: Type: SystemString
The third sort field.
Order3: Type: Bytescout.Spreadsheet.ConstantsSortOrder
The sort order for the field specified in Key3.
MatchCase: Type: SystemBoolean
if set to true to do a case-sensitive sort.
Orientation: Type: Bytescout.Spreadsheet.ConstantsSortOrientation
The sort orientation.
DataOption1: Type: Bytescout.Spreadsheet.ConstantsSortDataOption
Specifies how to sort text in Key1.
DataOption2: Type: Bytescout.Spreadsheet.ConstantsSortDataOption
Specifies how to sort text in Key2.
DataOption3: Type: Bytescout.Spreadsheet.ConstantsSortDataOption
Specifies how to sort text in Key3.

Reference

Range Class

Sort Overload

Bytescout.Spreadsheet Namespace