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