Heres the code mentioned ealier on the dev mailing list.
Created attachment 2440 [details] Code patch to add number formatting (and my name to developer list)
Created attachment 2441 [details] Test xls file for the test I added to workbook.
Ignore previous patch. I went with the suggestion on the developers list and set it up where you create a instance of HSSFDataFormat. The test file is still valid. I've also will include an example and updated the quick-guide with the example.
Created attachment 2493 [details] New Patch
Created attachment 2494 [details] Data Example
Hi Shawn. After applying these patches all the unit tests failed and several examples didn't compile. Please run "./build.sh clean compile test", reopen and resubmit the corrected patch.
Please forgive me. I found and fixed all the problems except one test still fails. It is org.apache.poi.hpfs.basic.TestBasic or something like that. Since I didn't have anything to do with that, I just skipped it. All other tests now pass and everything compiles. Again, I'm sorry.
Created attachment 2507 [details] The newest patch. Patches other things that I broke by instantiating HSSFDataFormat
Created attachment 2508 [details] Example code and test file to use zipped up nicely
cool I'll apply it later if glen or someone doesn't beat me to it... I'm sun-poisoned and exhausted. Worked at Habitat for humanity today... (volunteer organization that builds houses for needy people)
applied, please cross check. Sorry Shawn forgot about this... Applied portions by hand. Made some stylistic changes in HSSFWorkbook (removed predeclaring of "int i" in the for loop -- confusing... removed predeclared loop temp value...same reason) Please cross check.