Validate just one cell

eebrero · July 2, 2017, 8:03pm

Hello.

How can I validate just one cell from the grid?

What I mean is that I need something similar to the ValidateAll() method, but that would just validate one cell of the grid.

For example a method called: ValidateCell(cell)

Thanks,

EEbrero

amjad.sahi · July 2, 2017, 8:03pm

Hi,

Well, by defatult, when you apply data validation, GridWeb checks every cell in a worksheet (where you apply validation) if it abides by the validation rules. We will check if we can consider this feature.

Thank you.

eebrero · January 30, 2021, 10:56am

Hello.

I thought Aspose.Grid did not support Data Validation...

(See forum thread: <A href="https://forum.aspose.com/t/90757</A> ) Did I misunderstood? By the way, is it possible to edit the commonbehav.js file, and add this new function? Can I do that, and do you think this could solve the problem? Thank you. EEbrero

amjad.sahi · January 24, 2023, 7:37pm

Hi,

Well, Aspose.Grid.Web does not support to import / export data validation attributes, although it does support to create data validations remaining using GridWeb control matrix, check the demo:

github.com

aspose-cells/Aspose.Cells-for-.NET/blob/master/Examples_GridWeb/GridWeb.Net4/CSharp/Miscellaneous/Common/DataValidation.aspx.cs

using System;
using Aspose.Cells.GridWeb.Data;
using System.Collections.Specialized;
using Aspose.Cells.GridWeb;

public partial class demos_Common_DataValidation : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        License lic = new  License();
        //lic.SetLicense(@"C:\CellLicense\Aspose.Total.NET.lic");
        //lic.SetLicense(@"D:\DotNet Projects\Aspose\2019\Aspose.Total.NET.lic");

        if (!IsPostBack && !GridWeb1.IsPostBack)
        {
            
            GridWeb1.WorkSheets.Add();

            //set sheets selectedIndex to 0
            GridWeb1.WorkSheets.ActiveSheetIndex = 0;

This file has been truncated. show original

For your second query, we will get back to you soon.

Thank you.