Bug 65267 - FORMATTING: Inputting times as HHMM to cells formatted as HHMM produces unexpected results
Summary: FORMATTING: Inputting times as HHMM to cells formatted as HHMM produces unexp...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: high minor
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-06-02 14:20 UTC by tulitomaatti
Modified: 2017-10-16 18:54 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description tulitomaatti 2013-06-02 14:20:17 UTC
Problem description: 

When trying to input a time, for example a quarter past four in the afternoon as HHMM, that is 1615, to a cell with a format code HHMM, the result is something else than 1615. Inputting 1615 results to 06/02/1904 00:00:00. It seems to me that the input is being interpreted as a date.

Steps to reproduce:
1. Set cell format code to HHMM
- Right click on cell, choose Format cell...
- Set format code to HHMM and click ok. 

2. Input time as HHMM
- Enter a time, for example 1615 and press enter.

3. Cell displays now 0000 and holds a wildly different time.


Current behavior:

Cell displays 0000 and contains a date from 12/30/1899 00:00:00 to 06/16/1906 00:00:00 depending on the time entered, assuming that a time from 0000 to 2359 is entered. 

Expected behavior:

Cell displays the time entered and contains the time entered. 
              
Operating System: Mac OS X
Version: 4.0.2.2 release
Comment 1 Jorendc 2013-06-02 14:23:08 UTC
Thanks for reporting.

I can reproduce this using Linux Mint 15 x64 with LibreOffice 4.0.3.3, as well with LibreOffice 3.6.6.2. -> NEW

Priority:
* Minor: does makes it substantially harder to create high quality work
* High: a bit more then default priority

Kind regards,
Joren
Comment 2 QA Administrators 2015-04-01 14:40:17 UTC Comment hidden (obsolete)
Comment 3 Buovjaga 2015-04-20 18:16:40 UTC
Reproduced.

Win 7 Pro 64-bit Version: 5.0.0.0.alpha0+ (x64)
Build ID: 211c12b9c64facd1c12f637a5229bd6a6feb032a
TinderBox: Win-x86_64@42, Branch:master, Time: 2015-04-18_01:51:17
Locale: fi_FI

Ubuntu 14.10 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 4 QA Administrators 2016-09-20 09:32:21 UTC Comment hidden (obsolete)
Comment 5 Laurent BP 2017-10-09 21:22:31 UTC
From my point of view, it works as expected. Format string gives the way the result is DISPLAYED not ENTERED. If you choose a format like MM:SS, entering 12:30 will give 12 hours and 30 minutes and be displayed as 30:00.
Comment 6 Buovjaga 2017-10-16 18:54:36 UTC
(In reply to Laurent BP from comment #5)
> From my point of view, it works as expected. Format string gives the way the
> result is DISPLAYED not ENTERED. If you choose a format like MM:SS, entering
> 12:30 will give 12 hours and 30 minutes and be displayed as 30:00.

Thanks, let's close.