You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2003/05/09 07:23:53 UTC

DO NOT REPLY [Bug 19792] New: - Setting Cell's value to Jan 1, 1990 without a time doesn't return the same value set to

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=19792>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=19792

Setting Cell's value to Jan 1, 1990 without a time doesn't return the same value set to

           Summary: Setting Cell's value to Jan 1, 1990 without a time
                    doesn't return the same value set to
           Product: POI
           Version: 2.0-dev
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: donald@bell.name


When setting a cell's value to Jan 1, 1990 without a time the returned value 
doesn't return the doesn't return the same date.  It returns a date one date 
later on Jan 2, 1990.

Calendar cal = Calendar.getInstance();
		
// A pseduo special Excel dates
cal.set(1900, 0, 1);
	
Date valueToTest = cal.getTime();
		
HSSFCell cell = getNewCell();
		
cell.setCellValue(valueToTest);