QSI: External Data Range (1ADh)

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)