Nick Burch wrote:
>
> On Tue, 29 Apr 2008, lcai wrote:
>> 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".
>
> 27:10:11 isn't a valid time, could that be it?
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
But [h]:mm:ss is supposed to support the long hours datetime. I have to set
a Java Date object into to the cell if I want POI use dataformat work
properly. But when I set 27:10:11 into Java Date object, it will become 1
day 3 hours 10 mins 11 sec.... according the POI API, it's supposed to be
able to handle it. Is there any thing I did wrong?
--
View this message in context:
http://www.nabble.com/How-dose-POI--h-%3Amm%3Ass-dataformat-work--tp16966115p16985779.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]
