Apache OpenOffice (AOO) Bugzilla – Issue 24076
Locale setting for parsing CSV-file
Last modified: 2013-08-07 15:12:27 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 locales. So: it would be useful to have the option to (temporarily) switch to a different locale in the csv import wizzard.
Hi Bettina, one4you
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
Hi, 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. Regards.
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".