I've thrown it into the FAQ and also put in code that if the format string comes in as text (in any case) internally it thinks of it as "@". Basically text is an alias for @. I've also updated the faq and quick-guide in reference to data formats. I didn't see anything right off dealing with the other little features. I plan on committing these changes after I get a chance to look at the final documents and run all the tests.
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: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 3:21 PM To: 'POI Users List' Subject: RE: Feature Request - HSSF Format/Cells/Number/Category/Text Sett ing Also the FAQ probably. We might even want to change the lookup string to "Text" instead of @.. Unless anyone has some compelling reason it should be @.. . But i sure can't think of one... ;-) On Tue, 2002-10-08 at 16:12, Laubach Shawn Contr OC-ALC/PSB wrote: > I'm hoping James will tell me if it works and then I'll put it in the > javadocs for HSSFDataFormat (and any place anyone else recommends). I know > I'm being lazy about it but it will would take me time to test it out right > now. If I don't get an answer, I'll test it myself. > > 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: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 08, 2002 3:10 PM > To: 'POI Users List' > Subject: RE: Feature Request - HSSF Format/Cells/Number/Category/Text > Sett ing > > > 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]> -- 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]>
