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 30302] New: - cell.getDateCellValue() returns 10:59:59 instead of 11:00:00
Date Sat, 24 Jul 2004 06:31:06 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=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: poi-dev@jakarta.apache.org
        ReportedBy: heinzernst@yahoo.com


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: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org


Mime
View raw message