Does NPOI have a built-in way to validate a cell value based on Excel data validation constraints?

[toraritte]

What I would like to do:

1. Set cell value.
2. Check if the cell value conforms to the data validation rules referencing that cell.

I could extract all the information needed to create a validation function, but don't want to re-invent the wheel. I didn't find the NPOI docs yet (is it the source?), and based on my experiments, there is no such function, but perhaps I was looking in the wrong places.

Apache POI's XSSFDataValidationConstraint class does have a validate method, but the docs are not much help and I don't know Java:

validate
public void validate()

---

edit: Just found Apache POI's DataValidationEvaluator class and I presume that NPOI.SS.Formula.DataValidationEvaluator is the corresponding NPOI class. Am I on the right track?

[toraritte]

The answer is no. Did some digging and I understand now why this is so difficult to do:

• stackoverflow Which .NET project can programmatically validate a cell's value out of the box based on Excel data validation constraints?
• stackoverflow How to programmatically evaluate Excel data validations using NPOI?

[tonyqus]

I created #1231 based on this post. We will sync the code from POI [DataValidationEvaluator](https://poi.apache.org/apidocs/dev/org/apache/poi/ss/formula/DataValidationEvaluator.html]

[toraritte]

Thank you! Would love to help, but only worked with F# thus far and NPOI's internals are still obscure to me. Is there something I can do even at this level?