GNOME Bugzilla – Bug 131933
Currency + Number format wrong in some cases
Last modified: 2004-12-22 21:47:04 UTC
Start gnumeric with *exactly* these locales: nikratio:~$ locale LANG=POSIX LC_CTYPE=de_DE@euro LC_NUMERIC=POSIX LC_TIME=de_DE@euro LC_COLLATE=de_DE@euro LC_MONETARY=de_DE@euro LC_MESSAGES="POSIX" LC_PAPER=de_DE@euro LC_NAME=de_DE@euro LC_ADDRESS=de_DE@euro LC_TELEPHONE=de_DE@euro LC_MEASUREMENT=de_DE@euro LC_IDENTIFICATION="POSIX" LC_ALL= (I think only LC_NUMERIC and LC_MONETARY are really relevant, but I don't want to test each combination of every locale). Type "22" into a cell. Format this cell as a number or currency. Be sure to select "Use separator for 1000's" and 2 decimal digits. The cell is now formatted as "22.0000" while it should be "22.00". When you set LC_NUMERIC and LC_MONETARY to the same value or even when you just switch the values, everything goes fine. I think this must have something to do with the locale handling explained in bug 131842.
I've added a patch to both trees to catch a situation where LC_NUMERIC and LC_MONETARY conflict.