Created attachment 176885 [details] KDE on top, Calc settings bottom On KDE you can set different locale settings for numbers / time etc. Calc ignores this setting and instead uses the "main" locale setting. In South Africa the "official" decimal separator is "," but the other South African settings use ".". Calc uses the English SA locale instead of the one setup in KDE Settings As you can see I have setup KDE to use "." for numbers but Calc still thinks it should be ","
I'm not sure it's a LibreOffice in KDE problem or some locale trouble inside LibreOffice Eike, what do you think?
We don't support distinct different locale category settings. This plays well into the general custom locale settings for which defaults should be obtained from the OS if available. *** This bug has been marked as a duplicate of bug 46448 ***
Created attachment 177664 [details] LibreCall - Options - Lang settings
(In reply to Eike Rathke from comment #2) > We don't support distinct different locale category settings. This plays > well into the general custom locale settings for which defaults should be > obtained from the OS if available. > > *** This bug has been marked as a duplicate of bug 46448 *** Then perhaps LibreCalc can have an "editable" decimal separator key. It's unclear why the options have a checkbox for "Same as locale setting" when it actually uses the "global" locale setting. Please see screenshot. In my case the "English South Africa uses ",". I need it to be a ".". Yet this option in its current form just allows me to make a comma - a comma. Seems illogical.
> > Then perhaps LibreCalc can have an "editable" decimal separator key. It's > unclear why the options have a checkbox for "Same as locale setting" when it > actually uses the "global" locale setting. Please see screenshot. In my case > the "English South Africa uses ",". I need it to be a ".". Yet this option > in its current form just allows me to make a comma - a comma. Seems > illogical. Basically if one unchecks "Same as locale setting" then it should allow the user to enter what the separator should be, why have a checkbox I don't understand it's functionality when disabling it - this in effect does nothing then.
(In reply to dieseltrike from comment #5) > > > > Then perhaps LibreCalc can have an "editable" decimal separator key. It's > > unclear why the options have a checkbox for "Same as locale setting" when it > > actually uses the "global" locale setting. Please see screenshot. In my case > > the "English South Africa uses ",". I need it to be a ".". Yet this option > > in its current form just allows me to make a comma - a comma. Seems > > illogical. > > Basically if one unchecks "Same as locale setting" then it should allow the > user to enter what the separator should be, why have a checkbox I don't > understand it's functionality when disabling it - this in effect does > nothing then. Apologies I see this was for "kb input" but my suggestion still stands for and editbox of sorts to override locale - at this point this is a dealbreaker for librecalc being used at all. Can't go importing CSV's and doing search and replaces for "." to "," for every file I open.