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) |