jasonrogena / jasonrogena/php-excel-reader

Miltary format Time Bug

Open
#116 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

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. Create a sheet with any field having military format time like: 13:50
2. Now in any cell enter 02:30, which is actually 02:30 AM.
3. When you'll dump the xls sheet it will show 17:00 for any time falling
before 12:00 pm.

What is the expected output? What do you see instead?

It should print actual time that is 02:30. As it is.

Please provide any additional information below.

```

Original issue reported on code.google.com by `muhd.saj...@gmail.com` on 28 Apr 2011 at 3:23

Attachments:
- [dumysheet.xls](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-116/comment-0/dumysheet.xls)

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by inspecting the attached dumysheet.xls and reproducing the reported behavior: enter 02:30 in a cell formatted for military time, then dump the sheet. Done means the dump preserves 02:30 rather than showing 17:00; the issue does not name a source file or test to start from.

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.