#11 patch for 'Date' cell problem.

[MACHIDA Hideki]

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.

[MACHIDA Hideki]

[Nobody/Anonymous]

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

[Nobody/Anonymous]

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