jasonrogena / jasonrogena/php-excel-reader

Custom Number format displaying wrong cell data

Open
#114 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

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. 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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.