jasonrogena / jasonrogena/php-excel-reader
Wrong date values when formatting thru OpenOffice spreadsheet.
- 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