POI: column-wide trigger

[Maya N <ma...@cycos.com>]

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.

Re: POI: column-wide trigger

[MSB <ma...@tiscali.co.uk>]

Well, the obvious answer that springs to ind is to base the file that you
create with POI on a template that is created using Excel.

If you know in advance which column(s) must feature the duplicate
highlighting, then use Excel to create a template file where you have
applied this rule to the column. Open that file using POI and populate it
with data. I am confident (well, fairly confident) that POI will pass
through the rule from templte to completed file.

Yours

Mark B


Maya N wrote:
> 
> 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-tp27466263p27471433.html
Sent from the POI - User mailing list archive at Nabble.com.


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