This record stores options from the Sort and Sort Options dialog boxes.
Record Data
|
Offset |
Name |
Size |
Contents |
|
4 |
grbit |
2 |
Option flags |
|
6 |
cchKey1 |
1 |
Length of the string for sort key 1 |
|
7 |
cchKey2 |
1 |
Length of the string for sort key 2 |
|
8 |
cchKey3 |
1 |
Length of the string for sort key 3 |
|
9 |
rgchKey1 |
var |
String for sort key 1 |
|
var |
rgchKey2 |
var |
String for sort key 2 |
|
var |
rgchKey3 |
var |
String for sort key 3 |
The grbit field contains the option flags listed in the following table.
|
Offset |
Bits |
Mask |
Name |
Contents | |
|
0 |
0 |
0001h |
fCol |
= 1 if the Sort Left To Right option is on. | |
|
1 |
0002h |
fKey1Dsc |
= 1 if key 1 sorts in descending order. | ||
|
2 |
0004h |
fKey2Dsc |
= 1 if key 2 sorts in descending order. | ||
|
3 |
0008h |
fKey3Dsc |
= 1 if key 3 sorts in descending order. | ||
|
4 |
0010h |
fCaseSensitive |
= 1 if the sort is case-sensitive. | ||
|
9 – 5 |
03E0h |
iOrder |
Index to the table in the First Key Sort Order option. The Normal sort order corresponds to iOrder = 0. | ||
|
10 |
0400h |
fAltMethod |
Used only in Far East versions of Microsoft Excel. | ||
|
15 – 11 |
F800h |
(Reserved) | |||