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

Free Support Forum - aspose.com

cell.GetValidationValue not working for numeric list


GetValidationValue incorrectly returns False when data validation of type 'list' is applied to a cell, and the list is derived from a named range that contains only numeric values. To reproduce this problem:

  1. In cells A1:A4, enter the numeric values 1, 2, 3, 4.
  2. Apply the name "MyName" to the range A1:A4
  3. On cell A5, apply data validation: Allow: List; Source: =MyName.
  4. Enter the value 3 into the cell.

GetValidationValue will return False for cell A5, despite the value being valid.

I would greatly appreciate an urgent response to this issue as it has been reported by a customer who is now unable to use the application.




Thanks for using Aspose.Cells.

We were able to observe this issue by executing the following sample code with the latest version: Aspose.Cells for .NET v8.4.1.1 with the attached source excel file. And found that Cell.GetValidationValue() method is not returning correct value for cell A5. It should return true because cell A5 has a valid value but it is returning false.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43589 - Cell.GetValidationValue not working for numeric list


string filePath = @“F:\Shak-Data-RW\Downloads\source.xlsx”;

Workbook workbook = new Workbook(filePath);

Worksheet worksheet = workbook.Worksheets[0];

Cell cell = worksheet.Cells[“A5”];

//It should return true but it is returning false

bool ret = cell.GetValidationValue();


Thanks for your using Aspose.Cells.

Please download and try the latest fix:Aspose.Cells for .NET (Latest Version) and let us know your feedback.


Many thanks for the new version, which I confirm has resolved the issue.




Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.

The issues you have found earlier (filed as CELLSNET-43589) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.