2.4.264 SortData
The SortData record specifies data used for sorting a range.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
frtHeader |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
sfp |
unused |
rfx (16 bytes) |
||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
cconditions |
||||||||||||||||||||||||||||||
|
... |
idParent |
||||||||||||||||||||||||||||||
|
... |
sortCond12Array (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
frtHeader (12 bytes): An FrtHeader structure. The frtHeader.rt field MUST be 0x0895.
A - fCol (1 bit): A bit that specifies whether to sort by columns or rows. MUST be one of the values from the following table:
-
Value
Meaning
0x0
Sort by rows.
0x1
Sort by columns.
B - fCaseSensitive (1 bit): A bit that specifies whether to use a case-sensitive sorting method. MUST be one of the values from the following table:
-
Value
Meaning
0x0
The sort is not case-sensitive.
0x1
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. MUST be one of the values from the following table:
-
Value
Meaning
0x0
The sort uses character order.
0x1
The sort uses a method other than character order.
sfp (3 bits): An unsigned integer that specifies the type of the object that contains the sort field. MUST be a value from the following table:
-
-
-
-
Value
Meaning
0x0
The sort field is contained in a sheet.
0x1
The sort field is contained in a table.
0x2
The sort field is contained in an AutoFilter.
0x3
The sort field is contained in a query table.
-
-
-
unused (10 bits): Undefined and MUST be ignored.
rfx (16 bytes): An RFX structure that specifies the range to sort.
cconditions (4 bytes): An unsigned integer that specifies the count of sort conditions. This record MUST be followed by one ContinueFrt12 record for each sort condition.
idParent (4 bytes): An unsigned integer that specifies the identifier of the object that contains the sort field, if the sfp field is 0x1 or 0x3. If the sfp field is equal to 0x1, the value of this field MUST be equal to the idList field of the associated TableFeatureType. If the sfp field is equal to 0x3, the value of this field MUST be equal to the zero-based index of the associated query table (Qsi) in the Qsi records in the current substream. If the sfp field is equal to 0x0 or 0x2, this is undefined and MUST be ignored.
sortCond12Array (variable): An array of SortCond12 structures that specifies the sort conditions.