2.4.354 BrtDVal14

The BrtDVal14 record specifies data validation for a range on this sheet. This record is equivalent to BrtDval (section 2.4.353) but allows for more than 8,192 ranges to which data validation is applied.

FRTHeader (variable): An FRTHeader (section 2.5.61) that specifies the future record (section 2.1.6) information for this record.

The FRTHeader flags MUST have the values listed in the following table.

Field	Value
FRTHeader.fRef	0
FRTHeader.fSqref	1
FRTHeader.fFormula	0 or 1
FRTHeader.fRelID	0

The FRTHeader.fFormula MUST be 0 if fDVMinFmla equals 0 and fDVMaxFmla equals 0.

The FRTHeader.fFormula MUST be 1 if fDVMinFmla equals 1 or fDVMaxFmla equals 1.

The sqrfx of the single FRTSqref (section 2.5.66) comprising the array of the FRTHeader.rgSqrefs specifies the ranges to which data validation is applied. The rgSqrefs.csqref MUST equal 1. The sqrfx.crfx of the single FRTSqref comprising the array of the rgSqrefs MUST be greater than or equal to 1.

The value of FRTHeader.rgFormulas.cformula MUST be equal to the sum of fDVMinFmla + fDVMaxFmla.

If fDVMinFmla is 1, the FRTFormula (section 2.5.59) of the first FRTDVParsedFormula14 (section 2.5.58) comprising the array of the FRTHeader.rgFormulas specifies the first formula (section 2.2.2) for the data validation. The following MUST be true:

• If typOperator is equal to 0 or 1 and valType is not 0, 3, or 7, then this formula is used as the lesser of two bounding values and frtformula.formula.cce MUST be greater than or equal to 1.

• If typOperator is greater than or equal to 2 or valType is equal to 3 or 7, then this formula is the only formula for those cases, and frtformula.formula.cce MUST be greater than or equal to 1.

If fDVMaxFmla is 1, the frtformula of the last FRTDVParsedFormula14 (section 2.5.58) comprising the array of the FRTHeader.rgFormulas specifies the second formula (section 2.2.2) for the data validation. The following MUST be true:

• If typOperator is equal to 0 or 1 and valType is not 0, 3, or 7, then this formula is used as the greater of two bounding values and frtformula.formula.cce MUST be greater than or equal to 1.

valType (4 bits):  An unsigned integer that specifies the type of data validation. This value MUST be a value from the following table.

Value	Meaning
0x00	Specifies that the data validation allows any type of value and does not check for a type or range of values.
0x01	Specifies that the data validation checks for and allows whole number values satisfying the given condition.
0x02	Specifies that the data validation checks for and allows decimal values satisfying the given condition.
0x03	Specifies that the data validation checks for and allows a value that matches one in a list of values.
0x04	Specifies that the data validation checks for and allows date values satisfying the given condition.
0x05	Specifies that the data validation checks for and allows time values satisfying the given condition.
0x06	Specifies that the data validation checks for and allows text values whose length satisfies the given condition.
0x07	Specifies that the data validation uses a custom formula (section 2.2.2) to check the cell value.

A - errStyle (3 bits): An unsigned integer that specifies the style of error alert used for this data validation. This value MUST be a value from the following table.

Value	Meaning
0x00	Specifies that the data validation error style uses a stop icon in the error alert.
0x01	Specifies that the data validation error style uses a warning icon in the error alert.
0x02	Specifies that the data validation error style uses an information icon in the error alert.

B - unused (1 bit): This value is undefined, and MUST be ignored.

C - fAllowBlank (1 bit): A bit that specifies whether the data validation treats empty or blank entries as valid.

D - fSuppressCombo (1 bit): A bit that specifies the behavior of the drop-down combo box. Possible values for this field are listed in the following table.

Value of fSuppressCombo	Value of valType	Meaning
0	3	Displays the dropdown combo box.
1	3	Suppresses the dropdown combo box.

mdImeMode (8 bits): An unsigned integer that specifies the Input Method Editor (IME) mode enforced by this data validation. This value MUST be a value from the following table.

Value	IME Mode
0x00	No control.
0x01	On.
0x02	Off (English).
0x03	Disabled.
0x04	Hiragana.
0x05	Full-width katakana.
0x06	Half-width katakana.
0x07	Full-width alphanumeric.
0x08	Half-width alphanumeric.
0x09	Full-width Hangul.
0x0A	Half-width Hangul.

E - fShowInputMsg (1 bit): A bit that specifies whether to display the input prompt message.

F - fShowErrorMsg (1 bit): A bit that specifies whether to display the error alert message.

G - typOperator (4 bits): An unsigned integer that specifies the relational operator used with this data validation. If valType is equal to 0, 3, or 7, the value of the typOperator field is undefined and MUST be ignored. This value MUST be a value from the following table.

Value	Type of Relational Operator
0x00	1. Between.
0x01	2. Not Between.
0x02	3. Equal.
0x03	4. Not Equal.
0x04	5. Greater Than.
0x05	6. Less Than.
0x06	7. Greater Than or Equal.
0x07	8. Less Than or Equal.

H - fDVMinFmla (1 bit): A bit that specifies if there is a first formula (section 2.2.2) for the data validation.

If typOperator is equal to 0 or 1 and valType is not 0, 3, or 7, then fDVMinFmla MUST be 1.

If typOperator is greater than or equal to 2 or valType is equal to 3 or 7, then fDVMinFmla MUST be 1.

If the valType is equal to 0, then fDVMinFmla MUST be 0.

I - fDVMaxFmla (1 bit): A bit that specifies if there is a second formula (section 2.2.2) for the data validation.

If typOperator is equal to 0 or 1 and valType is not 0, 3, or 7, then fDVMaxFmla MUST be 1.

If typOperator is greater than or equal to 2 or valType is equal to 0, 3 or 7, then fDVMaxFmla MUST be 0.

reserved (6 bits): This value MUST be 0, and MUST be ignored.

DValStrings (variable):  A DValStrings (section 2.5.37) that specifies the strings used by data validation.