Bug 59041 - UNIX linebreaks in saved CSV files; option to set end of line in csv export, to make the use on Windows possible
Summary: UNIX linebreaks in saved CSV files; option to set end of line in csv export, ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All Linux (All)
: medium enhancement
Assignee: Not Assigned
: 116908 (view as bug list)
Depends on:
Blocks: CSV-Dialog
  Show dependency treegraph
Reported: 2013-01-05 02:51 UTC by Kevin Hill
Modified: 2021-08-18 14:35 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Hill 2013-01-05 02:51:35 UTC
When you save a spreadsheet as a CSV file the carriage return is not compatible with the Windows carriage return/line feed.

There is no option to save as CR/LF.

The line end character is not recognised correctly by Windows XP etc.


Comment 1 Jean-Baptiste Faure 2013-01-13 22:13:41 UTC
What do you mean exactly by "The line end character is not recognised correctly by Windows XP" ?

When exporting a sheet to csv format, you can edit the parameters of the filter.

Best regards. JBF
Comment 2 QA Administrators 2013-09-24 01:54:51 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2013-10-25 15:13:33 UTC Comment hidden (obsolete)
Comment 4 Urmas 2013-10-25 18:48:54 UTC
The line separator for CSV is platform-dependent and cannot be changed.
Comment 5 Joel Madero 2014-11-06 17:51:47 UTC
@Urmas - so does that mean NOTABUG, WONTFIX, or....confirmed? Moving to UNCONFIRMED for now as there is no independent confirmation from QA. Thanks all.
Comment 6 raal 2014-11-09 20:08:09 UTC
There is not problem with Calc, I can export data to .csv in Linux and import this file in Calc on windows. But I can imagine the problem with data interchange with other programs on windows. For example open this .csv file in notepad shows all data in one row.

Setting as enhancement - add option to CSV Filter setting to define end of line LF/CRLF
Comment 7 max.gilead 2015-01-14 13:59:25 UTC
I have the same problem, except I need to export to CSV with CR line endings so please include this option in the option list (CR / LF / CRLF)
Comment 8 abia 2015-10-16 07:45:28 UTC
Reimporting an exported .csv file which has internal line breaks (\lf only) within a cell fails. Every new internal section of a cell will be put into a new column.

Combining the rotten legacies of \cr and \lf in .csv was not a good idea.

Give users a choice.

I would love a .csv output option for internal linebreak: \vt chr(11) besides the useless \lf chr(10)
Comment 9 abia 2015-10-16 09:05:33 UTC
Forgot to add: exporting \vt chr(11) for an internal line break is the right thing to export to .csv ; .csv import is flawless then.
Comment 10 Regina Henschel 2018-04-09 22:34:22 UTC
*** Bug 116908 has been marked as a duplicate of this bug. ***
Comment 11 software.v9onn 2021-02-05 16:41:28 UTC
Hi, I want to warm up this old problem: e.g. when you want to convert a calc address table into vcard format you need csv export in only one column. The cell separator should be CR/LF for this and that seems to be not possible to enter.