DataSorter Class

DataSorter class

Summary description for DataSorter.

type DataSorter struct  {
	ptr unsafe.Pointer
}

Constructors

Method	Description

Methods

Method	Description
IsNull	Checks whether the implementation object is nullptr.
GetKeys	Gets the key list of data sorter.
Clear	Clear all settings.
GetHasHeaders	Represents whether the range has headers.
SetHasHeaders	Represents whether the range has headers.
AddKey_Int_SortOrder	Adds sorted column index and sort order.
AddKey_Int_SortOrder_String	Adds sorted column index and sort order with custom sort list.
AddColorKey	Adds color sort key.
AddKey_Int_SortOnType_SortOrder_Object	Adds sorted column index and sort order with custom sort list.
AddKey_Int_SortOrder_stringArray	Adds sorted column index and sort order with custom sort list.
GetKey1	Represents first sorted column index(absolute position, column A is 0, B is 1, …).
SetKey1	Represents first sorted column index(absolute position, column A is 0, B is 1, …).
GetOrder1	Represents sort order of the first key.
SetOrder1	Represents sort order of the first key.
GetKey2	Represents second sorted column index(absolute position, column A is 0, B is 1, …).
SetKey2	Represents second sorted column index(absolute position, column A is 0, B is 1, …).
GetOrder2	Represents sort order of the second key.
SetOrder2	Represents sort order of the second key.
GetKey3	Represents third sorted column index(absolute position, column A is 0, B is 1, …).
SetKey3	Represents third sorted column index(absolute position, column A is 0, B is 1, …).
GetOrder3	Represents sort order of the third key.
SetOrder3	Represents sort order of the third key.
GetSortLeftToRight	True means that sorting orientation is from left to right.False means that sorting orientation is from top to bottom.The default value is false.
SetSortLeftToRight	True means that sorting orientation is from left to right.False means that sorting orientation is from top to bottom.The default value is false.
GetCaseSensitive	Gets and sets whether case sensitive when comparing string.
SetCaseSensitive	Gets and sets whether case sensitive when comparing string.
GetSortAsNumber	Indicates whether sorting anything that looks like a number.
SetSortAsNumber	Indicates whether sorting anything that looks like a number.
Sort_Cells_Int_Int_Int_Int	Sorts the data of the area.
Sort_Cells_CellArea	Sort the data of the area.
Sort	Sort the data in the range.