Ask Your Question

ujhmh's profile - activity

2017-07-27 12:16:45 +0200 received badge  Notable Question (source)
2017-03-26 19:56:21 +0200 commented answer Time entry in H:M:S mysteriously switches to have a stopwatch character

Just to be clear in case someone else has this same issue. The problem was introduced by entries under option (3) "Tools"->"AutoCorrect Options...". For all N = {1..12} there is an entry that changes ":N:" to a clock face with the hour hand in that position. There are a lot more that have the format ":X:" where some other emoticon substitution is performed. 'Cause you know nothin' makes yer spreadsheet look more professional than emoticons.

2017-03-26 19:44:44 +0200 commented answer Time entry in H:M:S mysteriously switches to have a stopwatch character

Bingo. There are a bunch of emoticon substututions defined that I will now be sending into the bit bucket. Thanks.

2017-03-26 19:36:36 +0200 commented question Time entry in H:M:S mysteriously switches to have a stopwatch character

As suggested by Lupp I tried entering the same keyboard input to a LibO Writer doc and saw the same character auto-substitution.

2017-03-26 19:33:09 +0200 commented question Time entry in H:M:S mysteriously switches to have a stopwatch character

I will look for those things. My OS is a stock install of Ubuntu 16.04.2 LTS with English. LibO is a default package in that OS install. I didn't do any customization of LibO that I am aware of.

2017-03-26 13:43:49 +0200 received badge  Popular Question (source)
2017-03-26 03:28:32 +0200 received badge  Editor (source)
2017-03-26 03:25:59 +0200 asked a question Time entry in H:M:S mysteriously switches to have a stopwatch character

I am seeing a bizarre behavior when I format a colum to have "Time HH:MM:SS" format. When I start to enter the time, say 5:10:20 when I get to the second colon it switches to 5🕙 and then ends up as 5🕙20 when I finish adding the seconds. This is totally repeatable, when the hours are 0 through 12. If the hours are 13 or greater the problem does not occur. My workaround is to put in a bogus HH value and then edit it to the correct value after the entry in complete, but that is not the proper way for the time entry to work. I am using LibreOffice 5.1.6.2 and my OS is Ubuntu 16.04 LTS.