The RadSpreadsheet control allows you to create your own custom Validation Dialog, where you can define the criteria and behavior for invalid data that suits best your scenario. You can achieve this, using the ValidationTemplate tag of the RadSpreadsheet control. The following steps will guide you trough the custom Data Validation dialog implementation:
Create a WebUserControl, which will contain the layot and behavior of the custom Validation dialog. In the WebUserControl you can define preferable Criteria for data types and implement any further configuration for those types. Also, you can configure the behavior for handling the invalid data and Hint Message.
<%@ Register Src="~/SpreadsheetValidation.ascx" TagPrefix="uc1" TagName="SpreadsheetValidation" %> .... .... <form id="form1" runat="server"> <telerik:RadScriptManager runat="server" /> <script src="Scripts/ValidationView.js"></script> <telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1"> <ValidationTemplate> <uc1:SpreadsheetValidation runat="server" ID="SpreadsheetValidation" /> </ValidationTemplate> </telerik:RadSpreadsheet> </form>
You can investigate the entire setup and test the behavior of the RadSpreadsheet with Custom Validation dialog in this Code Library: Validation Template for RadSpreadsheet Code Library.