DataSorterKey

DataSorterKey class

Represents the key of the data sorter.

Properties

NameTypeDescription
OrderintIndicates the order of sorting. The value of the property is SortOrder integer constant.
IndexintGets the sorted column index(absolute position, column A is 0, B is 1, …).
TypeintRepresents the type of sorting. The value of the property is SortOnType integer constant.
IconSetTypeintRepresents the icon set type. The value of the property is IconSetType integer constant. Only takes effect when Type is
IconIdintRepresents the id of the icon set type. Only takes effect when Type is SortOnType.ICON .
ColorColorGets the sorted color. Only takes effect when Type is SortOnType.CELL_COLOR or SortOnType.FONT_COLOR .

DataSorterKey.Order property

Indicates the order of sorting. The value of the property is SortOrder integer constant.

Type: int

DataSorterKey.Index property

Gets the sorted column index(absolute position, column A is 0, B is 1, …).

Type: int

DataSorterKey.Type property

Represents the type of sorting. The value of the property is SortOnType integer constant.

Type: int

DataSorterKey.IconSetType property

Represents the icon set type. The value of the property is IconSetType integer constant. Only takes effect when Type is SortOnType.ICON .

Type: int

DataSorterKey.IconId property

Represents the id of the icon set type. Only takes effect when Type is SortOnType.ICON .

Type: int

DataSorterKey.Color property

Gets the sorted color. Only takes effect when Type is SortOnType.CELL_COLOR or SortOnType.FONT_COLOR .

Type: Color