Yes but if it's displaying as a date in a sheet then the data format must be set - right?
----- Original Message ----- From: "Andrew C. Oliver" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 12:15 AM Subject: Re: How to find out if a cell contains a Date > No...if there is not dataformat set, then it will always be 0. > > Glen Stampoultzis wrote: > > >Dates are actually stored by Excel as numeric. getDataFormat() sounds like > >a bug. We will investigate. > > > >Regards, > > > >Glen Stampoultzis (TriNexus Pty Ltd) > >+63 3 9753-6850 0402 835 458 > >ICQ: 62722370 EMail: [EMAIL PROTECTED] > > > >----- Original Message ----- > >From: "Oliver Fuerniss" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Thursday, April 18, 2002 11:25 PM > >Subject: How to find out if a cell contains a Date > > > > > >>Hello, > >>i am using the poi dev version 1.5.0 and i have the following questions: > >>Is there an way to find out, if the current cell contains a date? The > >> > >method > > > >>getCellType() delivers always CELL_TYPE_NUMERIC for my dates. Why is there > >> > >no > > > >>constant for cell.getCellType() like HSSFCell.CELL_TYPE_DATETIME? > >>Also cell.getCellStyle().getDataFormat() is always 0 (General). > >>Thanx > >> Oliver > >> > > > > > > > > >
