DataSorter Properties

The DataSorter type exposes the following members.

Properties
  NameDescription
Public propertyCaseSensitive
Gets and sets whether case sensitive when comparing string.
Public propertyHasHeaders
Represents whether the range has headers.
Public propertyKey1
Represents first sorted column index(absolute position, column A is 0, B is 1, ...).
Public propertyKey2
Represents second sorted column index(absolute position, column A is 0, B is 1, ...).
Public propertyKey3
Represents third sorted column index(absolute position, column A is 0, B is 1, ...).
Public propertyKeys
Gets the key list of data sorter.
Public propertyOrder1
Represents sort order of the first key.
Public propertyOrder2
Represents sort order of the second key.
Public propertyOrder3
Represents sort order of the third key.
Public propertySortAsNumber
Indicates whether sorting anything that looks like a number.
Public propertySortLeftToRight
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.
See Also