We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose.Cells Validation problem

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)

@Matthias_Winzer,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46435 - GetValidationValue returns wrong value for large numbers

@Matthias_Winzer,

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-46435”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

The issues you have found earlier (filed as CELLSNET-46435) have been fixed in Aspose.Cells for .NET v18.11. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi