You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by Blake Watson <bl...@pnmac.com> on 2017/02/28 20:08:14 UTC

Multiple validations per cell...example?

There's a call getDataValidations for the Sheet class, that returns all the
DataValidations for the sheet.

As a sheet may have many DataValidations, and those data validations may
theoretically overlap, it's theoretically possible for a single cell to
have more than one constraint in force at the same time.

I have not been able to create this situation, however. Excel seems to
insist that data validation be applied uniformly within a region. I'm not
complaining, I'm just trying to figure out if it's something I should look
for (more than one validation per cell).

-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com <me...@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>