Page History

...

Signature

	C#
	C#

public void IFunction
{
    FunctionValue Calculate(IList<FunctionValue> args, Cell currentCell);
}

Parameters

Param

0	columnIndex

An integer representing the column you would like to sort the area by.

Param

0	isAscending

A boolean representing whether you want to sort the area in ascending or descending order.

Param

0	hasHeader

A booleanrepresenting whether or not the area you want to sort contains a header row.

Example

Code Block

	csharp
	csharp
title	C#

//Sort area with headers by the first column ascending 
Area a = WB[0].CreateArea("A1:C6");
a.Sort(0, true, true);
            
//Sort area with headers by first column descending
Area b = WB[0].CreateArea("A10:C15");
b.Sort(0, false, true);
            
//Sort area without headers by the first column ascending
Area c = WB[0].CreateArea("E2:G6");
c.Sort(0, true, false);
            
//Sort area without headers by the first column descending
Area d = WB[0].CreateArea("E11:G15");
d.Sort(0, false, false);

Code Block

	vbnet
	vbnet
title	vb.net

'Sort area with headers by the first column ascending 
Dim a As Area = WB(0).CreateArea("A1:C6")
a.Sort(0, True, True)


'Sort area with headers by first column descending
Dim b As Area = WB(0).CreateArea("A10:C15")
b.Sort(0, False, True)


'Sort area without headers by the first column ascending
Dim c As Area = WB(0).CreateArea("E2:G6")
c.Sort(0, True, False)


'Sort area without headers by the first column descending
Dim d As Area = WB(0).CreateArea("E11:G15")
d.Sort(0, False, False)

Space Shortcuts

Page tree

Versions Compared

Old Version 4

New Version 5

Key