This record stores an external data range.
Record Data — BIFF8
Offset |
Name |
Size |
Contents |
4 |
grbit |
2 |
Option flags; see following table. |
6 |
itblAutoFmt |
2 |
Index to autoformat table. |
8 |
grbitAtrAutoFmt |
2 |
Low-order 6 bits contain autoformat attribute flag bits; the high-order 10 bits are reserved. |
10 |
Reserved |
4 |
Reserved; must be 0 (zero). |
14 |
cchName |
1 |
Length of name. |
15 |
rgchName |
var |
Name string. |
The grbit field contains the option flags listed in the following table.
Bits |
Mask |
Name |
Contents |
0 |
0001h |
fTitles |
= 1 if the range contains titles |
1 |
0002h |
fRowNums |
= 1 if the range uses row numbers |
2 |
0004h |
fDisableRefresh |
= 1 if refresh is disabled |
6 – 3 |
0078h |
Reserved |
Reserved; must be 0 (zero) |
7 |
0080h |
fFill |
= 1 if the range has a fill applied |
8 |
0100h |
fAutoFormat |
= 1 if the range has an autoformat applied |
9 |
0200h |
Reserved |
Reserved; must be 0 (zero) |
10 |
0400h |
fDisableEdit |
= 1 if the cells are locked for editing |
15 – 11 |
F800h |
Reserved |
Reserved; must be 0 (zero) |