Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (nike.apache.org: domain of Jason.Howe@lhsc.on.ca
 designates 142.46.227.138 as permitted sender)
Message-Id: <4E8482D2.930A.00DE.1@lhsc.on.ca>
Date: Thu, 29 Sep 2011 14:38:10 -0400
From: "Jason Howe" <Jason.Howe@LHSC.ON.CA>
To: <user@poi.apache.org>
Subject: POI: Conditional Formatting
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello,

I am having trouble with the conditional formatting on an Excel sheet =
being manipulated using POI (HSSF).   This is an existing Excel worksheet =
that I am adding data to one sheet (Data) which is referenced in another =
(Summary).  The "Summary" sheet then uses a combo box to populate from a =
specific row in the "Data" sheet based on the date selected.  Depending on =
the values here there is some conditional formatting to style the cells =
background color (this conditional formatting is pre existing and is not =
manipulated with POI).  I am finding that the formatting is not taking =
place.  If I go into the Excel spreadsheet and manually re-enter the =
values and hit enter the formatting is then updated (or changing the combo =
box manually the formatting will update).  Is there some way to trigger =
all conditional formatting to "reprocess" in Apache POI before writing the =
file?

Thanks,
   Jason

 --------------------------------------------------------------------------=
------
This information is directed in confidence solely to the person named =
above and may contain confidential and/or privileged material. This =
information may not otherwise be distributed, copied or disclosed. If you =
have received this e-mail in error, please notify the sender immediately =
via a return e-mail and destroy original message. Thank you for your =
cooperation.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org