|
The SetSort DataWindow method lets you specify a case-sensitive or case-insensitive sort explicitly.
Usage
SetSort takes a valid format expression as an argument. The format is made up of a column name or number followed by an optional order. The following table shows the recognized values for order. The values themselves are case insensitive. For example, as, s, AS, or S all specify a case-sensitive sort in ascending order
|
Order value
|
Resulting sort order
|
|
Case-insensitive ascending
|
Case-insensitive ascending
|
|
d, desc, descending, di
|
Case-insensitive descending
|
|
as, s
|
Case-sensitive ascending
|
|
ds
|
Case-sensitive descending
|
|
. |
