2.4.187 BrtBeginQSI
The BrtBeginQSI record specifies properties of a query table and specifies the beginning of a collection of records as defined by the Query Table (section 2.1.7.42) part ABNF. The collection of records specifies a query table.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
O |
P |
Q |
R |
S |
T |
unused |
|||||||||||
|
itblAutoFmt |
dwConnID |
||||||||||||||||||||||||||||||
|
... |
irstName (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
A - fTitles (1 bit): A bit that specifies whether the first row of the query table contains column (1) titles.
B - fRowNums (1 bit): A bit that specifies whether the first column (1) of the query table displays row numbers.
C - fDisableRefresh (1 bit): A bit that specifies whether the query table can be refreshed. The possible values for this field are listed in the following table.
-
Value
Meaning
0x0
The query table can be refreshed.
0x1
The query table cannot be refreshed.
D - fAsync (1 bit): A bit that specifies whether the query table refreshes data asynchronously. This value MUST be set to 1 if fNewAsync field is set to 1.
E - fNewAsync (1 bit): A bit that specifies whether data has been refreshed for this query table. This value MUST be set to 0 if fAsync field is set to 0. The possible values for this field are listed in the following table.
-
Value
Meaning
0
The first background data refresh was finished at the time the file was saved.
1
The first background data refresh was not finished at the time the file was saved.
F - fAutoRefresh (1 bit): A bit that specifies whether the query table refreshes its data automatically when the document is opened.
G - fShrink (1 bit): A bit that specifies the behavior when dealing with a variable number of rows of data in the query table between refresh operations. If fOverwrite is 1, this value MUST be 0. This value MUST be a value from the following table.
-
Value
Meaning
0
Unused cells are to be cleared.
1
Unused cells are to be deleted.
H - fOverwrite (1 bit): A bit that specifies the behavior when dealing with a variable number of rows of data in the query table between refresh operations. If fShrink is 1, this value MUST be 0. This value MUST be a value from the following table.
-
Value
Meaning
0
Insert new cells for new data.
1
Overwrite existing cells for new data.
I - fFill (1 bit): A bit that specifies whether formula (section 2.2.2) in columns (1) adjacent to the query table are filled down whenever the query table is refreshed.
J - fSaveData (1 bit): A bit that specifies whether the query table preserves all of its data in the sheet when the document is saved. This value MUST be a value from the following table.
-
Value
Meaning
0
Data in the query table will not be saved.
1
Data in the query table will be saved.
K - fDisableEdit (1 bit): A bit that specifies whether the cell content in the query table is editable. The possible values for this field are listed in the following table.
-
Value
Meaning
0
Content is editable.
1
Content is locked.
L - fPreserveFmt (1 bit): A bit that specifies whether the application will preserve formatting in the query table and copy this formatting to new rows of data added to the query table.
M - fAutoFit (1 bit): A bit that specifies whether column (1) widths are automatically adjusted on refresh to fit the data retrieved.
N - fDummyList (1 bit): A bit that specifies whether this query table has not been fully formed and populated with data.
O - ibitAtrNum (1 bit): A bit that specifies whether numeric cell data is formatted according to the style specified in itblAutoFmt field.
P - ibitAtrFnt (1 bit): A bit that specifies whether cell text is formatted according to the style specified in itblAutoFmt field.
Q - ibitAtrAlc (1 bit): A bit that specifies whether cell text alignment is set according to the style specified in itblAutoFmt field.
R - ibitAtrBdr (1 bit): A bit that specifies whether border is set according to the style specified in itblAutoFmt field.
S - ibitAtrPat (1 bit): A bit that specifies whether the cell background is formatted according to the style specified in itblAutoFmt field.
T - ibitAtrProt (1 bit): A bit that specifies whether the cell is protected according to the style specified in itblAutoFmt field.
unused (12 bits): This value is undefined and MUST be ignored.
itblAutoFmt (2 bytes): An AutoFormatID (section 2.5.4) that specifies the AutoFormat to be applied to the query table. This value MUST be less than or equal to 0x0014.
dwConnID (4 bytes): An unsigned integer that specifies the identifier number of the external connection (section 2.2.8) to use to refresh data in the query table. This value MUST be greater than 0 and MUST be equal to dwConnID in one of the BrtBeginExtConnection (section 2.4.80) records in the External Data Connections (section 2.1.7.24) part.
irstName (variable): An XLWideString (section 2.5.169) that specifies the unique name of this query table. Within this workbook (section 2.1.7.61), there MUST be a defined name as specified by a BrtName (section 2.4.711) record with its fHidden field equal to 1 and its name field matching this field's value and its formula.rgce field only containing a PtgArea3d (section 2.5.98.19) referencing the range of cells for the query table fields. Spaces within irstName are converted to underscores for the purposes of this comparison.