2.4.343 BrtDVal14

Office

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


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

FRTHeader (variable)

...

valType

A

B

C

D

mdImeMode

E

F

G

H

I

reserved

DValStrings (variable)

...

FRTHeader (variable): An FRTHeader (section 2.5.60) 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.65) 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.58) of the first FRTDVParsedFormula14 (section 2.5.57) 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.57) 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.36) that specifies the strings used by data validation.

Show: