DVAL: Data Validation Information (1B2h)

This record stores data validation information.

Record Data — BIFF8

Offset

Name

Size

Contents

4

wDviFlags

2

Option flags; see following table

6

xLeft

4

The x coordinate of the input window

10

yTop

4

The y coordinate of the input window

14

idObj

4

For a list with in-cell drop-down, the object id of drop-down OBJ record

18

idvMac

4

Number of DV records that follow


The wDviFlags field contains the option flags listed in the following table.

Bits

Mask

Name

Contents

0

0001h

fWnClosed

= 1 the input window has been closed

1

0002h

fWnPinned

= 1 the input window is pinned in place

2

0004h

fCached

= 1 if information about a cell's data validation has been cached

15 – 3

FFF8h

(Reserved)

Reserved; must be 0 (zero)