After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 65045 - Function values are displayed with wrong format for locale
Function values are displayed with wrong format for locale
Status: RESOLVED DUPLICATE of bug 33229
Product: Gnumeric
Classification: Applications
Component: Main System
git master
Other All
: Low enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2001-11-21 16:35 UTC by Christian Rose
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Christian Rose 2001-11-21 16:35:28 UTC 
Tested with "LC_ALL=sv_SE".

When I enter "=date(2001;11;17)" in a cell, the output is "11/17/01".
This format is very wrong for sv_SE; the correct format should be
"01-11-17" or "2001-11-17".

When I enter "=time(15;14;5)" in a cell, the output is "3:14 PM".
This format is very wrong for sv_SE; the correct format should be "15.14".
In short, it seems that Gnumeric doesn't respect the locale at all when
assigning the default format.
Comment 1 Jody Goldberg 2001-11-21 17:57:47 UTC 
That is an overstatement.  We do try to respect the locale, but it is not
trivial.  The date/time formats need to be translated from strftime fmt into XL
format.  As things stand we attempt to guess

    m/d/y  vs d/m/y

by using the results of langinfo (D_FMT).  No attempt to guess the default
seperator or time format has been made.  The code is easy to write, but needs
alot of testing before it can be deployed due to variety of locales.  I don't
want to waste alot of resources on it because we are going to rework the format
engine after 1.0.
Comment 2 Jody Goldberg 2002-02-08 02:43:24 UTC 

*** This bug has been marked as a duplicate of 33229 ***