jasonrogena / jasonrogena/php-excel-reader

Wrong date values when formatting thru OpenOffice spreadsheet.

Open
#54 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. Open a microsoft excel document (.xls);
2. Update its date format;
3. Save as .xls using OpenOffice;

What is the expected output? What do you see instead?
When I tried to echo a value on a specic formatted column/row,
php-excel-reader seems to get lost and bring different values. The expected
output would be (for example): 29/12/2009 on a DD/MM/YYYY (OpenOffice cell
format) but it shows: TueTue/DecDec/2009200920092009. It seems OpenOffice
document formats its cell with a different format than Microsoft Excel,
wich works perfectly when I saved the document on another computer with
Windows.

Please provide any additional information below.
I believe this is an interesting bug because plenty people uses OpenOffice
and documents created by it. And congratulations on this awesome php class!
10/10
```

Original issue reported on code.google.com by `gui...@gmail.com` on 28 Nov 2009 at 12:49

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the issue with an OpenOffice-saved .xls file, updating a date format, and reading the formatted value through php-excel-reader. Trace how the reader interprets the OpenOffice date format and verify that a DD/MM/YYYY value is returned as 29/12/2009 rather than repeated format tokens.

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
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.