Bug 121880 - Set semicolon ; as default Field Delimiter for CSV instead of comma , (avoid confusion for French and other)
Summary: Set semicolon ; as default Field Delimiter for CSV instead of comma , (avoid ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL: https://help.libreoffice.org/6.3/en-U...
Keywords: easyHack
Depends on:
Blocks: CSV-Export
  Show dependency treegraph
Reported: 2018-12-03 14:24 UTC by gwenn.boussard
Modified: 2020-01-30 09:43 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

french coded float example (7.13 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-12-10 14:58 UTC, gwenn.boussard
Example of fench coded float as a string (898.62 KB, text/csv)
2018-12-10 14:59 UTC, gwenn.boussard

Note You need to log in before you can comment on or make changes to this bug.
Description gwenn.boussard 2018-12-03 14:24:24 UTC
When using LO in French, floats are expressed with a comma '3,14'.
When exporting to csv format, if you chose the comma separator at export, the file generated can't be parsed (impossible to decide a comma is either a field separator, or within a float).
The turn-around is to first set the column to 'english(US)' (format cells > Number > Language), but it's an ugly hack (export only should be affected, and it's hard to find).

Floats should be automatically coded with a dot in csv exports, at least when using comma as a separator.

Steps to Reproduce:
1.Set a sheet to French
2.Insert two floats into the first cells
3.Export to csv using comma a a separator
4.Open the generated csv

Actual Results:
Too many fields detected

Expected Results:
(N-1) commas on each line (N is the number of fields)

Reproducible: Always

User Profile Reset: No

Additional Info:
Code floats with dots.
Comment 1 Oliver Brinzing 2018-12-03 18:08:31 UTC
Thank you for reporting the bug. 

Thank you for reporting the bug. Please attach a sample *.ods document, as this makes it easier for us to verify the bug. 

(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 2 gwenn.boussard 2018-12-10 14:58:33 UTC
Created attachment 147421 [details]
french coded float example
Comment 3 gwenn.boussard 2018-12-10 14:59:19 UTC
Created attachment 147422 [details]
Example of fench coded float as a string
Comment 4 gwenn.boussard 2018-12-10 15:01:24 UTC
I feel a bit stupid, as I can't reproduce the exact same problem.
Nevertheless see attached files, the "french-coded" float is expressed as a string (with: '), which is still a(nother) problem.
Comment 5 Timur 2018-12-24 18:03:44 UTC
Save as CSV gives Export Text File options dialog with Field Delimiter.
Doesn't make sense to use the default "," (if that's what you meant by "if you chose the comma separator at export..").
I wouldn't agree with "Actual Results" or "Expected Results" as you wrote. It would be hard to put conditions to avoid user mistake. 
So this is WontFix as requested. 

But I think this request can be changed to "Set semicolon as default Field Delimiter for CSV instead of comma." I'll confirm so. 
Not sure why comma is default all the way from OO.