poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Blake Watson <blake.wat...@pnmac.com>
Subject Reading (not writing) conditional states: possible?
Date Wed, 24 Feb 2016 22:00:29 GMT
So, there's lots of examples on how to write out conditional stuff to Excel

But I've got an Excel workbook with some conditional cells in it already,
and I want to know how to format those cells. Simple example:

==> Cell A1, otherwise unformatted, turns purple if its contents are
greater than 0.

If I read A1's style, I'll get the plain format. Now, I put  "100" into A1.
This doesn't change the cell style. If I evaluate A1, that still doesn't
change the style.

Do I have to go through all the conditions that might apply and do it that
way? IOW, POI doesn't directly/automatically support conditional formatting
triggered by changes made to an XSSFCell?


*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