Re: Applying a data format to a style for one cell affects other cells?

2009-01-09 Thread David Fisher
are already in the file. Good luck. Regards, Dave -- View this message in context: http://www.nabble.com/Applying-a-data-format-to-a-style-for-one-cell-affects-other-cells--tp21362472p21379470.html Sent from the POI - User mailing list archive at Nabbl

Re: Applying a data format to a style for one cell affects other cells?

2009-01-09 Thread Mark Hansen
style). > > You can use HSSFWorkbook.getNumCellStyles() and > HSSFWorkbook.getCellStyleAt(short idx) to retrieve the styles that are > already in the file. > > Good luck. > > Regards, > Dave > > > -- View this message in context: http://www.nabble.com/

Re: Applying a data format to a style for one cell affects other cells?

2009-01-09 Thread David Fisher
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

RE: Applying a data format to a style for one cell affects other cells?

2009-01-09 Thread Mark Hansen
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

RE: Applying a data format to a style for one cell affects other cells?

2009-01-09 Thread Anthony Andrews
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

RE: Applying a data format to a style for one cell affects other cells?

2009-01-09 Thread Mark Hansen
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

Re: Applying a data format to a style for one cell affects other cells?

2009-01-09 Thread Anthony Andrews
I don't want to overwrite those. Can anyone explain what I need to do? Thanks, -- View this message in context: http://www.nabble.com/Applying-a-data-format-to-a-style-for-one-cell-affects-other-cells--tp21362472p21362472.html Sent from the POI - User mailing list archive at Nabble.com.

RE: Applying a data format to a style for one cell affects other cells?

2009-01-09 Thread Anthony Andrews
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,

RE: Applying a data format to a style for one cell affects other cells?

2009-01-08 Thread Mark Hansen
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-

RE: Applying a data format to a style for one cell affects other cells?

2009-01-08 Thread Winarto
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

Re: Applying a data format to a style for one cell affects other cells?

2009-01-08 Thread Mark Hansen
ess my code is resulting in the style being applied to all cells? I can't create a new style for every cell because: 1. It results in too many styles and I get an error, and 2. I lose the existing formatting made to the cell by the author of the Excel template file Is there a way I can ap

Applying a data format to a style for one cell affects other cells?

2009-01-08 Thread Mark Hansen
n? I can't just create a generic style for use by all cells, because the customer will set cell-specific styles (like background color, etc.) on individual cells, and I don't want to overwrite those. Can anyone explain what I need to do? Thanks, -- View this message in context: htt