Description: 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: 01:12:25 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
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: https://bugs.documentfoundation.org/show_bug.cgi?id=97191#c11 *** This bug has been marked as a duplicate of bug 97191 ***