jasonrogena / jasonrogena/php-excel-reader

Some fields turned '@' while there should be something in it.

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

Use these code to read the file:
val(2, 2);

?>

What is the expected output? What do you see instead?

It should give me '1.1'.
But it gives me '@'.
There are also some more cell like this:

$data->val(1,16); # should give me '2000' but it give me '@'
$data->val(1,17); # should give me '2001' but it give me '@'
$data->val(1,19); # should give me '2003' but it give me '@'

Please provide any additional information below.

```

Original issue reported on code.google.com by `koa...@gmail.com` on 22 Dec 2009 at 8:32

Attachments:
- [SDI2008_raw data bank_dummy data altered.xls](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-57/comment-0/SDI2008_raw data bank_dummy data altered.xls)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with excel_reader2.php and reproduce the reported outputs using the attached XLS file. Check why eval(2, 2) and the listed cells return '@' instead of their expected values, then verify that those cells are read correctly without changing already-correct cell values.

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
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.