Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calc export to CSV with CRLF line breaks

I'm sure someone has answered this somewhere but I can't find it.

I would like to use LO more extensively; rather then installing MS office using Wine.

One thing really holding me back is getting LO Calc to save as CSV files that are exactly the same as Excel CSV files. Looking at a very basic Excel CSV using a hex editor shows the line endings are CRLF (0D 0A) whereas Calc created CSV files the line endings are simply LF (0A).

I work with programs that simply will not import data without the CRLF line endings. If it was only a few files I could just use a Hex editor to find-replace LF to CRLF; but I would be doing this 10 to 20 times a day and thus it is a huge time waste. Thus I am currently stuck with Excel. I realise there are no "hard" CSV standards thus the mess; but this is a major frustration for me.

If anyone has a simple solution I would love to hear it. It would be great if I could have a button on the tool bar that was basically export sheet to "Excel CSV".

Calc export to CSV with CRLF line breaks

I'm sure someone has answered this somewhere but I can't find it.

I would like to use LO more extensively; rather then installing MS office using Wine.

One thing really holding me back is getting LO Calc to save as CSV files that are exactly the same as Excel CSV files. Looking at a very basic Excel CSV using a hex editor shows the line endings are CRLF (0D 0A) whereas Calc created CSV files the line endings are simply LF (0A).

I work with programs that simply will not import data without the CRLF line endings. If it was only a few files I could just use a Hex editor to find-replace LF to CRLF; but I would be doing this 10 to 20 times a day and thus it is a huge time waste. Thus I am currently stuck with Excel. I realise there are no "hard" CSV standards thus the mess; but this is a major frustration for me.

If anyone has a simple solution I would love to hear it. It would be great if I could have a button on the tool bar that was basically export sheet to "Excel CSV".

Calc export to CSV with CRLF line breaks

I'm sure someone has answered this somewhere but I can't find it.

I would like to use LO more extensively; rather then installing MS office using Wine.

One thing really holding me back is getting LO Calc to save as CSV files that are exactly the same as Excel CSV files. Looking at a very basic Excel CSV using a hex editor shows the line endings are CRLF (0D 0A) whereas Calc created CSV files the line endings are simply LF (0A).

I work with programs that simply will not import data without the CRLF line endings. If it was only a few files I could just use a Hex editor to find-replace LF to CRLF; but I would be doing this 10 to 20 times a day and thus it is a huge time waste. Thus I am currently stuck with Excel. I realise there are no "hard" CSV standards thus the mess; but this is a major frustration for me.

If anyone has a simple solution I would love to hear it. It would be great if I could have a button on the tool bar that was basically export sheet to "Excel CSV".

Calc export to CSV with CRLF line breaks

I'm sure someone has answered this somewhere but I can't find it.

I would like to use LO more extensively; rather then installing MS office using Wine.

One thing really holding me back is getting LO Calc to save as CSV files that are exactly the same as Excel CSV files. Looking at a very basic Excel CSV using a hex editor shows the line endings are CRLF (0D 0A) whereas Calc created CSV files the line endings are simply LF (0A).

I work with programs that simply will not import data without the CRLF line endings. If it was only a few files I could just use a Hex editor to find-replace LF to CRLF; but I would be doing this 10 to 20 times a day and thus it is a huge time waste. Thus I am currently stuck with Excel. I realise there are no "hard" CSV standards thus the mess; but this is a major frustration for me.

If anyone has a simple solution I would love to hear it. It would be great if I could have a button on the tool bar that was basically export sheet to "Excel CSV".