Spread.Services provides users with the ability to validate data by restricting the type of information format and the values that can be entered in cells of a worksheet. You can create distinct validation scenarios for individual cells or a range of cells as per your requirements.

Using the data validation feature, you can perform the following tasks in a spreadsheet:

• Generate a list of entries by putting a check on the values allowed in cells.
• Prompt messages to describe the type of data values that can be entered in a cell.
• Figure out if entry in a particular cell or a range of cells is correct or not on the basis of calculations performed on other cells.
• Set a range of values (numeric or alphabetic) allowed in cells or a range of cells.
• Display error alert messages when invalid data is entered in a cell.

For more information on data validation, refer to Apply Data Validations.