I have a web module that takes an excel list and gives back the data of certain columns in xml. The truth is that the bookstore that I mention in the title goes very well. The problem appears when i run the web site with apache under MAC (Apple); specifically the column of the dates. In this situation the dates are increased in a day and i dont know the reason.
date name U$S
10/05/2009 santiago 100
11/05/2009 juan 75
12/05/2009 pedro 125
The conversion, installed the page in apache under MAC gives back the following thing to me
11/05/2009 santiago 100
12/05/2009 juan 75
13/05/2009 pedro 125
I stumbled over the same problem yesterday maybe found a solution.
I replaced the function createDate() found with a version found at
from Nelson Hereveri
# with the followind defines (my local/desired date/time format)
define('AIRVIRO_DATE_FORMAT', 'd.m.Y'); // DD.MM.YYYY (en el post eran con dos puntos)
define('AIRVIRO_HOUR_FORMAT', 'H:i:s'); // HH:MM:SS
define('AIRVIRO_FULLDATE_FORMAT', 'd.m.Y\ H:i:s'); // DD.MM.YYYY HH:MM:SS
# and those modifications
#$secs = intval(floor($parteDecimal * SPREADSHEET_EXCEL_READER_MSINADAY) - $hours * 60 * 60 - $mins * 60);
$secs = intval(ceil($parteDecimal * SPREADSHEET_EXCEL_READER_MSINADAY) - $hours * 60 * 60 - $mins * 60);
# with 'floor' the secs value was always 1 to low
# $utcValue = round(($utcDays+1) * SPREADSHEET_EXCEL_READER_MSINADAY);
$utcValue = $utcDays * SPREADSHEET_EXCEL_READER_MSINADAY;
# I have no idea what the '+1' could be necessary for and for me the results now seem correct
Also very interesting reading was about the leap year bug within Excel
Enviado por Ale (no verificado) el Mié, 10/12/2008 - 06:29.
found it in the bug list:
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.