Bug 104136 - Cell formatted as time hh:mm:ss - problem with minute value 12 or less
Summary: Cell formatted as time hh:mm:ss - problem with minute value 12 or less
Status: RESOLVED DUPLICATE of bug 97191
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
Depends on:
Reported: 2016-11-24 04:34 UTC by Donald Aitken
Modified: 2016-11-24 15:28 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Donald Aitken 2016-11-24 04:34:31 UTC
If I format a cell as Time hh:mm:ss and enter a value containing a minute value 12 or less the value is displayed with a CLOCK symbol where minutes should be shown. For example when entering cell value 01:12:25 results in 01🕛:25
As a workaround change cell format to Time hh:mm, enter the hours and minutes (01:12). Change format back to hh:mm:ss and edit the cell to include the seconds. Now it shows 01:12:25 correctly.
Or, format as hh:mm:ss and enter 01:13:25. Then edit cell to desired value 01:12:25.

Steps to Reproduce:
1. Format a cell as Time hh:mm:ss
2. Enter a minute value of 12 or less

Actual Results:  
enter 01:12:25 
01🕛:25 is displayed

Expected Results:

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
Comment 1 Aron Budea 2016-11-24 14:44:26 UTC
Thanks for reporting the issue.
This is caused by certain autocorrect entries, and is fixed in LibreOffice 5.2 to not interfere with time entry. As a workaround hitting Ctrl-Z right after the substitution undoes it, or the offending autocorrect entries can be removed as described here:

*** This bug has been marked as a duplicate of bug 97191 ***