DV: Data Validation Criteria (1BEh)

This record stores data validation criteria for a range of cells.

Record Data — BIFF8

Offset

Name

Size

Contents

4

dwDvFlags

4

Option flags; see following table

8

rgb

var

Array of data validation criteria (see text) followed by Title, Prompt, and Error sts, Min and Max rgces, and cref REFs


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

Bits

Mask

Name

Contents

3 – 0

0000000Fh

ValType

Validation type

6v4

00000070h

ErrStyle

Error alert style

7

00000080h

fStrLookup

= 1 if this is list-type validation with an explicitly expressed list of valid inputs

8

00000100h

fAllowBlank

= 1 suppress an error when any cell referenced by the validation formula is blank

9

00000200h

fSuppressCombo

= 1 if this is list-type validation, with no drop-down to be displayed in the cell when selected

17 – 10

0003FC00h

mdImeMode

The IME mode to be used for this cell (Far East versions only)

18

00040000h

fShowInputMsg

= 1 show input message box

19

00080000h

fShowErrorMsg

= 1 show error message box

23 – 20

00F00000h

typOperator

Operator type

31 – 24

FF000000h

Reserved

Reserved; must be 0 (zero)