-
Notifications
You must be signed in to change notification settings - Fork 1.4k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
A built-in way to validate a cell value based on Excel data validation constraints? #1231
Comments
These are the challenges I've found, and this is how Apache POI does it:
|
Discussed in #1217
Originally posted by toraritte November 21, 2023
What I would like to do:
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 avalidate
method, but the docs are not much help and I don't know Java:edit: Just found Apache POI's
DataValidationEvaluator
class and I presume thatNPOI.SS.Formula.DataValidationEvaluator
is the corresponding NPOI class. Am I on the right track?The text was updated successfully, but these errors were encountered: