Had a quick play and the idea of creating a new cell to replace the existing one will not change the cells type successfully, it reamains set as General despite everything I can do in POI code. So, I thought I would try a VBA macro - a macro can do anything the user can and it is a trivial task to change the cells type in this manner. Doing this, I discovered that the worksheet contains overlapping areas of conditionally formatted cells and that this feature is not supported with early versions of the binary file format such as the one POI targets. Can I ask, do you know which application was used to create the file, which version of that application was used and, finally, whether the workbook was originally an xlsx rather than a xls file - was it one of the newer OOXML based workbooks?
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-tp3404980p3413732.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]
