Verify that cell value satisfies data validation rules in .NET

Aspose.Cells Product Family
13

Hi Glynn,


I have withdrawn my response upon discussing the matter internally. We have to look further into the situation to provide you with a valid justification for the said behavior. As narrated by Amjad, the relevant ticket has been re-opened, and we will shortly get back to you with updates in this regard.
14

Hi all,

Are you able to provide an update on this issue? If you expect the issue to remain for some time, then I will need to code a workaround. Please let me know.

Thanks,

Glynn

15

Hi,


I am afraid, there is no update on your issue at the moment. Our concerned developers are on their holidays (they will come back after 3-5 days or so). Once they come back, we will schedule it and figure your issue out, hopefully, it will be fixed soon.

Keep in touch.

Thank you.
16

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v8.2.1.4

We have fixed your issue now.

Let us know your feedback.

Thanks,

17

Hi Amjad,

Sorry for the delay in responding. I tested the fix this morning (in version 8.2.2) and the problem appears to be fixed. I tested integer and custom validation and both worked fine.

Thanks for your help,

Glynn

18

Hi,


Thanks for your feedback.

Good to know that your issue is resolved by the fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.
19

Hi Amjad,

Unfortunately there is still a problem. A call to GetValidationValue returns NullReferenceException within the following example:

Within Excel, in a new workbook, enter these values to the cells in range Sheet2!A1:A3: A, B, C
Define a name to the range Sheet2!A1:A3, for example "List1"
Add a validation rule to cell Sheet1!A1 - type List, Source = List1.

Cell Sheet1!A1 will now only allow the values A, B, C from it's drop-down list.

In Aspose.Cells, call GetValidationValue() for Sheet1!A1. It will return a NullReferenceException, irrespective of whether the cell contains a value.

Please advise... thanks,

Glynn

20

Hi,


Thanks for providing details.

After an initial test, I observed the issue as you mentioned by using the following
sample code with a simple template file (attached) that is created manually in MS Excel as
per your instructions.

I got the error on the last line of code:


Object reference not set to an instance of an object.


e.g


Sample code:


Workbook workbook = new Workbook("e:\\test2\\Validationcheck1.xlsx");



//Access Cell A1
Cell cell = workbook.Worksheets[0].Cells["A1"];

//Check if number satisfies the Data Validation rule applied on this cell
Console.WriteLine("Whether a Valid Value for this Cell: " + cell.GetValidationValue()); //Error

I have logged a separate ticket with an id "CELLSNET-43122" for your issue. We will look into it soon.

Once we have any update on it, we will let you know here.

Thank you.

21

Thanks for confirming the problem. I would appreciate an update on this issue as deployment of our solution is on hold until this problem is resolved. Thanks!

22

Hi,


I have checked status of your issue “CELLSNET-43122”, it is still Open. We have logged your concerns against your issue into our database. We have also asked the concerned developer to update on it or provide an eta for it.

Once we have any update on it, we will let you know here.

Thank you.
23

Hi,

Thanks for your using Aspose.Cells.

We have fixed this issue.

  • CELLSNET-43122 - Cell.GetValidationValue() returns a NullReferenceException

Please download and try the latest fix: Aspose.Cells for .NET v8.2.2.2 and let us know your feedback.

24

Hi Shakeel,

I confirm that your latest version has resolved this particular issue. Thanks for your help.

Glynn

25

Hi Glynn,

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.

26

Shakeel,

Unfortunately there is still a problem. If the validation rule is of type 'list' and the list is long (in my case 600+ rows), GetValidationValue will return False for values that are towards the end of the list. You can test this by extending the previous example to contain many more rows (and extend the named range). I have done this in the attached xlsx. GteValidationValue will return false if you choose values further down the list.

I still therefore cannot deploy the solution. I would appreciate your help with this.

Regards,

Glynn

27

Hi,


Thanks for providing us template file.

After an initial test, as I have tested the issue with your newly attached file and found the issue as you pointed out. The issue is still there if we have a long List for data validation and we choose a bottom value (initial values work fine though). I have reopened the issue “CELLSNET-43122”. We will look into it to figure it out soon.

We are sorry for any inconvenience caused!
28

Please could you update me on this issue. As I have said before, our deployment is on hold while we await a solution. Thanks.

29

Hi,


I am afraid, your issue is still in process, it is not fixed yet. I have asked the relevant developer to update on it or provide an eta (if possible).

Once we have any update on it, we will let you know here.

Thank you.
30

Hi,

Thanks for your using Aspose.Cells.

We have fixed this issue.

  • CELLSNET-43122 - Cell.GetValidationValue() returns a NullReferenceException

Please download and try the latest fix: Aspose.Cells for .NET v8.2.2.3 and let us know your feedback.

31

Thanks. The new version has resolved the problem I last reported.

32

Hi Glynn,


Thank you for the confirmation. Please feel free to test the scenario(s) extensively. In case you stumble upon some problem, please contact us back any time.