Aspose Cells gridJs not working Data Validation

[klepprime01]

validation2.jpg (83,9 KB)

textCalc.zip (6,6 KB)

I am having an issue with data validation in the Aspose Cells GridJs control. I have a sheet that I cannot modify, but I want it to work like MS Excel. The problem concerns the validation set on a cell. When the validation type is set to ‘Custom’ and I use a function like ‘=ISNUMBER(A2)’ in the ‘Source’ field, the validation doesn’t work. It seems that this type of validation is not supported by the Aspose control.

My first question is whether this will be fixed. The second question is whether there is a way to work around this until the function is supported. For example, is it possible to automatically identify this type of validation in the sheet and replace it with a supported type, such as ‘Whole number’ between 0-99999?

[amjad.sahi]

@klepprime01,

Thanks for the template Excel file and screenshot.

After initial testing, I am able to reproduce the issue as you mentioned with your template Excel file using editor/viewer app (created by Aspose.Cells.GridJs). I found when importing the file into Aspose.Cells.GridJs, custom data validation is not working.

We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSGRIDJS-1311

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

@klepprime01

The second question is whether there is a way to work around this until the function is supported. For example, is it possible to automatically identify this type of validation in the sheet and replace it with a supported type, such as ‘Whole number’ between 0-99999

Please spare us little to evaluate it in details first and then we will get back to you with new updates.

[wanghao.zhu]

@klepprime01

@klepprime01

The second question is whether there is a way to work around this until the function is supported. For example, is it possible to automatically identify this type of validation in the sheet and replace it with a supported type, such as ‘Whole number’ between 0-99999?

We are pleased to inform you that the current version of Grid.js supports setting cell validation through the Home menu under Data Validation. Specifically, you can configure the cells to allow ‘Whole number’ values between 0 and 99999.

whole number setting (17.9 KB)

[amjad.sahi]

@klepprime01,

This is to inform you that your issue (Ticket ID: “CELLSGRIDJS-1311”) has been resolved now. The fix/enhancement will be included in the next (upcoming) release (Aspose.Cells v24.11 package) that we plan to release in the first half of November 2024. You will be notified when new version is published.