https://bugs.documentfoundation.org/show_bug.cgi?id=154623
Bug ID: 154623
Summary: Numeric keypad decimal separator is inconsistently
used when not a dot
Product: LibreOffice
Version: 7.5.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I am using a Hungarian keyboard under Linux with English settings.
If in a simple text editor (GEdit) I use it, it produces a comma (","), as that
is the normal Hungarian decimal separator. For spreadsheets, it should be a dot
(".").
If in Tools/Options/Language Settings/Languages the "Decimal separator key:
Same as locale setting (.)" is unchecked then using the decimal separator from
the numeric keypad, a comma is entered and 12,34 becomes a text field. This is
OK, as my input is really a comma.
If I check this option, then the operation becomes inconsistent.
When start a new cell (enter into an empty cell), something like 12.34 then the
decimal separator is a dot, as that is the same as locale setting. Also I can
enter a formula into an empty cell, like +12.34+56.78 and it is still correct.
However, if I try to Edit the above cell to make it +12.34+45.67+89.12 then the
newly entered number is already has a comma in it, and the cell turns into a
text cell, with a content '12.34+45.67+89,12 (starting with an apostrophe!).
I find it a bug, as it means that the cell entering is inconsistently handles
the numerical keypad decimal separator.
Btw. I have just upgraded from 6.1.5.2 (Debian 10 standard repository latest
version), and in that one this error did not exist.
--
You are receiving this mail because:
You are the assignee for the bug.
