Apache OpenOffice (AOO) Bugzilla – Issue 110834
Choose the endofline char in text exports.
Last modified: 2014-01-11 15:37:01 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 : - UNIX (LF) - MAC (CR) - WIN (CRLF) - UNICODE
In what program this choice is possible?
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.
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.
Thank you for clarifying this.