Export (0) Print
Expand All
Expand Minimize

2.4.264 SortData

Office

The SortData record specifies data used for sorting a range.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

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.

Show:
© 2014 Microsoft