jasonrogena / jasonrogena/php-excel-reader

Incorrect value when retrieve number from downloaded SSRS Excel

Open
#175 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?
I download xls file from SSRS.
I use this simple code below to read the file :

$data = new Spreadsheet_Excel_Reader($file);
$data->val($row,$col);

the column value is 1,040,809,656.00
output from code above is
[$-1,040,809,6561,040,809,6561,040,809,6561,040,809,6561,040,809,6561,040,809,65
61,040,809,656]1,040,809,6561,040,809,6561,040,809,6561,040,809,656.1,040,809,65
61,040,809,656

What is the expected output? What do you see instead?
the expected value is 1,040,809,656.00 (same value of excels)

Please provide any additional information below.
is there any possibility of encode setup?
because if i open and resave in Excel97/2000/XP type, the value will be
retrieved as excel value (ex : 1,040,809,656.00)
```

Original issue reported on code.google.com by `danang.w...@gmail.com` on 10 Jun 2013 at 3:54

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the issue with the SSRS-downloaded XLS file and the Spreadsheet_Excel_Reader->val($row, $col) entry point. Compare its result with the Excel value shown in the report, and consider the issue resolved when the reader returns 1,040,809,656.00 without requiring the file to be resaved.

Written by the indexing model from the issue text.

Assessment

Tech stack
php
Domain
backend
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.