jasonrogena / jasonrogena/php-excel-reader

Special format for integer, wrong value I got...

Open
#112 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

```
Please see my file.
Column 11 (K), string 8.

Format of the cell is setted to "###\ ###\ ##0,00".
In this cell I see value "103,67", but value I got with php-excel-reader is
"104 104 104".

my code:
val(8, 11, 1));
?>

It's so sad...
And I have no ideas how to fix this bug by myself....
```

Original issue reported on code.google.com by `mail4...@gmail.com` on 6 Apr 2011 at 7:01

Attachments:
- [region01_0.zip](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-112/comment-0/region01_0.zip)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the reported value using the attached region01_0.zip file and the eval(8, 11, 1) call in excel_reader2.php. Inspect how the reader handles the cell format "###\ ###\ ##0,00" and compare the parsed result with the displayed value; done means the affected cell returns the expected value without breaking related parsing.

Written by the indexing model from the issue text.

Assessment

Tech stack
php
Domain
data
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.