Version: 7.1.5.2 Build ID: 10(Build:2) CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: kf5 Locale: it-IT (it_IT.UTF-8); UI: it-IT Calc: threaded I've set KDE Plasma regional settings and keyboard to Italian language. In Libreoffice options I've set Italian language. Cell format is set to Italian language. Still, when I enter a decimal number using the keypad the decimal separator is entered as a . (dot) instead of a , (comma). I've also tried with "same as local" setting checked and not checked, the result doesn't change. The SUM function doesn't like decimals with dot, so I think Calc is correctly using Italian as language of the spreadsheet and comma as decimal separator.
You should start by checking existing bugs, like bug 46448, bug 54042, bug 42533.
Created attachment 173846 [details] cell formatting Thanks Timur, I've already checked some existing bugs, but they didn't provide any solution to my reported problem. For example in bug 42533 they said: "This option defines only what character is inserted when you press the decimal separator key on the numeric keypad. It does not define the decimal separator for your locale." However, with Same as locale setting either selected or de-selected, when I use the keypad dot the decimal separator is inserted as dot, never as comma. The strange is when I insert a number with a decimal using dot, LO says the cell is formatted as number, but it then manage it as text (see attached screenshot) i.e. SUM and other functions don't work.
Basically, what I'm reporting is that the keypad dot is always inserted as dot even when in LO settings it is selected (forced above system locale) to use a comma as decimal separator. The keypad dot behaves as the standard keyboard dot, but it should not.
No repro Version: 7.1.5.2 / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5 Locale: it-IT (en_US.UTF-8); UI: en-US Calc: threaded i.e.: Changing "Tools -> Options -> Language Settings -> Languages -> Locale Setting" to "Italian (Italy)" changes the numpad decimal spearator to "," (comma) while changing it to "English (USA)" changes the numpad decimal spearator to "." (dot)
Please update LO to a more recent version, and test again.
Thanks, I tried with 7.3.6.2 and the results are the same. However, I've now forced LO regional settings to English(USA), as it seems there's no other way to make things works as expected, so feel free to close this bug report, if there's little interest in fixing it.
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to Mattia from comment #6) > if there's little interest in fixing it. So far the problem is that others seem to have a hard time reproducing this issue. Until then the chance of getting this fixed is rather slim.
Created attachment 186566 [details] configuration
I've got the same issue, I join my configuration in previous screenshot. If I press the dot on my numpad I got a dot even if the decimal separator key config is checked If I uncheck I got a dot , If I change for English I got a dot I'm not able to have comma by pressing the "dot" of my numeric pad as opposed of the help : > If this checkbox is activated, the character shown after "Same as locale setting" is inserted when you press the key on the number pad
I'm using XFCE and LO: Version: 7.5.2.2 (X86_64) / LibreOffice Community Build ID: 50(Build:2) CPU threads: 8; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: en-US Ubuntu package version: 4:7.5.2~rc2-0ubuntu0.22.04.1~lo1 Calc: threaded
I'm marking as New because md confirmed it in comment 11, but I haven't been able to reproduce on Ubuntu 20.04 with GNOME 3.36.8, a French layout keyboard and: Version: 7.5.2.2 (X86_64) / LibreOffice Community Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (en_AU.UTF-8); UI: en-US Calc: threaded Calc does insert commas when using the decimal dot key on the numpad, as expected.
*** Bug 144885 has been marked as a duplicate of this bug. ***
(In reply to Stéphane Guillou (stragu) from comment #12) > I'm marking as New because md confirmed it in comment 11, but I haven't been > able to reproduce on Ubuntu 20.04 with GNOME 3.36.8, a French layout > keyboard and: > > Version: 7.5.2.2 (X86_64) / LibreOffice Community > Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2 > CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 > Locale: fr-FR (en_AU.UTF-8); UI: en-US > Calc: threaded > > Calc does insert commas when using the decimal dot key on the numpad, as > expected. I think the problem is that you're using: Locale: fr-FR (en_AU.UTF-8) (note that "en_AU.UTF-8") The same was in comment #4: Locale: it-IT (en_US.UTF-8) It was reproducible in my case with "Locale: it-IT (it_IT.UTF-8)" and by md with "Locale: fr-FR (fr_FR.UTF-8)"
(In reply to Mattia from comment #14) > I think the problem is that you're using: > Locale: fr-FR (en_AU.UTF-8) > (note that "en_AU.UTF-8") > > The same was in comment #4: > Locale: it-IT (en_US.UTF-8) > > It was reproducible in my case with "Locale: it-IT (it_IT.UTF-8)" and by md > with "Locale: fr-FR (fr_FR.UTF-8)" I still can't reproduce with: Version: 7.5.2.2 (X86_64) / LibreOffice Community Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
A 7.1 GTK-specific regression was fixed recently, see bug 154623, so I'd recommend users who reproduced the issue to test with version 7.5.3 or above and please report back. The issue was related to the formula bar, which might have muddied the waters here.
Tested with Version: 7.5.3.2 (X86_64) Build ID: 50(Build:2) CPU threads: 16; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+wayland) Locale: it-IT (it_IT.UTF-8); UI: it-IT Calc: threaded behavior is the same. I think it can consistently reproduced with the following steps: - download Fedora 38 KDE Live image - start the live system - open KDE Plasma settings and in Regional Settings change language to "Italiano" - log out - in the login screen, change the Keyboard layout to "Italian", then log in (blank password) - start libreoffice Calc You will now see that: - in "About", Calc is set to "Locale: it-IT (it_IT.UTF-8)" - in "tools -> options" the Locale is set to Italian and the decimal separator is "Same as locale (,)" Yet, typing a decimal number using the keypad dot is recognized as text, not as a number.
Could #154623 be a duplicate?
(In reply to Sébastien P. from comment #18) > Could #154623 be a duplicate? Bug 154623 was a GTK-specific regression affecting the formula bar, and I have verified it as fixed by Caolán. Let's keep these two separate. Mattia, md and Sébastien, can you confirm that this does not affect only the formula bar, but also uses the wrong decimal separator when editing a cell in place? Please test in LO 7.5.3. Would be also good to see if the issue predates 7.1.
(In reply to Stéphane Guillou (stragu) from comment #19) > (In reply to Sébastien P. from comment #18) > > Could #154623 be a duplicate? > > Bug 154623 was a GTK-specific regression affecting the formula bar, and I > have verified it as fixed by Caolán. Let's keep these two separate. > > Mattia, md and Sébastien, can you confirm that this does not affect only the > formula bar, but also uses the wrong decimal separator when editing a cell > in place? > Please test in LO 7.5.3. > > Would be also good to see if the issue predates 7.1. Yes, I always tested editing a cell in place, but I've now verified that the same happens entering text in the formula bar. Yet, the analysis made by Caolán in Bug 154623 made me think about what key value LO sees when I press the decimal on keypad. I don't know how to verify that in LO, but I've found a small python script which prints key values pressed within a gtk3 window: https://riptutorial.com/gtk3/example/16426/simple-binding-to-a-widget-s-key-press-event Running the python script and pressing the decimal keypad I get: $ python keyboard.py Key press on widget: <__main__.MyWindow object at 0x7fa495ea5140 (__main__+MyWindow at 0x55bf5ae3c6b0)> Modifiers: <flags GDK_MOD2_MASK of type Gdk.ModifierType> Key val, name: 65454 KP_Decimal Is it correct that it returns "KP_Decimal" instead of "GDK_KEY_KP_Decimal"? Is there a way to display the gtk key value inside Calc to be sure that it receives the correct value?
(In reply to Stéphane Guillou (stragu) from comment #19) > Mattia, md and Sébastien, can you confirm that this does not affect only the > formula bar, but also uses the wrong decimal separator when editing a cell > in place? > Please test in LO 7.5.3. I have got the wrong decimal separator in formula and when editing a cell. > Would be also good to see if the issue predates 7.1. I follow stable amd64 version of Gentoo (https://gitweb.gentoo.org/repo/gentoo.git/log/app-office/libreoffice). On my side, this bug started last month (with 7.4.6.2). I noticed #154623, so I have waited one month before take a closer look a few days ago. 7.4.4.2 (stable in January) was working until April for me. Which leads me thought why does it change between 7.4.4.2 and 7.4.6.2. It may be something upgrade outside that cause that. I will try to reinstall old 7.4.4.2 to check if I got the same issue now.
I have just reinstall 7.4.4.2 and got the same bug. I will try to reinstall also libreoffice-i10n (since Gentoo splits in two packages and the bug is related to language, it may be revelant). Version: 7.4.4.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 2; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb) Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Gentoo official package Calc: threaded If I have the same bug after reinstall all old package, it should be the upgrade of something outside of libreoffice that cause the issue…
Thank you both. (In reply to Mattia from comment #20) > (In reply to Stéphane Guillou (stragu) from comment #19) > Key val, name: 65454 KP_Decimal I've tested the same script and get the same key val when using "English (Australia)" for Ubuntu's Regional Formats. However, if I change the Regional Format to "français (France)", the same key sends the key val "65452 KP_Separator". More questions: - can you please check that you get the right character in other GTK apps, to make sure that it is indeed a LibreOffice issue? - if it is only in LibreOffice, is it only for Calc or also in e.g. Writer?
On my side: Key press on widget: <__main__.MyWindow object at 0x7fca59134140 (__main__+MyWindow at 0x55ebd073e2f0)> Modifiers: <flags GDK_MOD2_MASK of type Gdk.ModifierType> Key val, name: 46 period Key press on widget: <__main__.MyWindow object at 0x7fca59134140 (__main__+MyWindow at 0x55ebd073e2f0)> Modifiers: <flags GDK_MOD2_MASK of type Gdk.ModifierType> Key val, name: 65506 Shift_R Key press on widget: <__main__.MyWindow object at 0x7fca59134140 (__main__+MyWindow at 0x55ebd073e2f0)> Modifiers: <flags GDK_SHIFT_MASK | GDK_MOD2_MASK of type Gdk.ModifierType> Key val, name: 46 period * Both « . » (digit side and letters side) gave me the same key. * Writer and other applications always give me « . » (before and currently). No change. I thought about something: I use a special layout. It may be linked. Here are my X11 options: Option "XkbLayout" "fr" Option "XkbVariant" "oss" Option "XkbOptions" "compose:rwin,compose:lwin" (the keyboard is physically usual) Sorry, I am going on holiday. I will not be able to give more information until my return in 4 weeks.
So, in my case it seems that this is a problem related to KDE Plasma running under Wayland, not LO specific. I have created a brand new test user and logged in with that credentials, using the same regional settings (Italian) than my real user. Running a Plasma DE under X11 the keypad dot is correctly inserted as decimal separator (",") in Calc, while running the same plasma DE under Wayland the keypad dot is inserted as dot and cell content is treated as text. This behavior seems consistent with what I get running, for example, Calligra, so it's not LO specific.
Thank you both. Sébastien, are you using Wayland too? Are you able to test X11 vs Wayland? (we can wait :) )
Hi, I use Wayland too (since it is the default in Plasma or at least recommanded). Currently, I have a lot of updates to do on this computer. I will take a look if I can test a X11 session.
same problem here using Wayland LibreOffice 7.5.4.4 Language settings: UI: English (UK) Locale setting: Dutch (Belgium) Default currency: Default - EUR Decimal separator key: [x] Same as locale setting (,) The '.' on the numeric keypad is inserting a '.' and my decimal numbers are not recognised!
On my side, tests on Plasma X11/Wayland have the same result: dot instead of comma with fr-FR settings. Contrary to Mattia, I used my current user (not a new one).
This turned out to be a bug of KDE Plasma with Wayland. A possible (hopefully temporary) workaround is to start libreoffice with `env WAYLAND_DISPLAY= libreoffice`, which will force the app to run under xwayland. See https://bugs.kde.org/show_bug.cgi?id=449706#c3
OK, Sébastien, Mattia and Tom all use Wayland, so let's say this is "not our bug". I've linked the report in "URL". Tom and Sébastien, please check that the workaround does work to confirm. Thanks Mattia and everyone else!
No change for me. As state in #c22 I had the same bug with old LO version. Same with/without Wayland (#29). I also tried today to create a new user: same bug with/without Wayland.
As state in #24, I use a variant layout. With no variant or “obsolete variant”, the workaround is working. So, it can NOTOURBUG for me too. (add a comment in upstream bug: https://bugs.kde.org/show_bug.cgi?id=449706#c4)
*** Bug 160124 has been marked as a duplicate of this bug. ***
I think is LibreOffice bug, because the regular, old, "has always be this way" behavior, also in Windows, is that the numeric decimal separator produces exactly what is printed on that key and specialized programs that heavily relay on numeric decimal input do the conversion, so is not a KDE problem but that part that is broken when integrating libreoffice with KDE-Wayoand. I.e. Italian keyboard has a "." (dot) printed in the numeric keypad, but our decimal separator is "," (coma). Wherever I press that key a dot is produced, but i.e. Excel or KCalc (KDE calculator) or LibreOffice calc (under X11), has always converted "on the fly" to a decimal separator. Another example: on Windows in Notepad we obtain a dot, in Calculator we get the decimal separator. So current KDE behavior is correct, it Libreoffice that does not behave correctly with Wayland KF integration (worked fine in X11). Is just recently with KDE moving to Wayland that things have changed for me with LibreOffice, i.e. KCalc works instead just fine as with X11. (btw, I've had this but when moving to KDE 6.1 and Wayland, from 5.27 and X11, so I tested only KF5 and KF6 on QT6) If I remove the libreoffice-kf5/6 package, being still in KDE, the keypad works fine. Test results: NO Bug with KDE 5.27.11 KdeFramework 5.115 QT 5.15.13 LibreOffice 24.2.5 X11 YES Bug present with same as above, but with Wayland! (installed plasma-workplace-wayland and switched to it at login) YES Bug present with KDE 6.1.4 KdeFramework 6.6.2 QT 6.6.2 LibreOffice 24.8.0 Wayland (tested both with libreoffice-kf5/6 and libreoffice-qt5/6)
(In reply to Sébastien P. from comment #33) > As state in #24, I use a variant layout. > With no variant or “obsolete variant”, the workaround is working. So, it can > NOTOURBUG for me too. > > (add a comment in upstream bug: > https://bugs.kde.org/show_bug.cgi?id=449706#c4) I added comments to that bug also, for me is not a KDE bug, KDE behaves as usual (and behaves like i.e. Windows does), is LibreOffice that works different moving from X11 to Wayland. The historical problem is in the old days, IBM forced a lot of countries with a keyboard layout different from the usual one on typewriters, causing a lot of pain to people that typed "with 10 fingers" (accented characters and some letters were moved in different place...). In addition, at least in Italy, the numeric keypad had a "dot" key even if our national decimal separator is "coma". Since then all accounting programs/calculators/spreadsheets had to adapt, and so did LibreOffice (I remember how hard was to convince US-SUN-centric OpenOffice developers about this problem they simple wanted to ignore...).
Digging deeper, could be a QT6 bug! see: https://bugs.kde.org/show_bug.cgi?id=446389 I've tried with KDE Neo Unstable, that has QT 6.7.2 (but unfortunately only libreoffice integration KF5 and QT5) with Wayland and works fine as expected! I'm currently using Kubuntu 23.10, I hope that final version will have at least 6.6.3 because for Italian people with KDE, LiBo Calc can't be used this way.
I have just switched to Qt 6. Still have the same issue. KDE Plasma Version: 6.1.5 KDE Frameworks Version: 6.6.0 Qt Version: 6.7.2 Graphics Platform: Wayland Version: 24.2.6.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 2; OS: Linux 6.6; UI render: default; VCL: kf6 (cairo+wayland) Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Gentoo official package Calc: threaded