SORT: Sorting Options (90h)

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)