Issue 110834 - Choose the endofline char in text exports.
Summary: Choose the endofline char in text exports.
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: DEV300m70
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo
Depends on:
Reported: 2010-04-13 10:30 UTC by jspiel
Modified: 2014-01-11 15:37 UTC (History)
4 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description jspiel 2010-04-13 10:30:50 UTC
When saving csv, we can't choose what type of endofline character is used LF, CR, or LF/CR...

At least on Mac, the default eof char used in excel and in OOo are not the same CR on one and LF on 
the other... When migrating excel users to OOo, it can be very frustating...

In the filter parameters, it could be very good to choose the type of EOF, with this defaults ones :
- MAC (CR)
Comment 1 Edwin Sharp 2014-01-10 14:02:05 UTC
In what program this choice is possible?
Comment 2 jspiel 2014-01-10 14:16:21 UTC
I don't know about spreadsheets, but from database, it is common to have the option. I also have a text-editor who allows to change it (textWrangler), but that won't fix the issue for my users.
Only adding the option to choose the end-of-line character would be good.
Comment 3 Andreas Säger 2014-01-10 15:43:39 UTC
Export your csv.
Open the file with Writer.
Save as file type "text encoded" with "edit filter" option.
Choose the right line feed.

When you paste-special Calc cells as "unformatted text" into Writer you get a nice tab-separated text which can be saved as encoded text.
Comment 4 Edwin Sharp 2014-01-11 15:37:01 UTC
Thank you for clarifying this.