Bug 48043

Summary: LC_CTYPE instead of LC_NUMERIC used to determine decimal separator and native numbering
Product: LibreOffice Reporter: Andras Timar <timar74>
Component: LibreOfficeAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: contact, erack, jakobunt, kaplanlior, r0bertchik, shimons
Priority: medium    
Version: Master old -3.6   
Hardware: Other   
OS: Linux (All)   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=109058
https://bugs.documentfoundation.org/show_bug.cgi?id=46448
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 43808    
Attachments: native numbering test document

Description Andras Timar 2012-03-29 04:08:04 UTC 
lowriter by default uses the decimal separator "." or "," appropriate to the
locale when the corresponding key on the numerical pad is pressed. However, it
evaluates LC_CTYPE instead of LC_NUMERIC to decide what is the appropriate
separator.

(reported by Oliver Neukum in bugzilla.novell.com, 752821)
Comment 1 Eike Rathke 2012-04-02 04:19:44 UTC 
LibO uses the separators defined in i18npool's locale data. The locale is chosen according to LC_CTYPE, differentiation between LC categories or overriding specific elements is not implemented. This would need an locale interlayer where system and/or user defined elements are merged into (which could also take separators defined in Windows' Regional Settings) and use that for system/default locale assignments.
Comment 2 Jakob Unterwurzacher 2012-04-23 02:56:54 UTC 
*** Bug 48774 has been marked as a duplicate of this bug. ***
Comment 3 Lior Kaplan 2012-10-26 00:34:23 UTC 
Created attachment 69097 [details]
native numbering test document

This also affects Hebrew, which has unique numbering for "native numbering" which is controlled by LC_CTYPE while should by LC_NUMERIC, attached is a test document.
Comment 4 Lior Kaplan 2012-10-26 00:35:15 UTC 
*** Bug 48754 has been marked as a duplicate of this bug. ***
Comment 5 arian 2013-06-11 10:58:19 UTC 
I created a wiki page [1] to make the workaround more visible - I needed to search here to find it. 

[1] https://wiki.documentfoundation.org/Documentation/DecimalPointLocalizationBug
Comment 6 QA Administrators 2015-03-16 23:06:45 UTC Comment hidden (obsolete)
Comment 7 Lior Kaplan 2015-03-20 09:11:38 UTC 
Verified on LibO 4.3.3.2
Comment 8 tommy27 2016-04-16 07:24:28 UTC Comment hidden (obsolete)
Comment 9 chrysn 2017-01-02 13:28:53 UTC 
The issue is still present as of LibreOffice 5.2.4.2.1 20m0(Build:2) as shipped in Debian as 1:5.2.4-2.

As the issue already describes the problem of using LC_CTYPE for everything, here's another symptom: LC_TIME is ignored in the same way; it should be used for d_fmt (eg. YYYY-MM-DD instead of DD/YY/MM or similar).
Comment 10 ATINA 2018-01-03 11:39:49 UTC 
I confirm that this issue is still present in release 5.2.7.2 shipped in Debian 1:5.2.7-1, as all the workstations in my organization are now impacted by this issue since they were upgraded from Debian 8 to Debian 9, and thus from LibreOffice 4.3 to the 5.2

Before the last upgrade they were in LibreOffice 1:4.3.3-2 and it worked fine, the decimal separator was "," as specified by the system locale.
Comment 11 QA Administrators 2019-01-04 03:39:56 UTC Comment hidden (obsolete)
Comment 12 QA Administrators 2021-01-04 04:05:41 UTC Comment hidden (obsolete, spam)
Comment 13 Buovjaga 2023-08-10 11:10:57 UTC 
*** Bug 155717 has been marked as a duplicate of this bug. ***