Hi,
I have a problem with the validation of cells with the current version of Aspose Cells .Net. In the following example, the validation fails:
string excelPath = Server.MapPath("") + “\Data\Netzzustands- und Netzausbauplanungsbericht_Netzausbauplanung_2016_V2(1).xlsx”;
Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(excelPath);
workbook.Worksheets[0].Cells[“P7”].PutValue(“12345678910”, true, false);
bool validationResult = workbook.Worksheets[0].Cells[“P7”].GetValidationValue(); // validationResult is false
If I pass “123456789” as value, the validation is successful. In Excel, there are no problems with either value.
Where is the error?
Netzzustands- und Netzausbauplanungsbericht_Netzausbauplanung_2016_V2(1).zip (15.3 KB)