jasonrogena / jasonrogena/php-excel-reader

Currency symbol (eg £ or $) causing error

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.