So why don't you just use that for now? Or submit a bugfix patch for getDataFormat(). At the very least why not supply a bug report in our bug tracker?
-Andy Oliver Fuerniss wrote: >as i know the ExcelRead version 1.6.x from Andy Kahn has a function to find >out if the cell is a date. But how it is done if you say that these fields >are always numerical and getDataFormat() always returns 0??? > > >Am Donnerstag, 18. April 2002 16:09 schrieben Sie: > >>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 >>> >
