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
