I found another issue today regarding the CellFormat that does make it nearly impossible for me to use.
In an excel spreadsheet there is a numeric cell with the contents 0.0005. Using the following code: CellFormat cf = new CellFormat(cell.getCellStyle().getDataFormatString()); data[i][j] = cf.apply(cell).text; Results in the data[i][j] containing the string 5.0E-4. So now I would have to go about determining that the results were in SN, and go about converting this. This occurence I hit way more often than the one custom format that I still have to fix so for now I will have to switch back to the DataFormatter (which returns me 0.0005 in the above example) and work it out from there. Thanks again for your assistance. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Reading-cell-values-that-have-a-custom-format-tp5486315p5498921.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]
