Really? Details please! Didn't see any way to use custom date formats in 1.5.1.
Eric > -----Original Message----- > From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 05, 2003 7:50 PM > To: POI Users List > Subject: Re: Dates, Dates and more dates. > > > Not true. Custom formats are available. > > On 6/5/03 7:13 PM, "George Papastamatopoulos" > <[EMAIL PROTECTED]> wrote: > > > ahhh.. thanks. > > > > -----Original Message----- > > From: Eric Hsiung [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 5 June 2003 9:53 PM > > To: 'POI Users List' > > Subject: RE: Dates, Dates and more dates. > > > > > >> Turns out the dates I was using in my application were all > >> set to the last > >> millisecond of the day eg 23:59:59:999. Looks like excel was > >> rounding this > >> value up to the nearest second, thus pushing the value > >> displayed in the cell > >> to the next day. I think (although my understanding of excel > >> is limited) > >> this would be due to the fact that excel understands only > >> hours, minutes and > >> seconds? > >> > >> george > > > > Excel can display up to milliseconds but you'll have to > > specify a custom format of "m/d/yyyy h:mm:ss.00". > > Alas, you cannot do this via POI since custom formats are > > not available. :-( > > > > > > Eric > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > -- > Andrew C. Oliver > http://www.superlinksoftware.com/poi.jsp > Custom enhancements and Commercial Implementation for Jakarta POI > > http://jakarta.apache.org/poi > For Java and Excel, Got POI? > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
