Red Corss Validation

Aspose.Cells Product Family
1

Hi All,

Is it possible that cell validation error XXXX Red mark inside the cell in aspose gridweb can be change ?

we have a requirement that XXXX red mark should be replaced with the Red color border of the cell should be displayed when the validation error throws on aspose gridweb.

Regards,
Gawaskar.


2

Hi,


Thanks for your query.

Well, I am afraid, currently it is the behavior of Aspose.Cells.GridWeb that displays red crosses marks on the cells. Anyways, we will check if can provide some APIs to allow users to customize the data validation behavior (currently it displays red crosses on the cells which violates the data validation) as per user needs. I have logged a ticket with an id “CELLSNET-41746” for your needs. We will look into it.

Once we have any update on it, we will let you know here.

Thank you.
3

Hi,


You can update the below function in “acwmain.js” to achieve your goal.
e.g
//…
function setInvalid(o)
{
if (o.style.backgroundImage != “url(’” + this.image_file_path + “x.gif’)”)
o.style.backgroundImage = “url(’” + this.image_file_path + “x.gif’)”;
this.mOnCellError(o);
}

Please also find the latest/updated “acwmain.js” file here.

Thank you.

Thank you.
4

Thanks for your support.

We need one more clarification which we keep validation on cell level in aspose gridweb.

If the cell value is deleted in the aspose gridweb its displaying red cross in the aspose gridweb.

In our requirement if the cell values is deleted ,alert pop up window should be displayed(ie: "Cell value should not be emply") in the aspose gridweb cell with red corss mark.

Regards,

Gawaskar.

5

Hi,

Thanks for your posting and using Aspose.Cells for GridWeb.

We have logged your requirement. We will look into it if it is feasible and update you. Please spare us some time. Once, there is some update for you, we will let you know asap.

6

Hi,

Thanks for your posting and using Aspose.Cells for GridWeb.

The client js is open source. For your customized requirement please update the js code yourself.


You can check the cell value and raise the alert.