• Material
  • Fabric
  • Bootstrap
  • Bootstrap v4
  • High Contrast
  • Tailwind CSS
Preferences
Theme Selection
Mode Selection
Touch
Mouse
Localization
*Translated by Google Translator.
Currency
Essential Studio
HOME
All Controls

Example of Data Validation in ASP.NET Core Spreadsheet Control

This sample explains the Data Validation feature with the gross pay calculation as an example. It is used to restrict the data that the user enters into a cell. To clear the applied validation, click the Data Validation button in the Data tab and Clear Validation option. You can also highlight the invalid data by selecting Highlight Invalid Data option.

DEMO
SOURCE
  • This feature allows you to apply validation to a cell or range of cells based on the conditions required. You can enable or disable data validation by using the allowDataValidation property.
  • In this sample, we have applied data validation for List, String, Number, Date and Time by using the addDataValidation method with ValidationModel as argument.
  • In the Employee Name column, we have used TextLength validation to provide proper name with more than 3 text length. In time in and time out column, we have provided Time validation for working hours between 8.00 AM to 6.00 PM. In the weekdays column, we have used List validation for weekdays (Monday to Friday).
  • In the hours worked column, we have used WholeNumber validation to find out overtime calculation(i.e more than 8 hours). And also, we used the addInvalidHighlight to highlight the overtime hours of the employee.

More information about the Data Validation can be found in this documentation section.