2.4.188 BrtBeginQSIF
The BrtBeginQSIF record specifies properties of a single field of a query table and specifies the beginning of an empty collection of records as defined by the Query Table (section 2.1.7.42) part ABNF.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
C |
D |
E |
reserved |
||||||||||||||||||||||||||
|
idField |
|||||||||||||||||||||||||||||||
|
idlstf |
|||||||||||||||||||||||||||||||
|
irstName (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
A - fUserIns (1 bit): A bit that specifies whether this field is a user-defined field or comes from the external connection (section 2.2.8). User-defined fields are preserved during data refresh operations.
B - fFillDown (1 bit): A bit that specifies whether the formula (section 2.2.2) in this field is filled down on data refresh. A value of 1 specifies that formulas is filled down. If this value is 1, fUserIns MUST be equal to 1.
C - fRowNums (1 bit): A bit that specifies whether this field contains row numbers for the records returned. A value of 1 indicates that the field will contain row numbers. If this value is 1, fUserIns MUST be equal to 0.
D - fClipped (1 bit): A bit that specifies whether this field is currently clipped and is not visible in the sheet. A value of 1 specifies that this field is clipped. If this value is equal to 1, fUserIns MUST be equal to 0.
E - fIrstName (1 bit): A bit that specifies whether this record contains irstName.
reserved (27 bits): This value MUST be 0 and MUST be ignored.
idField (4 bytes): A QsiFieldId (section 2.5.112) that specifies the unique identifier of this query table field. This value MUST be unique within this query table.
idlstf (4 bytes): An unsigned integer that specifies the identifier of the table field if this query table field is attached to a table object rather than a range in the sheet. This value MUST be equal to 0 if the query table field is not attached to a table field; otherwise this value MUST be equal to the idField field on a BrtBeginListCol (section 2.4.101) record within the table associated with this query table and this record's idField field MUST be equal to the idqsif of that BrtBeginListCol record.
irstName (variable): An XLWideString (section 2.5.169) specifying the name of this query table field. If fIrstName is equal to 0, irstName MUST NOT be present. If fIrstName is equal to 1, irstName MUST be present. This string MUST be less than or equal to 255 characters in length.