Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Data Validation

  • Undo

    Undo
    po
  • Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po
  • Cells

    Cells
    po
  • Editing

    Editing
    po
  • Styles

    Styles
    po
  • Document Views

    Document Viewspo
  • Show

    Show
    po
  • View

    View
    po
  • Window

    Window
    po
  • Properties

    Properties
    po
  • Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Table Style Options

    Table Style Optionspo
  • Layout

    Layout
    po
  • PivotTable Style Options

    PivotTable Style Optionspo
 

An Excel inspired data validation implemented by the DevExpress ASP.NET Spreadsheet (ASPxSpreadsheet) 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.

Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxSpreadsheetDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxSpreadsheetDemos