jasonrogena / jasonrogena/php-excel-reader
Time values are not read correct after upgrade to 2.22
- Dominant language
- PHP
- Stars
- 1
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
```
What steps will reproduce the problem?
1. Upgraded to 2.22
2. Import excel file
3. Printed raw, val and type values
What is the expected output? What do you see instead?
Time column data results return 02:00 no matter what time data is stored.
What version of the product are you using? On what operating system?
Ubuntu / 2.22
Please provide any additional information below.
After upgrading to 2.22 to solve encoding problem reader doesn't read time
data correctly. Data on excel file is 06:00, after reading raw() returns
0.25, val() returns 02:00. Excel file cell format for that column is
hour:minutes and same excel file didn't have any problems with previous
version.
```
Original issue reported on code.google.com by `blockedm...@gmail.com` on 6 May 2010 at 8:57
Contributor guide
No contributing guide indexed for this repository
Research direction
Reproduce the import with the reported Excel file and version 2.22 on Ubuntu, then trace the code path that converts the time cell for raw() and val(). Done means a stored 06:00 value is returned as 06:00 rather than 02:00, while raw() remains correct.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php
- Domain
- tooling
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100