2.4.226 BrtBeginSortState
The BrtBeginSortState record specifies sort properties and specifies the beginning of a collection of records as specified by the Worksheet part ABNF (section 2.1.7.62), the Macro Sheet (section 2.1.7.32) part ABNF, the Table (section 2.1.7.51) part ABNF, and the Query Table (section 2.1.7.42) part ABNF. The collection of records specifies the different sort conditions that apply to a range.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
C |
unused |
rfx (16 bytes) |
|||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
A - fCol (1 bit): A bit that specifies whether to sort by rows or columns (1). If AutoFilter is applied to the range, then fCol MUST be ignored. Possible values for this field are listed in the following table.
-
Value
Meaning
0
Sort by rows
1
Sort by columns (1)
B - fCaseSensitive (1 bit): A bit that specifies whether the sort is case-sensitive.
C - fAltMethod (1 bit): A bit that specifies whether to use a sorting method other than character order such as stroke order or Mandarin phonetic symbols. Possible values for this field are listed in the following table.
-
Value
Meaning
0
Sort using character order.
1
Sort using a method other than character order.
-
unused (13 bits): This value is undefined and MUST be ignored.
rfx (16 bytes): An UncheckedRfX (section 2.5.154) that specifies the range to sort.