Bug 133805

Summary: default csv separator location specific
Product: LibreOffice Reporter: rupert.thurner
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: minor    
Priority: medium    
Version: 6.4.4.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

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 ***