2.4.353 BrtDVal
The BrtDVal record specifies data validation for a range on this sheet.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
valType |
A |
B |
C |
D |
mdImeMode |
E |
F |
G |
reserved |
||||||||||||||||||||||
sqrfx (variable) |
|||||||||||||||||||||||||||||||
... |
|||||||||||||||||||||||||||||||
DValStrings (variable) |
|||||||||||||||||||||||||||||||
... |
|||||||||||||||||||||||||||||||
formula1 (variable) |
|||||||||||||||||||||||||||||||
... |
|||||||||||||||||||||||||||||||
formula2 (variable) |
|||||||||||||||||||||||||||||||
... |
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
0x0
Specifies that the data validation allows any type of value and does not check for a type or range of values.
0x1
Specifies that the data validation checks for and allows whole number values satisfying the given condition.
0x2
Specifies that the data validation checks for and allows decimal values satisfying the given condition.
0x3
Specifies that the data validation checks for and allows a value that matches one in a list of values.
0x4
Specifies that the data validation checks for and allows date values satisfying the given condition.
0x5
Specifies that the data validation checks for and allows time values satisfying the given condition.
0x6
Specifies that the data validation checks for and allows text values whose length satisfies the given condition.
0x7
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
0
Specifies that the data validation error style uses a stop icon in the error alert.
1
Specifies that the data validation error style uses a warning icon in the error alert.
2
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 dropdown 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
Between
0x01
Not Between
0x02
Equal
0x03
Not Equal
0x04
Greater Than
0x05
Less Than
0x06
Greater Than or Equal
0x07
Less Than or Equal
reserved (8 bits): This value MUST be 0, and MUST be ignored.
sqrfx (variable): A UncheckedSqRfX (section 2.5.156) that specifies the ranges over which data validation is applied. The value sqrfx.crfx MUST be greater than or equal to 1 and MUST be less than 8,192.
DValStrings (variable): A DValStrings (section 2.5.37) that specifies the strings used by data validation.
formula1 (variable): A DVParsedFormula (section 2.5.98.8) specifying the first formula (section 2.2.2) in the data validation drop-down combo box.
-
If typOperator is equal to 0 or 1 and valType is not 0, 3, or 7, this formula is used as the lesser of two bounding values and formula1.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, this formula is the only formula for those cases, and formula1.cce MUST be greater than or equal to 1.
-
If the valType is equal to 0, this formula MUST be ignored and formula1.cce MUST be 0.
formula2 (variable): A DVParsedFormula (section 2.5.98.8) that specifies the second formula (section 2.2.2) in the data validation drop-down combo box.
-
If typOperator is equal to 0 or 1 and valType is not 0, 3, or 7, this formula is used as the greater of two bounding values and formula2.cce MUST be greater than or equal to 1.
-
If typOperator is greater than or equal to 2 or valType is equal to 0, 3, or 7, this formula MUST be ignored and formula2.cce MUST be 0.