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=30302>. 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=30302 cell.getDateCellValue() returns 10:59:59 instead of 11:00:00 Summary: cell.getDateCellValue() returns 10:59:59 instead of 11:00:00 Product: POI Version: 2.5 Platform: PC OS/Version: Windows XP Status: NEW Severity: Critical Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] I am loading cells on a hour base. The cells are formatted as TT.MM.JJJJ hh:mm, Language is German. The Sheet looks like this 01.01.2005 00:00 01.01.2005 01:00 01.01.2005 02:00 etc. The Cells are calculated like this: =(A1+$D$1), where d1 is a helper cell that holds an hour 01:00 formatted hh:mm The Sheet has rows for one year (365*24=8760 Rows). I loop through all the rows an fetch the date and on the row of Sun Apr 10 I get the Date as 10:59:59 CEST 2005 Numeric Val= 38452.458333327544, instead of 11:00:00! After this Date all the times are wrong, it means also, I get on that day 25 values back and everything screws up! Kind reagrds Heinz --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
