jasonrogena / jasonrogena/php-excel-reader

Custom and wrong number formats not read

Open
#50 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.Use a sheet with custom number formats in cell. When the syntax of the format
is wrong, the
lib doesn't read the value of the cell.

What is the expected output? What do you see instead?
Instead of reading the cell's value, it outputs the actual (wrong) syntax of
the number format.

Please provide any additional information below.
For instance i received a spreadsheet from a customer with custom number
formats: ???, ????, ???
??. Now, for all the cells that use these formats, the class returns ???, ????,
?????.

Anyone had the same problem? I know I could just remove all the formats, but it
should be
automated somehow in my project, because the files are sent by machines not by
users.

THANKS !
```

Original issue reported on code.google.com by `attana...@gmail.com` on 14 Oct 2009 at 1:26

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the issue with a spreadsheet containing malformed custom number formats, including the examples in the report. Trace the cell-value reading path and verify that cells using invalid formats return their values rather than the format syntax; no file or test location is named in the issue.

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
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.