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.
Are you sure there isn’t a silly add-in to LibO - or probably on the OS level?
What is your locale and your UI-language? Is there a need to disambiguate two formats for numeric values of different type both using the colon? Was the setup for your OS / LibO made by someone regularly using the colon notation wrongly meant to denote mm:ss when entering durations? If you enter such a TOD value into a ‘Default’ style cell: What ‘Numbers’ format code is the cell set to automatically?
In addition: The described behaviour might indicate the presence of a keyboard listener under LibO which was registered and assigned to a handler intentionally producing the described behaviour. Do you experience a similar behaviour under some conditions in Writer? Did you inspect your “macros” libraries for code suspect under this assumption?
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.
As suggested by Lupp I tried entering the same keyboard input to a LibO Writer doc and saw the same character auto-substitution.
Some things I would look to:
- Cell locale.
-
Tools-Options-Language Settings-* sentence checking-Typography(there might be replacements defined) -
Tools-AutoCorrect Options... - Font?
Bingo. There are a bunch of emoticon substututions defined that I will now be sending into the bit bucket. Thanks.
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 “
” where some other emoticon substitution is performed. ‘Cause you know nothin’ makes yer spreadsheet look more professional than emoticons.
I suppose you use English (US) locale? It seems that in 5.3.1. the codes were changed to :X h:.