jasonrogena / jasonrogena/php-excel-reader
Wrong reading time field from ods file
Open
auto-migrated
Priority-Medium
Type-Defect
- Dominant language
- PHP
- Stars
- 1
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
```
I load an ods file. In the sheet, I've a time field, like 14:23:12.
php-excel-reader found 15:23:12 for the field (1 hour increased).
It's ok for the same file save in format xlsx.
Tanks,
Eric.
```
Original issue reported on code.google.com by `quinton....@gmail.com` on 17 Jun 2014 at 7:22
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the reported difference with an ODS file containing a 14:23:12 time field, then compare the ODS and XLSX reading paths. Done means the ODS value is read as 14:23:12 rather than 15:23:12.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php
- Domain
- backend
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100