Issue 106961

Summary: Option to directly set decimal and thousands separator to own liking, regardless of any locale settings
Product: Internationalization Reporter: aoo-bugger <bugger_aoo>
Component: i18npoolAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: alexander.v.rabtchevich, a_geek, cno, issues, ooo, paour, vaclavik
Version: OOo 1.0.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Language Settings in MS Excel 2003 versus OOo 3.1 Calc none

Description aoo-bugger 2009-11-16 22:37:26 UTC 
Proposal:
Option(s) to directly set decimal and thousands separator to own liking,
regardless of any locale settings.

Motivation:
Some users have there own preferences for decimal and thousands separator, which
doesn't fit to any locale. Currently there is no way for those user to fit OOo
to their preferences. In addition to that, it is even not possible to alter the
decimal and thousands separator, without altering other settings (like date
format, currency), which is quite painful.
But besides personal preferences this can also be necessary to avoid tedious
steps in a mixed environment. Imagine you are on an german computer importing
.csv's with english number, but international date format.

Details:
I thought of two drop down boxes, one for each separator, in which the following
entries would be available:
.
,
Thin Space (see Issue 106960 (only for thousands separator))
OOo Locale Settings (default)
System Settings (see Issue 51662)
Comment 1 aoo-bugger 2009-11-16 22:38:39 UTC 
Created attachment 66147 [details]
Language Settings in MS Excel 2003 versus OOo 3.1 Calc
Comment 2 cno 2009-11-17 09:32:47 UTC 
I would guess there is already an issue for this one?
Anyhow, related issues are 106961, 100844, 93591, 64450, 102517, 38494, 106960
Comment 3 asmol 2009-11-18 07:08:09 UTC 
*** Issue 106961 has been confirmed by votes. ***
Comment 4 eric.savary 2009-11-22 17:25:51 UTC 
Reassigned to Requirements
Comment 5 ooo 2010-05-12 19:46:59 UTC 
Reassigning to spare time account. This should go into the layered locale data,
see also issue 51662, but may be independent together with a dialog to specify
separators.
Comment 6 asmol 2010-05-13 07:14:50 UTC 
Actually, the absence of a possibility to set user's own decimal and thousand
separators is the single most important reason why our company still does not
migrate to OO from MS.
This simply does OO unusable for users of our ERP system, because they are not
able to exchange data between the system and their OO spreadsheets easily.
So we probably have to wait another several years for this "Enhancement".
Comment 7 eric.savary 2010-07-12 06:57:28 UTC 
*** Issue 106960 has been marked as a duplicate of this issue. ***
Comment 8 Edwin Sharp 2013-11-29 10:57:12 UTC 
*** Issue 103666 has been marked as a duplicate of this issue. ***
Comment 9 Edwin Sharp 2013-11-29 10:58:53 UTC 
*** Issue 64450 has been marked as a duplicate of this issue. ***
Comment 10 Edwin Sharp 2013-11-29 11:00:23 UTC 
*** Issue 51662 has been marked as a duplicate of this issue. ***
Comment 11 Edwin Sharp 2013-11-29 11:03:23 UTC 
*** Issue 71209 has been marked as a duplicate of this issue. ***
Comment 12 Marcus 2017-05-20 10:44:55 UTC 
Reset the assignee to the default "issues@openoffice.apache.org".