when applying a format for a cell using the HSSF package of POI I come across
some behaviour which I cannot understand
consider the following to create a style for a number having 2 decimal
places
cellStyleNumber = wb.createCellStyle();
cellStyleNumber.setFont(normalFont);
cellStyleNumber.setDataFormat(hdf.getFormat("0.00"));
and I apply the style using
cell.setCellStyle(cellStyleNumber);
when I open the excel sheet most of the cells have the format correctly but
2 cells dont
actual values are 112.346004986331 and 105.845444762428
if I check the dataformat of the corresponding cells in excel I dont see any
format applied
plz help coz I cant figure this out ... thnkx a million
--
View this message in context:
http://www.nabble.com/dataformat-not-getting-applied-in-excel-tf2864471.html#a8004866
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
