Bug 146196

Summary: Ignores Locale Numbers / Currency setting KDE
Product: LibreOffice Reporter: dieseltrike
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED DUPLICATE    
Severity: normal CC: 79045_79045, erack
Priority: medium    
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 102495    
Attachments: KDE on top, Calc settings bottom
LibreCall - Options - Lang settings

Description dieseltrike 2021-12-12 17:04:08 UTC
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 ","
Comment 1 Roman Kuznetsov 2021-12-12 21:26:24 UTC
I'm not sure it's a LibreOffice in KDE problem or some locale trouble inside LibreOffice

Eike, what do you think?
Comment 2 Eike Rathke 2021-12-15 18:34:17 UTC
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 ***
Comment 3 dieseltrike 2022-01-20 06:32:58 UTC
Created attachment 177664 [details]
LibreCall - Options - Lang settings
Comment 4 dieseltrike 2022-01-20 06:34:05 UTC
(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.
Comment 5 dieseltrike 2022-01-20 06:37:21 UTC
> 
> 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.
Comment 6 dieseltrike 2022-01-20 06:41:57 UTC
(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.