Spreadsheet - Data Validation

Spreadsheet’s data validation helps you prevent the input of incorrect values to worksheet cells. This feature allows a user to define cell value restrictions and provide corresponding error messages. Data validation is extremely useful for ensuring that the entered data to be accurate and consistent when multiple users share a workbook.

This demo displays a simple document with applied data validation. Columns contain validated cells and provide explanatory comments. To view or modify validation settings, select a validated cell and click the Data Validation ribbon button to invoke the Data Validation dialog.

Backend API

@inject IWebHostEnvironment env @{ var documentPath = System.IO.Path.Combine( env.ContentRootPath, DirectoryManagmentUtils.GetDocumentSampleFolderPath(Context), "DataValidation.xlsx"); } @(Html.DevExpress() .Spreadsheet("spreadsheet") .Height("500px") .Width("100%") .Ribbon(ribbon => ribbon.ActiveTabIndex(3)) .ConfirmOnLosingChanges(confirm => confirm.Enabled(false)) .DocumentRequestHandlerUrl(Url.Action("DxDocumentRequest")) .Open(documentPath) )

using System; using System.IO; using System.Linq; using System.Text; using DevExpress.AspNetCore.Spreadsheet; using DevExpress.Spreadsheet; using DevExpress.XtraSpreadsheet.Export; using Microsoft.AspNetCore.Hosting; using Microsoft.AspNetCore.Mvc; namespace AspNetCoreDemos.Spreadsheet { [Route("[action]")] public class SpreadsheetController : Controller { public ActionResult DataValidation() { return View(); } } }