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 56862 - Text import should have locale selection
Text import should have locale selection
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export Text
git master
Other All
: Low enhancement
: ---
Assigned To: Andreas J. Guelzow
Andreas J. Guelzow
: 73105 82043 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2001-06-29 14:21 UTC by Morten Welinder
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Morten Welinder 2001-06-29 14:21:02 UTC 
(Someone else came up with this, but it's too good not to record.)

When importing, all data is currently interpreted in the current
locale.  Thus, if a file contains "200,100", the current locale
determines whether I get (roughly) 2e5 [US, for example] or 2e2 [DA, for
example].

It would be nice, if there was a way of selecting the locale of
the data during import.
Comment 1 Andreas J. Guelzow 2002-03-01 14:18:37 UTC 
*** Bug 73105 has been marked as a duplicate of this bug. ***
Comment 2 Andreas J. Guelzow 2002-03-01 14:19:24 UTC 
cc to me
Comment 3 mfortini 2002-03-01 14:41:04 UTC 
Well it's quite annoying when working on text files you get from some
program's output. Of course making a CSV is the easiest way to go.
The problem with this bug is that its origin is not so plainly
apparent to someone that's not into programming... anyway it should be
quite straightforward to fix, as I said: just don't use locales when
importing CSV: they are all in international (US) format, for what I know.
Comment 4 Andreas J. Guelzow 2002-05-17 05:15:02 UTC 
*** Bug 82043 has been marked as a duplicate of this bug. ***
Comment 5 Morten Welinder 2003-05-13 14:05:12 UTC 
Fixed in cvs.
Comment 6 Morten Welinder 2003-05-13 14:35:53 UTC 
Not so fast, young man!
Comment 7 Andreas J. Guelzow 2003-06-21 19:27:04 UTC 
"as I said: just don't use locales when importing CSV: they are all in
international (US) format, for what I know."

THis doesn't work. There are lots of csv files generated in other than
US format. (Even lots of canadian files switch the day/month ordering.)

Well in any case, you can now choose the locale the file is in. If it
is in US/English (C) or (en_US), just select it and you should be fine.

fixed in cvs (for text import from a file at least)