jasonrogena / jasonrogena/php-excel-reader

date offset by 1 day (date décalé d'un jour)

Open
#132 0 comments 0 reactions 0 assignees View on GitHub
auto-migrated Priority-Medium Type-Defect
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.