DO NOT REPLY [Bug 32150] New: - Error reading XL sheet when the cell is date data type

[bu...@apache.org]

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: poi-dev@jakarta.apache.org
        ReportedBy: murugank@planetasia.com
                CC: murugank@planetasia.com


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: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org