Re: POI/HSSF default cell formatting

Oh oh.... now I understand your needs :-)

Think I'll take one step back, and let others help you and just watch from
the sideline :-)

Sorry...

Leif
----- Original Message ----- 
From: "Peter Dow (ML)" <maillist@xxxxxxxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: 19. juli 2005 19:34
Subject: RE: POI/HSSF default cell formatting


> Hi Leif,
> 
> Thanks, I've done that too (thanks Scott!) when I'm in control of the
> formatting.  In this case however, I'm reading an existing spreadsheet where
> a user has set up some formatting and I have no idea what it might be, it's
> done in Excel by selecting the columns then doing ctl-1 (or going to the
> Format, Cell menu).  Since the rows and cells have not been created yet, I
> can't extract any existing HSSFCellStyle object from them.  The information
> appears to be in ColumnInfo records in the spreadsheet, and the HSSF
> usermodel doesn't have any classes or methods to extract those records or
> get the formatting.  Nor have I seen anything on the jakarta website that
> does.  I think I may be in the "to do" section of the project...
> 
> Peter Dow
> Dow Software Services, Inc.
> www.dowsoftware.com
> 909 793-9050 voice
> 909 793-4480 fax
> 
> 
> 
> -----Original Message-----
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Leif Guldbrand
> Sent: Tuesday, July 19, 2005 6:30 AM
> 
> I'll try to show what I have done, formatting new cells.
> I have five different formats and the standard format for cells.
> I have used Scott Klements articles and examples - and his help to do it :-)
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.9.2/52 - Release Date: 7/19/2005
> 
> 
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
> 
>