Winarto-2 wrote:
>
> Hi Mark,
>
> As far as I understand, style is available in workbook level, and hence
> when you're doing "HSSFStyle localStyle = cell.getCellStyle()" you're
> actually getting the style reference from the workbook that is applied
> to the particular cell. So If you get the cell style and modify it,
> you're actually modifying the style of all cells in the workbook that is
> using that style.
>
> Cheers,
> Winarto
>
>
Hello and thank you for your response.
Can you please tell me then how I am supposed to create styles for each of
the cells
in the sheet? If I create a new style for each cell I lose the formatting
applied to the
cell in the template and I get an error that I've created too many styles.
All I really want to do is change the data formatting on a per-cell basis
(actually, the
formatting will be the same for that cell in every row). Is there a way I
can apply formatting
to a cell without having it affect all cells - without creating a new cell
style for each cell?
Thanks,
--
View this message in context:
http://www.nabble.com/Applying-a-data-format-to-a-style-for-one-cell-affects-other-cells--tp21362472p21366134.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
