Not too sure what you are asking here. Are you asking if it is possible to recover the formatted value from a cell as well as it's raw value using POI? If this is the case then the answer is yes. To make use of this, take a look at the HSSFDataFormatter class - http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFDataFormatter.html - you simply pass the cell to the static formatCellValue(Cell) method and it will return to you a formatted string that contains the value as the user would see it if viewing the sheet using Excel. The raw value of the cell can be obtained by calling the correct getter method on the cell object itself. For example, if you have a numeric cell, calling the getNumericCellValue() method will return to you the cells raw value.
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-tp3404980p3408158.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]
