DataSorterKey

DataSorterKey class

Represents the key of the data sorter.

Properties

NameTypeDescription
OrderNumberIndicates the order of sorting. The value of the property is SortOrder integer constant.
IndexNumberGets the sorted column index(absolute position, column A is 0, B is 1, …).
TypeNumberRepresents the type of sorting. The value of the property is SortOnType integer constant.
IconSetTypeNumberRepresents the icon set type. The value of the property is IconSetType integer constant. Only takes effect when Type is
IconIdNumberRepresents 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: Number

DataSorterKey.Index property

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

Type: Number

DataSorterKey.Type property

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

Type: Number

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: Number

DataSorterKey.IconId property

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

Type: Number

DataSorterKey.Color property

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

Type: Color