If it is working go ahead. The code I quoted from is from a special
class of ours that we use to manage Styles in our XLS creation process.
It helps to remind everyone that styles are stored in the workbook and
then later associated with a cell. It really helps to manage your
styles as quic
Thank you for your help, David. Are you saying that I should not close the
style using
the cloneStyleFrom() method on the HSSFCellStyle object? This method is in
the
3.2-FINAL release I'm using and seems to be working.
Is it going to be removed in a later release?
Thanks,
David Fisher wrote:
>
problem
as you.
Also, this lisst seems to be regularly visited by the people who
created
and maintain the API, never a bad thing IMO.
--- On Fri, 1/9/09, Mark Hansen wrote:
From: Mark Hansen
Subject: RE: Applying a data format to a style for one cell affects
other
cells?
To: user@poi.apach
exactly the same problem as you.
> Also, this lisst seems to be regularly visited by the people who created
> and maintain the API, never a bad thing IMO.
>
> --- On Fri, 1/9/09, Mark Hansen wrote:
> From: Mark Hansen
> Subject: RE: Applying a data format to a style for one ce
cell. I
believe I used the setting of a date value in my original example.
I'm going to try reorganizing my code as mentioned above, and will post
back
with my results.
Thanks for all the time you've put into this. I really need to get this
working soon.
--- On Thu, 1/8/09, Mark Hansen wro
as mentioned above, and will post back
with my results.
Thanks for all the time you've put into this. I really need to get this
working soon.
--- On Thu, 1/8/09, Mark Hansen wrote:
From: Mark Hansen
Subject: RE: Applying a data format to a style for one cell affects other
cells?
To: us
OK Mark, here is one very simple example - well in the attached files there is.
If you look first at the Excel temple file, you will see that it contains five
columns each with a title in the topmost cell. The cell in row two of each
column has been formatted - a date, an integer, a floating poi
rmine type and then populate a worksheet. If you want, I can
post it for you later today, just let me know.
--- On Thu, 1/8/09, Mark Hansen wrote:
From: Mark Hansen
Subject: RE: Applying a data format to a style for one cell affects other cells?
To: user@poi.apache.org
Date: Thursday, January 8,
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
nd modify it,
you're actually modifying the style of all cells in the workbook that is
using that style.
Cheers,
Winarto
-Original Message-
From: Mark Hansen [mailto:nab...@mehconsulting.com]
Sent: Friday, 9 January 2009 07:46
To: user@poi.apache.org
Subject: Re: Applying a data forma
Mark Hansen wrote:
>
> I'm using POI 3.2-FINAL on Windows/XP SP3.
> My program is opening an Excel template file (.xlt - 2003 version) and
> creating rows/cells to fill the work sheet with data which comes from a
> separate system.
> The feature allows my customer to export there data to .xls,
11 matches
Mail list logo