GNOME Bugzilla – Bug 131842
Currency format doesn't follow LC_MONETARY
Last modified: 2004-12-22 21:47:04 UTC
[Based on http://bugs.debian.org/228107] Start env LC_ALL=de_DE@euro gnumeric, enter 1234,56 in A1, rightclick Zellen formatieren, click Waehrung, set Trennzeichen fuer Tausender verwenden. The sample under "Negatives Zahlenformat" show "." used as the separator for thousands, and "," as the decimal point. This is as expected. Now start env LANG=POSIX LC_CTYPE=de_DE@euro LC_NUMERIC=POSIX LC_TIME=POSIX LC_COLLATE=POSIX LC_MONETARY=de_DE@euro LC_MESSAGES=POSIX LC_PAPER=POSIX LC_NAME=POSIX LC_ADDRESS=POSIX LC_TELEPHONE=POSIX LC_MEASUREMENT=POSIX LC_IDENTIFICATION=POSIX LC_ALL= gnumeric (i.e. all set to POSIX except for LC_CTYPE and LC_MONETARY) and repeat. The the currency cell format doesn't follow LC_MONETARY as expected; it uses "," as the thousands separator and "." as the decimal point. env LANG=POSIX LC_CTYPE=de_DE@euro LC_NUMERIC=de_DE@euro LC_TIME=POSIX LC_COLLATE=POSIX LC_MONETARY=de_DE@euro LC_MESSAGES=POSIX LC_PAPER=POSIX LC_NAME=POSIX LC_ADDRESS=POSIX LC_TELEPHONE=POSIX LC_MEASUREMENT=POSIX LC_IDENTIFICATION=POSIX LC_ALL= gnumeric shows the currency format to follow LC_NUMERIC rather than LC_MONETARY.
We can not support different decimal points for numbers vs currencies. After much trial and error we've settled on a combination of LC_MONETARY and LC_NUMERIC as the combination that makes the most people happy. The decimal point is from LC_NUMERIC lc->decimal_point The thousands seperator and currency info from LC_MONETARY lc->mon_thousands_sep lc->p_cs_precedes lc->p_sep_by_space lc->currency_symbol