On Wed, 15 Feb 2012, tcole6 wrote:
In my current example, I have a column of values that each contain exactly
11 digits. The cells in this column have a custom format applied to them of
"000-00000-000". In the .xlsx file I can see the numberFormat
"000\-00000\-000" with an id of 164 in the styles.xml file.
When I read the cell value using DataFormatter.formatCellValue(cell), I am
returned the numeric value, not the formatted value. In my example I am
getting "12312345123" and not "123-12345-123".
I'd expect that to work properly. If you read the cell style for that
cell, can you verify that the correct style and formatting really is
applied to it?
Also, have you tried with POI 3.8 beta 5, to make sure it's not a bug that
has been fixed?
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
