Is that Andy's (Andy Khan) JExcelAPI you are referring to? If so, then it is possible to create numeric cells there - using the jxl.write.Number class - and I would look to do this as a first step. It will make life a lot easier if the cells type is set correctly when the file is created IMO. That way, you should be able to set the cell style - and the associated format using his WritableCellFormat class - so that the numbers are displayed with a single value after the decimal point right at the point of creation. To my mind, this would be a more technically correct solution - try to prevent the problems from ocurring in the first place raher than address them afterwards.
Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Round-to-one-Decimal-place-not-happenning-using-style-setDataFormat-format-getFormat-0-0-tp3404980p3413852.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]
