Thanks Mark - your reply helped. it didn't occur to me to go into EXCEL and
test it. one thing lead to another, and i noticed i had an extra
parenthesis in the statement. removed that - works great.
steve
Mark Beardsley wrote:
>
> At a glance, that data format should work - but, I do not think you need
> the brackets. Try this;
>
> cs.setDataFormat(HSSFDataFor
> mat.getBuiltinFormat("$#,##0.00;-$#,##0.00"));
>
> I have tested that format sting using Excel and it does display the
> trailing zero.
>
> One thing I did notice though from the code you posted was this;
>
> row.createCell(13);
> Cell mycell2 = row.getCell(13);
> mycell2.setCellStyle(cs);
> mycell2.setCellValue(dDebtAmt);
>
> Now, really, the code should read like this;
>
> Cell mycell2 = row.createCell(13);
> mycell2.setCellStyle(cs);
> mycell2.setCellValue(dDebtAmt);
>
> The create method will return a new cell object to you. This might - and
> that is might - be the source of the problem. The get methods are usually
> used if you are editing an existing worksheet and the cells do already
> exist.
>
> Yours
>
> Mark B
>
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/dataformat-tp4266621p4274179.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]
