Thank you for all your feedback..
Yes... I'm just trying to alternate colors on data rows. The need to
create different styles for each cell almost makes impracticable the use of
POI for decently formatted sheets. Maybe POI could think of some kind of
style hierarchy or, at least, implement the "clone" method in the
HSSFCellStyle class. If one could clone a style, he could change only the
cell data format and wouldn't need to reset all style properties for each
cell with a different format.
I'm not sure but I thought of that in less than 5 minutes... There must
be a good reason for not implementing it.
As for templates, I don't know exactly how to use them. Should I create
an empty 2 line table (in the template) and use POI to get those lines
styles and aply them to new cells?
Thanks again,
Felipe
----- Original Message -----
From: "Mehner, Bj�rn" <[EMAIL PROTECTED]>
To: "POI Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, May 11, 2004 4:38 AM
Subject: AW: Question about Cell Styles in Excell
>
>
> > Let me see if I get it straight. Please suppose I have a
> > simple table with 1 title row, two data rows and 6 columns.
> > Each of these rows has it's own fill color and each of the
> > data columns has it's own data format (the title row is, of
> > course, formed of strings). If the only way to set a fill
> > color and data format is by a cell style, does that mean that
> > I have to create 6 * 2 + 1 = 13 different cell styles to
> > accomplish the desired format? Is that right?
>
> Unfortunately I think you are right. Do you really have to have
> different colors each data row? Sounds strange to me. What are you doing
> if the table has more than 2 rows? Alternating colours?
>
> ciao Bodo
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
