Bug 19792 - Setting Cell's value to Jan 1, 1900 without a time doesn't return the same value set to
Summary: Setting Cell's value to Jan 1, 1900 without a time doesn't return the same va...
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: PC All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-05-09 05:23 UTC by Donald Bell
Modified: 2008-12-25 10:27 UTC (History)
0 users


Attachments
JUnit that shows bug. (1.53 KB, text/plain)
2003-05-09 05:24 UTC, Donald Bell 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Donald Bell 2003-05-09 05:23:52 UTC 
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);
Comment 1 Donald Bell 2003-05-09 05:24:42 UTC 
Created attachment 6292 [details]
JUnit that shows bug.
Comment 2 Danny Mui 2003-05-09 15:52:40 UTC 
good stuff with the unit tests..ill look at this soon (tm).
Comment 3 Paul Krause 2003-06-04 17:18:05 UTC 
Excel handles (incorrectly) the year 1900 as a leap year, so the serial numbers 
from January 1 to March 1 of that year may be off by one.
Comment 4 Andy Oliver 2003-07-24 16:31:16 UTC 
Should be looked out...sounds like an Excel bug....  REgardless its not serious
enough to hold up 2.0
Comment 5 Tom 2005-12-16 09:29:50 UTC 
The Summary and initial description stated 1990 was the issue, but the unit 
test and subsequent comments show the problem as being with the year 1900. 
Changed the summary to reflect that that it is an issue with 1900 not 1990.
Comment 6 Yegor Kozlov 2008-12-25 10:27:37 UTC 
The latest POI 3.5-beta4 works properly. 

Yegor