2.4.96 DVal

The DVal record specifies data validation information that is common to all cells in a sheet that have data validation applied and specifies the beginning of a collection of Dv records as defined by the Worksheet Substream ABNF.  The collection of Dv records specifies data validation criteria for individual ranges in the sheet.


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

A

B

C

reserved2

xLeft

...

yTop

...

idObj

...

idvMac

...

A - fWnClosed (1 bit): A bit that specifies whether the window used for input is closed.

B - reserved1 (1 bit): MUST be zero, and MUST be ignored.

C - unused (1 bit): Undefined and MUST be ignored.

reserved2 (13 bits): MUST be zero, and MUST be ignored.

xLeft (4 bytes):  An unsigned integer that specifies the X-coordinate of the top left corner of the window used for input relative to the window used to display the sheet, in pixels. MUST be less than or equal to 65535.

yTop (4 bytes):  An unsigned integer that specifies the Y-coordinate of the top left corner of the window used for input relative to the window used to display the sheet, in pixels. MUST be less than or equal to 65535.

idObj (4 bytes):  A signed integer that specifies a reference to an Obj that represents the drop-down button displayed if a cell with a drop-down button is the selected cell at the time the file is saved. The value of this field specifies the value of the cmo.id field of the associated Obj record. MUST be greater than 0 and less than or equal to 32767 if the drop-down button is displayed.  MUST be -1 if there is no drop-down button being displayed in the selected cell at the time the file is saved.

idvMac (4 bytes):  An unsigned integer that specifies the number of Dv records that follow this record. MUST be greater than or equal to 0 and less than or equal to 65534. There MUST be exactly that many Dv records following this record.