jasonrogena / jasonrogena/php-excel-reader

Date format not supported

Open
#164 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.upload .xls file with date column as dd-mm-yyyy format
2.parse the file using excel reader
3.output as 43159.

What is the expected output? What do you see instead?
dd-mm-yyyy

Please provide any additional information below
when i open new excel and type the data and then upload,it will working fine.
But it showing error when upload the same file 2nd time.
```

Original issue reported on code.google.com by `evan.r...@gmail.com` on 4 Feb 2013 at 10:36

Attachments:
- [hi.xls](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-164/comment-0/hi.xls)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the issue with the attached hi.xls file: upload it, parse it with the Excel reader, and compare the date output on the first and second uploads. Trace the date parsing path and verify that the dd-mm-yyyy value is returned consistently instead of 43159 or an error.

Written by the indexing model from the issue text.

Assessment

Tech stack
php
Domain
data
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.