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