poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Blake Watson <blake.wat...@pnmac.com>
Subject Multiple validations per cell...example?
Date Tue, 28 Feb 2017 20:08:14 GMT
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*

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

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message