jasonrogena / jasonrogena/php-excel-reader

Date format, cells with 0 and a question

Open
#23 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

```
Hi,
first of all many thank for yr good library. I'm sure that will have a
great future. Have two small problems and a question :
- have an excel file where the format of the dates is mmmm yyyy (May 2009)
but the array created by the function shows May/2009 (space is replaced by
the /) See attached file cells C8:C128
- the dump function doesn't display cella where the value is 0 even if the
array is created correctly (see cell B8). This is not a big issue because
problem seems limited to the dump function

The question is : is it possible to show/know that a cell contains a
formula (and maybe retrieve the original formula) ? See cell G9

Tks, regards
```

Original issue reported on code.google.com by `vve...@hotmail.it` on 15 May 2009 at 1:11

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

Contributor guide

No contributing guide indexed for this repository

Research direction

Use the attached test.xls to reproduce the date formatting and zero-value behavior, starting with the library's array creation and dump function entry points. Check the formula cell mentioned as G9 and determine whether formula visibility belongs in the same work. Done means the reported behaviors are reproducible and each requested outcome is explicitly verified.

Written by the indexing model from the issue text.

Assessment

Tech stack
php
Domain
backend, data
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.