jasonrogena / jasonrogena/php-excel-reader
Incorrect value when retrieve number from downloaded SSRS Excel
- 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