jasonrogena / jasonrogena/php-excel-reader
Problem while reading formatted date from cell
- Dominant language
- PHP
- Stars
- 1
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
```
What steps will reproduce the problem?
1. Please see the attached sheet with Birthdate formatted
2. 5/15/1985 -> 15-May-1985 (formatted from excel sheet)
3.
What is the expected output? What do you see instead?
When i read the excel sheet, the output is 'd0576' instead of '5/15/1985',
Expected output should be '5/15/1985'
Please provide any additional information below.
Actual date entered in sheet is '5/15/1985'
Formatted birth date to '15-May-1985'
Output is 'd0576'
```
Original issue reported on code.google.com by `tezurfri...@gmail.com` on 30 Sep 2011 at 7:22
Attachments:
- [test.xlsx](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-128/comment-0/test.xlsx)
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by opening the attached test.xlsx and reproducing the formatted birthdate read. Trace the reader's date-handling entry point to determine why the formatted cell produces "d0576"; done means the same cell returns "5/15/1985" as expected.
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
- 35/100