Get colors from Conditional Formatted cell using Apache POI

[Rafael Ribeiro Rezende <ra...@gmail.com>]

Hi all,

I'm using Apache POI and I have now the following situation:

Some specific cells from my .xls file has a conditional formatting to set
the font color as red depending on the comparison between two other cells.
This conditional is set through Excel and I just need to read the file with
respective formatting.

If I try to get the resulting color by using a regular procedure, I get the
default color instead, as someone already questioned before
here<http://apache-poi.1045710.n5.nabble.com/POI-HSSFSheetConditionalFormatting-can-t-read-font-color-of-the-specified-cell-td5019187.html>
.

I've found many examples on how to create a conditional formatting, but how
to evaluate the conditions and get the right resulting color? I didn't
understand if "*You'll need **to do any conditional formatting work yourself
*" means that I have to retrieve the condition, write it to a Cell,
evaluate it, and then apply the conditional formatting according to its
result...

Isn't there any straightforward to evaluate it?


Thanks in advance!
-- 
Rafael R R