Hi Aspose team,
I have some problem when input number in gridweb cell . When i input something like ‘1-2’ in a cell, it will convert to number 43102. I would like to have my own validation on cell using setOnAjaxCallFinishedClientFunction(). However, i get the cell value by gridwebins.getCellValueByCell(cell), and it already convert to 43102.
It seems like the cell format is set to number so that it will do the conversion. I tried to set the validation type as following but it does not work:
GridValidationCollection validations = gridwebsheet.getValidations();
GridValidation validation = validations.add();
Is there any ways can i disable the auto conversion?
I am using aspose-cell version 18.7, thanks.