jasonrogena / jasonrogena/php-excel-reader

Problem while reading formatted date from cell

Open
#128 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. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.