Apache OpenOffice (AOO) Bugzilla – Issue 106961
Option to directly set decimal and thousands separator to own liking, regardless of any locale settings
Last modified: 2017-05-20 10:44:55 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)
Created attachment 66147 [details] Language Settings in MS Excel 2003 versus OOo 3.1 Calc
I would guess there is already an issue for this one? Anyhow, related issues are 106961, 100844, 93591, 64450, 102517, 38494, 106960
*** Issue 106961 has been confirmed by votes. ***
Reassigned to Requirements
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.
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".
*** Issue 106960 has been marked as a duplicate of this issue. ***
*** Issue 103666 has been marked as a duplicate of this issue. ***
*** Issue 64450 has been marked as a duplicate of this issue. ***
*** Issue 51662 has been marked as a duplicate of this issue. ***
*** Issue 71209 has been marked as a duplicate of this issue. ***
Reset the assignee to the default "issues@openoffice.apache.org".