jasonrogena / jasonrogena/php-excel-reader

Can't properly read scientific (00E+00) data format

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

Read any XLS file with scientific 00E+00 formatted cells

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

it will print 00E+00 in all cells

Please provide any additional information below.

```

Original issue reported on code.google.com by `petrak...@gmail.com` on 24 Jul 2009 at 3:59

Attachments:
- [D451-example.xls](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-38/comment-0/D451-example.xls)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the problem with the attached D451-example.xls file, focusing on cells using the scientific 00E+00 format. Trace the XLS value-reading path and verify that the output preserves the numeric value instead of printing the literal 00E+00 text.

Written by the indexing model from the issue text.

Assessment

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