You can use the data validation feature in Spread.Services to ensure users enter only the valid values into a cell while working in a spreadsheet.
For instance, let's say you have a worksheet where you want users to enter only whole numbers between 1 to 15. To accomplish this, you can create a data validation rule that restricts users to enter cell values other than a whole number between 1 to 15. You can even create custom dropdown lists to specify the possible values that can be entered in the cells or display messages or error alerts to validate the data and get notified if there is something wrong with the information entered in the worksheets.
Applying data validations in worksheets involves the following tasks.