[Libreoffice-bugs] [Bug 121880] New: csv export is messed up when using ', ' for floats and ', ' for csv

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121880

Bug ID: 121880
Summary: csv export is messed up when using ',' for floats and
',' for csv
Product: LibreOffice
Version: 5.2 all versions
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@univ-grenoble-alpes.fr

Description:
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.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121880

Oliver Brinzing <***@gmx.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=12
| |1859
CC| |***@gmx.de

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121880

Oliver Brinzing <***@gmx.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
Status|UNCONFIRMED |NEEDINFO

--- Comment #1 from Oliver Brinzing <***@gmx.de> ---
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.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121880

--- Comment #4 from ***@univ-grenoble-alpes.fr ---
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.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121880

***@univ-grenoble-alpes.fr changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
Ever confirmed|1 |0

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121880

--- Comment #2 from ***@univ-grenoble-alpes.fr ---
Created attachment 147421
--> https://bugs.documentfoundation.org/attachment.cgi?id=147421&action=edit
french coded float example

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121880

--- Comment #3 from ***@univ-grenoble-alpes.fr ---
Created attachment 147422
--> https://bugs.documentfoundation.org/attachment.cgi?id=147422&action=edit
Example of fench coded float as a string