poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 32150] New: - Error reading XL sheet when the cell is date data type
Date Wed, 10 Nov 2004 09:57:51 GMT
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


Mime
View raw message