am using Apache POI HSSF to generate an Excel spreadsheet from my Java Web app.
I need a cell formatted as *"Number"* with 2 decimal points. (My values in Java are BigDecimals, but I can convert them to doubles, no problem.) I am using this code: The issue is that, even though this works, Excel still shows my cells as /*General*/. But they need to be shown as /*Number*. /As a result, for example, 0 is shown as 0, but it should be 0.00, which would happen if the format was correct (Number). I see that it gets generated as General because I can right-click on a cell and then choose "Format Cells" to see what it is right now. Any ideas? Thanks -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Cell-Type-Still-Shows-Up-as-General-Even-Though-It-s-Number-Formatted-tp4922056p4922056.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
