jasonrogena / jasonrogena/php-excel-reader

Problem with readed date.

Open
#78 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

```
What steps will reproduce the problem?
1.Write 16/06/2010 09:20:01 in any cell of Excel 2007 and save file
2.Use PHP Excel Reader to read the Cell
3. The result is 17/06/2010 04:20:00 instead 16/06/2010 09:20:01

What is the expected output? What do you see instead?
17/06/2010 04:20:00 instead 16/06/2010 09:20:01

Please provide any additional information below.
The XLS file was made with Excel 2007 saved as excel 97-2003 format.
```

Original issue reported on code.google.com by `memin.co...@gmail.com` on 5 Jul 2010 at 11:04

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce the problem with an Excel 97-2003 file created by Excel 2007 containing the stated date and time, then trace the library's cell date-reading path. Done means the reader returns 16/06/2010 09:20:01 rather than the reported 17/06/2010 04:20:00.

Written by the indexing model from the issue text.

Assessment

Tech stack
php
Domain
backend
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
28/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.