jasonrogena / jasonrogena/php-excel-reader
Currency symbol (eg £ or $) causing error
- Dominant language
- PHP
- Stars
- 1
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
```
What steps will reproduce the problem?
1. Do a Currency format on number (eg. 10.65 to either £10.65 or $10.65)
2. $data = new Spreadsheet_Excel_Reader("$filename",false);
3. print_r($data);
What is the expected output?
Array output from;
$data = new Spreadsheet_Excel_Reader("$filename",false);
$rows = $data->rowcount($sheet_index=0);
$cols = $data->colcount($sheet_index=0);
print_r($data);
...
[6] => $55.43
[7] => $44.95
...
What do you see instead?
Array output from;
$data = new Spreadsheet_Excel_Reader("$filename",false);
$rows = $data->rowcount($sheet_index=0);
$cols = $data->colcount($sheet_index=0);
print_r($data);
...
[6] => [$$-55]55
[7] => [$$-45]45
...
Please provide any additional information below.
[7] => [$£-67]67
```
Original issue reported on code.google.com by `PDFmarke...@gmail.com` on 28 Sep 2010 at 10:44
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the reported case with Spreadsheet_Excel_Reader using an Excel file containing £10.65 or $10.65 currency-formatted cells, then inspect how the reader handles the resulting currency format strings. Confirm that the parsed array contains the displayed currency values rather than strings such as [$$-55]55 or [$£-67]67.
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