DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=32150>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=32150 Error reading XL sheet when the cell is date data type Summary: Error reading XL sheet when the cell is date data type Product: POI Version: 2.5 Platform: Other OS/Version: Windows NT/2K Status: NEW Severity: Major Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] The HSSFCell class couldn't find out if the cell data type is a date.There is no variable such as HSSFCell.CELL_TYPE_DATE. When there is a date in a cell, it returns numeric value. Also the method HSSFDateUtil.isCellDateFormatted() always return false if there is a date present in a cell.The method HSSFCell.getDateCellValue() works fine , but for any numeric value present in the cell, it gives me a java.util.date object (If the value of the cell is 1, then Mon Jan 01 00:00:00 IST 1900 is returned).What is the fix for this. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
