https://bugs.documentfoundation.org/show_bug.cgi?id=153457
Bug ID: 153457
Summary: loading and saving CSV in calc does not round-trip
because numbers get converted to the locale's decimal
separator
Product: LibreOffice
Version: 7.4.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: lio...@mamane.lu
Description:
LibreOffice is not a good CSV editor because it effectively corrupts the
CSV-based file format by switching the numbers to the locale's decimal
separator on save.
Steps to Reproduce:
1. Set locale to one that uses comma as decimal separator
2. Make sure LibreOffice is closed so that it is restarted in the above locale
3. Open a CSV file containing numbers with dot as decimal separator
4. Save (CTRL+S or Menu File / Save or the floppy disk icon)
Actual Results:
The CSV file is not the same anymore; the numbers are written out with comma as
decimal separator.
Expected Results:
The CSV file should be effectively unchanged, using the same variant of the CSV
file format: same separator between fields (columns), same decimal separator
within numbers, same text encoding, ...
If the original CSV was not fully internally consistent (such as non-uniform
application of quoting of fields), it is OK to canonicalise this.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.4.4.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: fr-LU (fr_LU.UTF-8); UI: en-GB
Debian package version: 1:7.4.4-3
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
