Data Validation

An Excel-inspired data validation implemented by the Bootstrap Spreadsheet helps prevent end-users from entering wrong values into worksheet cells. This feature allows a user to define restrictions and provide notifications on which data can and should be entered into a cell. Data validation is extremely useful when a workbook is shared by multiple users, and you want the data entered in the workbook to be accurate and consistent.

This demo displays a simple document with data validation applied. Each column containing validated cells is accommodated with a comment explaining which values can be entered into these cells. To view or modify validation settings, click the Data Validation button on the ribbon to invoke the Data Validation dialog.

<dx:BootstrapSpreadsheet runat="server" Height="850px" ActiveTabIndex="2" ShowConfirmOnLosingChanges="false">
</dx:BootstrapSpreadsheet>