poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gustavo Tomazi Ludwig <gtl.li...@gmail.com>
Subject XSSF conditional formatting for a series of cells
Date Tue, 14 Jun 2011 13:28:51 GMT
Hi all,

I need to paint the background of a series of cells, that should inform 
the user of how grave the information is. In this particular case, I 
need to generate a report of production delays - the bigger the delay, 
the redder the cell background must be painted. On the opposite, if the 
calculated delay is negative (means the product was delivered ahead of 
time) or zero, the cell background should be greenish.

I googled and found this link:

But as far as I can tell, it regards conditional formatting for a single 
cell. Can this (or some other) approach be applied to a series of cells?

Thanks in advance,

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

View raw message