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.


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

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.