What is this clock emoji that shows up?

jackray · February 27, 2021, 5:44pm

Entering times in a spreadsheet to totals hours, Minutes over a period. Sometimes a cell will have 01🕛46
instead of the 1:12:46 I entered. All cells are formatted time,HH:MM:SS

anon73440385 · February 27, 2021, 6:01pm

Hello,

this happens through replacement table in Tools -> AutoCorrect Options ...-> Tab: Replace. There are a lot of entries similar to these:

I’d suggest to

either disable use of replacement table in Tools -> AutoCorrect Options ...-> Tab: Options -> Option: [] Use replacement table
or delete the troubling entries from the replacement table

Hope that helps.

erAck · February 27, 2021, 6:10pm

That once happened with a quite old version of LibreOffice that had :12: and similar emoji replacements. You should upgrade anyway.