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]
