2.4.209 Qsif
The Qsif record specifies the properties for a query table field. One Qsif record is stored for each query table field.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
frtHeaderOld |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
iSortKey |
D |
E |
F |
G |
H |
reserved3 |
||||||||||||||||||||||
|
idField |
|||||||||||||||||||||||||||||||
|
idList (optional) |
|||||||||||||||||||||||||||||||
|
rgbTitle (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
frtHeaderOld (4 bytes): An FrtHeaderOld structure. The frtHeaderOld.rt field MUST be 0x0807.
A - fUserIns (1 bit): A bit that specifies whether this column was inserted into the query table.
-
Value
Meaning
0
The column is from the external data source.
1
The column was inserted into the query table and is not from the external data source.
B - fFillDown (1 bit): A bit that specifies whether the formula (section 2.2.2) in this query table field is filled down on data refresh.
C - fSortDes (1 bit): A bit that specifies whether this query table field is sorted in descending order if it is included as part of a sort range.
iSortKey (8 bits): An unsigned integer that specifies the position of this query table field in the sort range. MUST be a value from the following table:
-
Value
Axis Description
0
This query table field does not contain sort criteria.
1
This query table field contains sort criteria for the first sort key as specified in the Sort record.
2
This query table field contains sort criteria for the second sort key as specified in the Sort record.
3
This query table field contains sort criteria for the third sort key as specified in the Sort record.
-
D - fRowNums (1 bit): A bit that specifies whether this query table field contains the row numbers for the data from the external data source.
E - reserved1 (1 bit): MUST be zero, and MUST be ignored.
F - fSorted (1 bit): A bit that specifies whether this query table field is part of a sort range.
G - reserved2 (2 bits): MUST be zero, and MUST be ignored.
H - fClipped (1 bit): A bit that specifies whether this query table field is currently outside the sheet bounds as specified in the cell table. If the fUserIns field is set to 1, this field MUST be set to 0.
reserved3 (15 bits): MUST be zero, and MUST be ignored.
idField (4 bytes): An unsigned integer that specifies a unique identifier of this query table field in the query table. MUST be greater than or equal to 0x0001 and less than or equal to 0xFFFF.
idList (4 bytes): An optional unsigned integer that specifies the value corresponding to the idList field of the TableFeatureType structure that is linked with this query table. This field exists only if the verLastXLSaved field of the BOF records is greater than or equal to 0x4.
rgbTitle (variable): An XLUnicodeString string that specifies the name of the query table field. The length of the query table field MUST less than or equal to 0x00FF.