Bug 156668 - Corrupted times between 12:00:00 and 12:59:59
Summary: Corrupted times between 12:00:00 and 12:59:59
Status: CLOSED DUPLICATE of bug 97191
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-08-08 11:46 UTC by Guy
Modified: 2023-08-08 12:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 ***