2.4.208 Qsi
The Qsi record specifies properties for a query table, and specifies the beginning of a collection of records as defined by the Worksheet Substream ABNF. The collection of records specifies additional information for the query table.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
itblAutoFmt |
|||||||||||||||||
|
O |
P |
Q |
R |
S |
T |
unused3 |
reserved |
||||||||||||||||||||||||
|
... |
rgchName (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
unused4 |
|||||||||||||||||||||||||||||||
A - fTitles (1 bit): A bit that specifies whether the first row of the query table contains column titles.
B - fRowNums (1 bit): A bit that specifies whether the first column of the query table displays row numbers.
C - fDisableRefresh (1 bit): A bit that specifies whether the query table can be refreshed.
-
Value
Meaning
0
The query table can be refreshed.
1
The query table cannot be refreshed.
D - fAsync (1 bit): A bit that specifies whether the query table refreshes data asynchronously. MUST be set to 1 if fNewAsync field is set to1.
E - fNewAsync (1 bit): A bit that specifies whether data has been refreshed for this query table. MUST be set to 0 if fAsync field is set to 0.
-
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. MUST be one of the following.
-
Value
Meaning
0
Unused cells are to be cleared.
1
Unused cells are to be deleted
H - fFill (1 bit): A bit that specifies whether formulas in columns adjacent to the query table are filled down whenever the query table is refreshed.
I - fAutoFormat (1 bit): A bit that is unused and SHOULD be set to zero<105>.
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. MUST be one of the following:
-
Value
Meaning
0x0
Data in the query table will not be saved
0x1
Data in the query table will be saved
K - fDisableEdit (1 bit): A bit that specifies whether the content used with this query table is editable.
-
Value
Meaning
0
Content is editable
1
Content is locked
L - unused1 (2 bits): Undefined and MUST be ignored.
M - 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. MUST be one of the following.
-
Value
Meaning
0
Insert new cells for new data
1
Overwrite existing cells for new data
N - unused2 (2 bits): Undefined and MUST be ignored.
itblAutoFmt (2 bytes): An AutoFmt8 that specifies the AutoFormat to be applied to the query table. MUST be less than or equal to 0x0014.
O - fibitAtrNum (1 bit): A bit that specifies whether numeric cell data is formatted according to the style specified in itblAutoFmt field.
P - fibitAtrFnt (1 bit): A bit that specifies whether cell text is formatted according to the style specified in itblAutoFmt field.
Q - fibitAtrAlc (1 bit): A bit that specifies whether cell text alignment is set according to the style specified in itblAutoFmt field.
R - fibitAtrBdr (1 bit): A bit that specifies whether border is set according to the style specified in itblAutoFmt field.
S - fibitAtrPat (1 bit): A bit that specifies whether the pattern is formatted according to the style specified in itblAutoFmt field.
T - fibitAtrProt (1 bit): A bit that specifies whether the cell is protected according to the style specified in itblAutoFmt field.
unused3 (10 bits): Undefined and MUST be ignored.
reserved (4 bytes): MUST be zero, and MUST be ignored.
rgchName (variable): A XLUnicodeString string that specifies the name of the query table. The number of characters in this array MUST be less than 0x00FF. Within this workbook, there MUST be a defined name as specified by an Lbl record with its fHidden field equal to 1 and its Name field matching this field’s value and the rgce field only containing a PtgArea3d referencing the range of cells for the query table fields. Spaces within rgchName are converted to underscores for the purposes of this comparison.
unused4 (2 bytes): Undefined and MUST be ignored.