Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#11 patch for 'Date' cell problem.

open
nobody
None
5
2006-04-11
2006-04-11
MACHIDA Hideki
No

When the value of 'Date' cell is '8:10', parsed value
becomes "8:09".

There seems to be a problem in the processing of the
real number.
When 'round' was used instead of 'floor', it was safe.

This path for svn rev 18.

Discussion

  • Logged In: NO

    My problem is similar. The real date in excel file is: 30-10-2007 9:00:00 The cell has this format: Custom dd-mmm So i read 30-oct in excel but the output is 31-oct I used this patch but doesnt works. Sorry

     
  • Logged In: NO

    Hi, few minutes ago i sent this comment:"My problem is similar. The real date in excel file is: 30-10-2007 9:00:00
    The cell has this format: Custom dd-mmm So i read 30-oct in excel but
    the output is 31-oct I used this patch but doesnt works. Sorry". Well, i have a solution (MACHIDA Hideki gave a clue) you must replace this line: $utcValue = round(($utcDays+1) * SPREADSHEET_EXCEL_READER_MSINADAY); For this line $utcValue = round(($utcDays) * SPREADSHEET_EXCEL_READER_MSINADAY);

    Greetings! enlaze.cl