poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karl-Heinz Zengerle" <karl-heinz.zenge...@sawag.com>
Subject AW: Question about Cell Styles in Excell
Date Tue, 11 May 2004 15:16:13 GMT
Hi Felipe.

You could generate the things to a nearly empty template (possibly just
having some macros for your functionality). You'ld generate it without
any styling information but with a marker that at the next startup of
this file and still seeing that marker you do your styling directly in
Excel.

You can't know variable things in advance but afterwards it's easy to
analyze such things.

Regards,	Karl-Heinz.


-----Ursprüngliche Nachricht-----
Von: Felipe Castro [mailto:fmcastro@m4u.com.br] 
Gesendet: Dienstag, 11. Mai 2004 17:06
An: POI Users List
Betreff: Re: Question about Cell Styles in Excell

I see, but I don't know beforehand how many rows I'll write. Also, the
"table" I'm trying to write should be "centered" on the sheet for
readability. I don't use the upper, lower, left and rightmost rows and
columns of my sheet. I don't know if templates would help...


----- Original Message ----- 
From: "Karl-Heinz Zengerle" <karl-heinz.zengerle@sawag.com>
To: "'POI Users List'" <poi-user@jakarta.apache.org>
Sent: Tuesday, May 11, 2004 11:49 AM
Subject: AW: Question about Cell Styles in Excell


> Hi Felipe.
>
> In Excel you can also set styles for whole rows or columns and then
> override some styles of specific cells (e.g. header cells). So it
should
> also be possible in POI. This way the quantity of settings should be
> small.
>
> When I hear alternating styles I'ld first think about styles on higher
> level.
>
> Regards, Karl-Heinz.
>
>
> -----Ursprüngliche Nachricht-----
> Von: Felipe Castro [mailto:fmcastro@m4u.com.br]
> Gesendet: Dienstag, 11. Mai 2004 16:39
> An: POI Users List
> Betreff: Re: Question about Cell Styles in Excell
>
>     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" <Bjoern.Mehner@epos-cs.de>
> To: "POI Users List" <poi-user@jakarta.apache.org>
> 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: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>


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


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


Mime
View raw message