jasonrogena / jasonrogena/php-excel-reader

Time values are not read correct after upgrade to 2.22

Open
#75 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. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.