poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <apa...@gagravarr.org>
Subject Re: Data Validation: Does this value conform?
Date Thu, 16 Mar 2017 23:53:11 GMT
On Thu, 16 Mar 2017, Blake Watson wrote:
> Arrays.asList(
>>    DataValidationEvaluator.getValidationForCell(ref).
>>         getValidationConstraint().getExplicitListValues()
>> ).contains(value)
>>
>> should get you almost all the way there, I think?
>
> ‚ÄčI think you may be overestimating getExplicitListValues(). =) It handles
> one precise situation: When the Excel creator has typed in a list. If he's
> referencing a list by range or name, getExplicitListValues doesn't handle
> it. If he's referencing a list by range, and the range isn't on the same
> page, it's not even parsed out of the XML!

Hmm, sounds like we need an extra method on DataValidationEvaluator or 
similar class to handle all these other cases then!

Nick

Mime
View raw message