Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
MIME-Version: 1.0
Date: Wed, 24 Feb 2016 14:00:29 -0800
Message-ID: 
 <CAFGkfm1D-JyceSVMdyUzfVRb4RZ=oTjaNm0f2RD8=RatXWzoBA@mail.gmail.com>
Subject: Reading (not writing) conditional states: possible?
From: Blake Watson <blake.watson@pnmac.com>
To: POI Users List <user@poi.apache.org>
Content-Type: multipart/alternative; boundary=047d7b673198ad7b95052c8b317d

--047d7b673198ad7b95052c8b317d
Content-Type: text/plain; charset=UTF-8

So, there's lots of examples on how to write out conditional stuff to Excel
files.

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*

*PNMAC*
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/>

--047d7b673198ad7b95052c8b317d--