Bug 133805 - default csv separator location specific
Summary: default csv separator location specific
Status: RESOLVED DUPLICATE of bug 121880
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.4.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-06-08 19:40 UTC by rupert.thurner
Modified: 2020-06-23 15:14 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description rupert.thurner 2020-06-08 19:40:01 UTC
in many european countries the decimal separater is a comma, not a dot. therefor the default CVS separator character is a semicolon. it can be set in libreoffice calc in a quite hidden way, described e.g. here: https://ask.libreoffice.org/en/question/201076/csv-default-separator/

Tools -> Options - LibreOffice -> Advanced - Button: Open Expert Configuration and search for FieldSeparator 

it would be nice if LC_NUMERIC or LC_MONETARY is something non english to use semicolon as default.

second advantage is that this then would be more compatible with microsoft excel, and also be more compatible with public upload APIs in europe.
Comment 1 Timur 2020-06-23 15:14:31 UTC
Duplicate request. Please write this useful comment to existing bug.

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