RE: POI/HSSF default cell formatting

No problem, thanks for the response.  I kind of feel like I'm jumping in the
deep end of the pool figuring I'll find out whether I can swim or not<G>.

Actually, it seems like this is something the createCell method should be
doing for me; after all, it's what happens when I use Excel to put a value
in a cell, and I had the impression the HSSF methods are trying to make it
simple to do what Excel does.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Leif Guldbrand
Sent: Tuesday, July 19, 2005 11:54 AM
To: RPG programming on the AS400 / iSeries
Subject: 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.
>
>
>


--
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.

--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.9.2/52 - Release Date: 7/19/2005

--
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