GNOME Bugzilla – Bug 327166
impossible to enter decimal values in locale with comma separator
Last modified: 2006-01-17 15:06:39 UTC
Please describe the problem: I'm using locale with comma as decimal separator and I cannot write formulas containing decimal numbers: =A1*0,18 and =A1*0.18 give error gnumeric-1.6.1-5, opensuse 10.0, 64bit, LANG=et_EE.UTF-8 ** (gnumeric:9456): WARNING **: ,18 is not a double, but was expected to be one Next try: when I enter simply 0,18 in cell, 0,00 is displayed and cell really has value 0 Steps to reproduce: 1. run gnumeric from shell with non-en_US locale (eg. 'LANG=de_DE gnumeric') 2. try to write eg. =A1*0,18 (with comma or point, doesnt matter) 3. hit Enter -> warning about invalid expression 4. try to write value 0,18 5. hit Enter -> 0,00 is displayed, and it is als cell value Actual results: 1-3 Gnumeric gives a warning about invalid expression 4-5 Gnumeric does not recognize the value Expected results: As ####,## is correct format for most languages, I'd expect it can be used in calculations Does this happen every time? It happens every time Other information: This bug makes impossible to use Gnumeric with most of locales, only workaround is switch to en_US.
I cannot reproduce on gentoo (amd64 or x86) either with 1.6.1 or HEAD in fr_FR.UTF8 locale. Might be a suse specific problem?
Cannot reproduce in nb_NO.UTF-8 either
That should be: "Cannot reproduce in nb_NO.UTF-8 either. Gnumeric 1.5.90 on Ubuntu Breezy"
additional comments: Looks like it happens only in KDE. When starting Gnumeric under some other windowmanager, then all is OK. It depends also not from old or outdated configuration, I created new testuser, opened KDE, ran Gnumeric and all the errors I described were there. Can we find out what happens and inform KDE developers when necessary?
Try entering the formula =getenv("LANG") in a cell. Does it give the locale you think you are running? Also try =getenv("LC_NUMERIC")
yes, found this. In OpenSuSE 10 / KDE 3.5.0 variable LC_NUMERIC is not passed to Gnumeric. In other distributions this works. When starting Gnumeric with 'LC_NUMERIC=et_EE gnumeric' all works fine. Thanks.
You might have to set LC_MONETARY too.