Issue 12366 - Export to CSV format wrong in some languages
Summary: Export to CSV format wrong in some languages
Status: CLOSED DUPLICATE of issue 3516
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 644
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-03-15 09:55 UTC by t8m
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description t8m 2003-03-15 09:55:41 UTC 
If I export file to the CSV format in for example czech language the export is
wrong. The default delimiter character for CSV is comma. But the comma character
is used as a decimal dot in the czech language. 

Solution: Either change the default CSV delimiter character to for example ';'
if the number decimal dot is comma or when exporting CSV file change the decimal
dot to dot character regardless of the language.
Comment 1 frank 2003-03-17 09:54:14 UTC 
Hi Tomas,

as CSV is a defined file format, we can't change the default settings.

But have you tried to set the encoding regarding your language ? Also
just change the delimiter settings on saving the document. If you save
the document the first time to CSV format, the mentioned dialog box
opens by default. If not, please use the Save as ... Dialog and tag
the checkbox Edit Filtersettings. This should give you the above
mentioned dialog after entering an valid document name and pressing
the Ok button.

So I have to close this as Invalid.

Best regards

Frank
Comment 2 frank 2003-03-17 09:54:27 UTC 
invalid
Comment 3 t8m 2003-03-17 10:22:17 UTC 
OK, I agree you can't change the default delimiter character.
However the czech localized version of Microsoft Excel exports .csv
files with decimal comma in numbers and semicolon ';' as field
delimiter. This is certainly easily achievable by the user change of
the delimiter character as you suggest.

But the other suggestion to change the language specific decimal comma
to the (english) default dot character in numbers during the export of
CSV file is I think legitimate enhancement request. This isn't easily
achievable (only by selecting the appropriate numeric fields and
change their language).
Comment 4 frank 2003-03-17 10:31:36 UTC 
Hi Bettina,

1 4 u

Frank
Comment 5 eric.savary 2003-04-16 15:29:36 UTC 
Set to "NEW"
Comment 6 ooo 2004-12-20 16:08:53 UTC 
This was fixed with issue 3516.


*** This issue has been marked as a duplicate of 3516 ***
Comment 7 ooo 2004-12-20 16:09:31 UTC 
Closing dupe.