jasonrogena / jasonrogena/php-excel-reader

Date/Time fields come back as literal "M/d/yyyy h:mm:ss AM/PM"

Open
#65 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?

starting with:
$data = new Spreadsheet_Excel_Reader("example.xls");

1. A column where it's contents viewed in Excel might be "2/23/2010
9:59:20 PM" comes back from the call as a literal "M/d/yyyy h:mm:ss AM/PM"

2. All text valued columns are being intrepreted correctly

3. Dollar valued fields are coming back "doubled/tripled" for example the
value $1,070.00 comes back from the call as [$$-1,0701,0701,0701,070]
1,0701,0701,0701,070.1,0701,070);([$$-1,0701,0701,0701,070]
1,0701,0701,0701,070.1,0701,070)

4. A plain numeric field such as 159 is coming back from the call as
159159159159

Please provide any additional information below.
The Row/column stat count functions work but the "type" and "raw"
functions do not work. Help! I really wanted to work with this class.
Thanks! Jay

```

Original issue reported on code.google.com by `j...@jay-pennington.com` on 23 Feb 2010 at 10:53

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the Spreadsheet_Excel_Reader("example.xls") reproduction described in the issue and inspect how its type and raw calls handle date/time, currency, and numeric cells. Confirm the behavior against the examples provided; done means these values are returned once in usable forms rather than as repeated or literal format strings.

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
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.