jasonrogena / jasonrogena/php-excel-reader
Date/Time fields come back as literal "M/d/yyyy h:mm:ss AM/PM"
- 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