Bug 156668

Summary:	Corrupted times between 12:00:00 and 12:59:59
Product:	LibreOffice	Reporter:	Guy <info>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	CLOSED DUPLICATE
Severity:	normal	CC:	xiscofauli
Priority:	medium
Version:	5.1.6.2 release
Hardware:	All
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Guy 2023-08-08 11:46:21 UTC

Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial10
CPU Threads: 4; OS Version: Linux 4.15; UI Render: default; 
Locale: en-GB (en_GB.UTF-8); Calc: group

When I enter a time starting 12: (e.g. 12:11:15) in a field formatted as Time HH:MM:SS, a clock face corrupts the time, (e.g. 12🕛15) and, most importantly, all derived fields show #VALUE!

Comment 1 Xisco Faulí 2023-08-08 12:09:08 UTC

Thank you for reporting the bug.
it seems you're using an old version of LibreOffice.
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.

Comment 2 Eike Rathke 2023-08-08 12:33:36 UTC

5.1.6.2 is way outdated and EOL since 2016, there was some bug with AutoCorrection getting in the way while entering times. Use an up-to-date release. A workaround is to hit Ctrl+Z immediately after input. Another one is to remove the offending emoji entries from the AutoCorrect list, see https://bugs.documentfoundation.org/show_bug.cgi?id=97191#c11

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