Can somebody tell me what i'm doing wrong here? (I'm new to this, so i could be
done something nonsensical).
the amount in the cell is format correctly, EXCEPT, the trailing zeros are
dropped.
the data comes in like this:
175.09
176.1 (i want it to be 176.10 but that's another story)
176.00
in the spreadsheet it looks like
175.09
176.1
176
of course i want
175.09
176.10
176.00
other than this it's working great!
thanks
// set the style for the debtamt column
CellStyle cs = wb.createCellStyle();
// DataFormat dataformat = wb.createDataFormat();
cs.setDataFormat(HSSFDataFormat.getBuiltinFormat("($#,##0.00);($#,##0.00)"));
.........
row.createCell(13);
Cell mycell2 = row.getCell(13);
mycell2.setCellStyle(cs);
mycell2.setCellValue(dDebtAmt);
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
