On Thu, 1 Mar 2012, mouss4rs wrote:
With hh:MM format i have:
12:00:00
when i did this:
cell.setCellValue(10.5);
I must have 10:30.
If you set a value of 10.5, then getting a time of 12:00 is entirely to be
expected. Times in excel are stored as fractions of a day, so you've set a
time of 0.5 => 12:00. This is how Excel works, nothing special about POI
You probably want something like cell.setCellValue(10.5 / 24.0) to get
10:30
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
