I am new to apache POI and I cannot find the way to generate a xls file using only POI which implements the standard Excel feature Conditional Formatting -> Highlight Cell Rules -> Duplicate Values.
All I can do is to create a certain amount of Conditional Formatting Rules and bind them to a fixed number of cells (e.g. 200). This will provide the necessary functionality only for these (200) cells but marking only the second cell which contains a duplicate value highlighted (not all duplicate values will be really highlighted, once a duplicate is entered only it will be formatted). I need to be able to format all duplicate values in a certain column. My question is: Is it possible to create a column-wide trigger which will automatically add the formatting to newly filled cells, and recalculate all the conditional formatting for all already-filled cells in that column. -- View this message in context: http://old.nabble.com/POI%3A-column-wide-trigger-tp27466263p27466263.html Sent from the POI - User mailing list archive at Nabble.com.
