https://bugs.documentfoundation.org/show_bug.cgi?id=97191
Bug ID: 97191
Summary: Entry of time in format HH:MM:SS is corrupt when
entering some values in Writer and Calc
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: fwrun2...@gmail.com
Created attachment 122004
--> https://bugs.documentfoundation.org/attachment.cgi?id=122004&action=edit
libreoffice calc file containing the bug I described
This refers to LibreOffice ver 5.0.4.2 Writer and Calc.
LibreOffice Language settings:
User Interface: Default-English (USA), or English (USA)
Locales affected (of what i have tested so far*)
English (Aus)
English (Ghana)
English (New Zealand)
English (Phillipines)
English (South Africa)
English (Trinidad)
English (UK)
English (USA)
Default-English (USA)
Amharic
The bug does not affect other English Locales.
* I have tested language locales alphabetically from "Afrikaans (Namibia)
through "Basque".
The problem:
When entering time into a Calc cell or on a Writer line in the format HH:MM:SS.
Corruption of entered values occur immediately after typing the second colon
(:) after entering minutes (MM) values of 10, 11, or 12.
Does not occur for any other values of minutes. This is not affected by the
value entered for hours.
If time is copied and pasted from cells into new cells such that a sequence
including the affected values (10, 11, 12) is generated, the bug does not show.
In other words, I can enter time values of say 01:01:00 through 01:09:00, and
then copy and paste into additional cells so that the series continues:
01:10:00, 01:11:00, etc; there is no corruption.
When corruption occurs, it is displayed as digits being transposed over each
other.
If I have entered into a cell or on a Writer line the following value of time:
01:11: (stopping with the entry of the 2nd colon), what I see in the cell is
the digits 01 right-justified in the cell, but the 0 is transposed with a 1,
such that the two digits appear in the same space, with the 1 to the right.
If I continue to enter the seconds digits after the 2nd colon, the value in the
cell changes such that I now see the seconds digits I entered immediately to
the right of the minutes (and hours) digits but without the colon between MM
and SS, and the value is now left-justified in the cell.
The same appears in Writer when the values are typed onto a line.
If I change the locale from USA to one of the unaffected ones, such as Canada,
values are displayed normally.
When I use print preview to check the values, I still see the same corruption.
Note: I have two copies of Ubuntu 14.04.3 LTS installed into separate
partitions on the same machine. This bug occurs in either installation with
LibreOffice version 5.0.4.2.
I also have a Windows 7 X64 install on the same machine, with LibreOffice 4.x
installed. I will shortly upgrade that install to LibreOffice 5.0.4.2 (if it is
available) and check for this bug. I will update when I have this data.
I am attaching a LibreOffice Calc file which contains the bad data.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
