How dose POI [h]:mm:ss dataformat work?

[lcai]

I was trying to read some data like "27:10:11" from a file and put into a
cell, I set the cell type to HSSFCell.CELL_TYPE_NUMERIC and cell style to
[h]:mm:ss But it didn't work, in the Excel I got "613683:10:11".

code:

HSSFCellStyle style = wb.createCellStyle();
style.setDataFormat(HSSFDataFormat.getBuiltinFormat("[h]:mm:ss"));

SimpleDateFormat df = new SimpleDateFormat("HH:mm:ss");
Date date = df.parse(value);

cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
cell.setCellValue(date);
cell.setCellStyle(style);

any suggestion?

thanks
-- 
View this message in context: 
http://www.nabble.com/How-dose-POI--h-%3Amm%3Ass-dataformat-work--tp16966115p16966115.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]