Can you document that? I had the same question.
On Tue, 2002-10-08 at 15:03, Laubach Shawn Contr OC-ALC/PSB wrote:
> >From looking at the internals when one sets one as text, the format is 0x31
> which is a builtin format. Just call HSSFDataFormat.getBuiltinFormat("@")
> and it should give you the "Text" format.
>
> Shawn Laubach
> SAIC - Web Developer
> B-1B System Support Management Division
> OC-ALC/LAB, Building 3001, Tinker AFB, Oklahoma
> dsn: 336-2473 comm: 405-736-2473 mobile: 405-245-9562
>
>
> -----Original Message-----
> From: James Watkin [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 08, 2002 1:56 PM
> To: POI Users List
> Subject: RE: Feature Request - HSSF Format/Cells/Number/Category/Text
> Sett ing
>
>
> When I put a String value in a cell, the resulting value of
> Format/Cells/Number/Category is 'General' within the Excel 2000 GUI, not
> 'Text'. A setting of 'General' results in the bad behavior that I mentioned
> earlier -- the loss of leading zeros after the text is edited.
>
> Are you really saying that when you set a cell to String, the resulting
> value of Format/Cells/Number/Category is 'Text' within the Excel 2000 GUI
> and not 'General'? I don't seem to be able to achieve that 'Text' setting
> with HSSF. The 'Text' setting seems to be the only way I can get the full
> behavior I'm looking for.
>
> - Jim
>
> At 08:22 AM 10/8/2002 -0500, you wrote:
> >Technically, it does. The does this by setting the type of the cell as
> >text. It doesn't use data formatting in any way. The easiest way to do
> >this is to make sure the value put into the cell is a string and it will
> >remember the text as is.
> >
> >Shawn Laubach
> >SAIC - Web Developer
> >B-1B System Support Management Division
> >OC-ALC/LAB, Building 3001, Tinker AFB, Oklahoma
> >dsn: 336-2473 comm: 405-736-2473 mobile: 405-245-9562
> >
> >
> >-----Original Message-----
> >From: James Watkin [mailto:[EMAIL PROTECTED]]
> >Sent: Monday, October 07, 2002 5:13 PM
> >To: POI Users List
> >Subject: Feature Request - HSSF Format/Cells/Number/Category/Text
> >Setting
> >
> >
> >Is it true that HSSF doesn't support the setting
> >Format/Cells/Number/Category/Text? If so, I'd like to request this feature.
> >Although I can sort of fake what I need with a custom format, it's not the
> >same thing and the user might not accept it. The custom format solution
> >only partially solves the fragile spreadsheet problem created by leading
> >zeros in number strings such as serial numbers.
> >
> >A custom format will preserve the 'display' of leading zeros in a number
> >string within a given cell after the cell has been edited. The problem is
> >that the cell value will show up in the editing area without the leading
> >zeros, after the cell has been edited. So while you're editing the cell,
> >whether in place or in the editing area, you won't see the leading zeros. I
> >think this will be bothersome to my users since we typically handle this
> >now (manually) by setting Format/Cells/Number/Category to 'Text' for such
> >cells so that the leading zeros appear in the editing area.
> >
> >- Jim
> >
> >______________________________
> >James Watkin
> >The Anderson School at UCLA
> >[EMAIL PROTECTED]
> >Voice: 1-310-825-5030
> > Fax: 1-310-825-4835
> >______________________________
> >
> >
> >--
> >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
> ______________________________
> James Watkin
> The Anderson School at UCLA
> [EMAIL PROTECTED]
> Voice: 1-310-825-5030
> Fax: 1-310-825-4835
> ______________________________
>
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
--
http://www.superlinksoftware.com - software solutions for business
http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in
Java
http://krysalis.sourceforge.net/centipede - the best build/project
structure
a guy/gal could have! - Make Ant simple on complex Projects!
The avalanche has already started. It is too late for the pebbles to
vote.
-Ambassador Kosh
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
