Bug 97252 - Random HH:MM:SS entries change to unknown cell format
Summary: Random HH:MM:SS entries change to unknown cell format
Status: CLOSED DUPLICATE of bug 97191
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2016-01-19 15:43 UTC by Robin
Modified: 2016-09-03 08:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Calc spreadsheet to collect and crunch sump pump runtime data (8.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-01-19 15:43 UTC, Robin

Note You need to log in before you can comment on or make changes to this bug.
Description Robin 2016-01-19 15:43:19 UTC
Created attachment 122085 [details]
Calc spreadsheet to collect and crunch sump pump runtime data

Two columns (B and C)are affected, which have no formulas and are formatted for time entries in the form of HH:MM:SS. Maybe 20% of entries, upon entry of the second colon character, the previous characters are deleted and the first is changed to a different font and is bold. Entry of HH:MM:SS is not possible. Formulas in dependent cells display "#VALUE!"

To resolve the issue and continue work, I built the same spreadsheet in MS Excel (oh the shame). Of course, no problem there. To attempt a work around to enable using LibreOffice Calc, I loaded the Excel file into LibreOffice. The same problem occurred again.
Comment 1 Joel Madero 2016-01-19 16:19:48 UTC
Hi Robin,

Can you please give reproducible steps as to what we should do with this sheet? Tell us *exactly* step by step what we are looking for/changing/observing.

Pushing to NEEDINFO as we need better reproducible steps.

Once you provide better steps please set to UNCONFIRMED.

Also please include your OS and version of LibreOffice in the comment. Thanks
Comment 2 Nick 2016-04-02 17:42:23 UTC
I currently have this problem in, win10, happened on last version my computer had as well. A workaround that seems to work, as it seems random, is to copy a cell with the correct format, then just edit the numbers. Today I was trying to enter 2:10:44 and after the 10, hitting : caused it to drop back to just the 2. I copied an entry from a few days ago for 1:14:xx (I forget off hand) and just changed it to 2:10:44 in the edit bar, and it was fine. I just tried opening a black spreadsheet, typed 2:10 and then hitting : again caused the bug. (The file that had the valid data time format that I can copy/edit was on my old linux machine, though new files are affected by this bug for me, as well as editing the old files in new cells.)
Comment 3 Eike Rathke 2016-09-03 08:52:18 UTC
Sounds like the Emoji bug, disable AutoCorrect option.

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