Here is the third bug I've found today. I have sent the other 2 separately. There is no rush to fix these, so I am happy to wait till all three have been fixed. Of course if it is me that is not using the driver correctly then that would be even better.
I formatted some times and timestamps in the the Workbook LazyTest2.xls which I shall email to you. The columns are on the "Formatting" Sheet.
If you look at the first row of the Time column, the value is 12:23:00 but when I read the value using either getString() or getTime() i get 12:22:59
Similarly with the third row of the Timestamp column, the value is 13/11/2012 02:22:09 but when I read the value using getString() or getTimestamp() I get 2012-11-13 02:22:08.0
(I'm not bothered by the formatting - its the rounding of the seconds)
I guess it's the way that Excel stores times?
Checked. It's resulted by MS Excel doesn't handle miliseconds. HXTT Excel will round miliseconds to seconds now too.
Thanks - that works perfectly as well.