Issue 24076 - Locale setting for parsing CSV-file
Summary: Locale setting for parsing CSV-file
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P4 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-01-04 10:31 UTC by bbouwens
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description bbouwens 2004-01-04 10:31:54 UTC
When a .csv file is opened, this is usually not produced by OpenOffice, and also
not necessarily with the same locale setting as the user's preference.
E.g. a Dutch user would have a locale where the decimal separator is a comma,
but a csv file to be imported could have a dot in that place, like in most other
So: it would be useful to have the option to (temporarily) switch to a different
locale in the csv import wizzard.
Comment 1 oc 2004-01-07 15:52:27 UTC
Hi Bettina,
Comment 2 afmoene 2004-11-06 19:42:18 UTC
Check with Excel (I think it is Office 2000): under a button named 'advanced' in
the text file import wizard you can change the decimal and thousands separators.
So you don't have to fiddle with the locale. Anyway, a lot of users don't have a
clue about what a locale is, let alone that under Windows it is unclear who and
what decides what the locale is. Users simply have a file that does not import
correctly. Once the user found out that the file says 3,14 whereas the user
knows that Calc wants 3.14 he/she simply wants to tell Calc: interpret this
comma as a point!

Cheers, Arnold 
Comment 3 nervenet 2005-01-29 09:20:16 UTC

It seems that exporting a spreadsheet to CSV format is affected by the same issue.

I use OpenOffice 1.1.2 and 1.1.4 (Windows/Linux and Linux respectively) in
Spanish, we use as decimal separator the character "," and not a dot.

When attempting to export a spreadsheet to a CSV file by default as field
separator the character "," is used but nothing is done to convert the decimal
values, so all decimal values have it "," as decimal separator. The CSV
generated file is useless.

IMHO OpenOffice should include a way to let the user especify the decimal
separator to be exported and/or warn him when the locale settings are in
conflict with the used CSV separators.

I can confirm that OO Versions 1.1.2 and 1.1.4 (Spanish versions) have the same
CSV exporting/locale issue. 

Comment 4 bettina.haberer 2010-05-21 15:10:31 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".