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

[bugzilla-daemon at 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-bugs at lists.freedesktop.org
          Reporter: gwenn.boussard at 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181203/bbb055d8/attachment.html>