jasonrogena / jasonrogena/php-excel-reader
Custom Number format displaying wrong cell data
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 1
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
```
What steps will reproduce the problem?
1. Use the attached file and don't open it.
2. Upload it to server
3. echo $xls->val(3,10); on the attached excel file.
What is the expected output? What do you see instead?
Expected Output: 7.5
See Instead: 8888.88
Please provide any additional information below.
The 10th column has a custom number format of #,##0.00
If I resave the file from my computer it seems to fix the problem. Also if if i
create a test file with the same custom number format it seems to work just
fine. For some reason the two columns, "qty" and "wt" don't display correctly
unless I resave it and then upload. If I create a completely new spreadsheet
from my computer and use the custom number format it also seems to work but on
the attached excel file it doesn't. Hope that makes sense since this my first
post ever about a problem.
```
Original issue reported on code.google.com by `danielas...@gmail.com` on 20 Apr 2011 at 6:24
Attachments:
- [Inventory USA_20110419002000_26489.xls](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-114/comment-0/Inventory USA_20110419002000_26489.xls)
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the report with the attached Inventory USA_20110419002000_26489.xls file and the $xls->eval(3,10) entry point. Trace how the reader handles the 10th column's #,##0.00 custom format and verify that the qty and wt values produce 7.5 rather than 8888.88 without resaving the workbook.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php
- Domain
- data
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100