What is the format string for the cell with contents 0.0005 that is being returned as 5.0E-4? Is it '@'?
Using DataFormatter and CellFormat together as you suggest sounds like it has potential, although (I assume) you will need to examine the cell format string and determine which class to use. >From my experience, DataFormatter has been reliable for standard formats. But I found that DataFormatter does not support scaling commas and quoted/escaped text in the format which was why I looked at CellFormat. I'm interested in whether your approach works. Please post back with how you get on. Steve -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Reading-cell-values-that-have-a-custom-format-tp5486315p5500416.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]
