jasonrogena / jasonrogena/php-excel-reader
date offset by 1 day (date décalé d'un jour)
- Dominant language
- PHP
- Stars
- 1
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
```
for those who have the problem of date, offset by 1 (eg 18/10/2011 10/19/2011
affcihe), so I think I found the solution:
go to file: read.php:
$utcValue = round(($utcDays+1) * SPREADSHEET_EXCEL_READER_MSINADAY);
change it on:
$utcValue = round(($utcDays) * SPREADSHEET_EXCEL_READER_MSINADAY);
//**********************************french*************************************
pour ceux qui ont le problème de date qui est décalé de 1 (exemple:
18/10/2011 affcihe 19/10/2011) , alors je crois que j'ai trouvé la solution:
aller dans le fichier: read.php :
$utcValue = round(($utcDays+1) * SPREADSHEET_EXCEL_READER_MSINADAY);
change le au:
$utcValue = round(($utcDays) * SPREADSHEET_EXCEL_READER_MSINADAY);
sinon vous trouvrez le fichier join .rar ci-dessous:
```
Original issue reported on code.google.com by `herrim...@gmail.com` on 18 Nov 2011 at 12:19
Attachments:
- [phpExcelReader.rar](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-132/comment-0/phpExcelReader.rar)
Contributor guide
No contributing guide indexed for this repository
Research direction
Start in read.php at the SPREADSHEET_EXCEL_READER_MSINADAY calculation and trace how Excel dates are converted to displayed dates. Reproduce the one-day offset with the reported example, then verify the corrected conversion against additional date values and confirm the displayed dates are accurate.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php
- Domain
- backend
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 48/100