I don't think this is POIs problem. I have experienced the same thing when using Calendars in my software. I tried to get a date as close to the end of the day as possible, but if I didn't set the milliseconds to 0 it would magically wrap the date over to the next day. I found that a SimpleDateFormat was displaying a different date to what was actually displayed from a Calendar.toString(). My guess is when POI set the date the value it retrieved from the Calendar/Date was already incremented.
This was all on J2SE 1.4.1
HTH
Chris
George Papastamatopoulos wrote:
Hey thanks for the reply.
Actually was able to narrow the problem down further.
Turns out the dates I was using in my application were all set to the last millisecond of the day eg 23:59:59:999. Looks like excel was rounding this value up to the nearest second, thus pushing the value displayed in the cell to the next day. I think (although my understanding of excel is limited) this would be due to the fact that excel understands only hours, minutes and seconds?
george
-----Original Message----- From: Danny Mui [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 June 2003 12:36 AM To: POI Users List Subject: Re: Dates, Dates and more dates.
Yeah, I know the dates are a little off at the moment, and is related to http://nagoya.apache.org/bugzilla/show_bug.cgi?id=19792. Currently working on other parts of HSSF but I will try to address it within the "soon" timeframe.
IF you want to give it a stab, you can look at the HSSFDateUtil and determine where it strays. Basically excel stores date in double format, so make sure the DateUtil generates the correct double values for known dates.
danny
George Papastamatopoulos wrote:
Hi
Im experiencing some really wierd and frustrating behaviour when dealing with dates.
Whenever I generate a spreadsheet with dates and then open up the spreadsheet, the value displayed in the cell is always one day ahead of the value displayed in the formula bar (the formula bar always displays the correct date). What's wierd is that when I click into the cell edit, and then hit enter, the correct date is then displayed in the cell.
I've searched the archives and have seen similar postings relating to 'how to read dates from excel', but havnt come across any solutions.
I've tried all sorts of combinations and permutations of cell styles, formats etc, but have been unable to solve the problem.
If anyone has suggestions, they would be much appreciated. I've pasted in the latest code snippet below.
Cheers george
....
HSSFCellStyle cellStyle = wb.createCellStyle(); HSSFDataFormat format = wb.createDataFormat();
cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy")); cell.setCellStyle(cellStyle);
Date myDate = myObject.getTheDate();
cell.setCellValue(myDate); cell.setCellValue(HSSFDateUtil.getExcelDate(myDate));
/** * Also tried the following and a bunch of other things */ // cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); // cell.setCellValue(myDate); ....
__________________________ George Papastamatopoulos
Lawlex Compliance Solutions phone: +61 3 9278 1182 email: [EMAIL PROTECTED] __________________________
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
