I have a views field that outputs it's data as an unordered list, and when it is exported to CSV, Excel 2007 doesn't know how to handle newlines from inside that field (although LibreOffice has no problems with it).

Attached is a patch that implements this feature.

CommentFileSizeAuthor
#2 1179888-replace_newlines-2.patch2.79 KBamateescu
replace_newlines.patch2.01 KBamateescu

Comments

steven jones’s picture

steven jones commented
Status: Needs review » Needs work

This needs a defining as an option in the 'option_definition' method and, why do we need two wrapping divs?

amateescu’s picture

amateescu commented
Status: Needs work » Needs review
StatusFileSize
new 1179888-replace_newlines-2.patch2.79 KB

Revised patch that adds those two additional options to the 'option_definition' method and also adds the trim option in there because it was missing :)

The two wrapping divs are required by ctools, see:

http://drupalcode.org/project/views.git/blob/refs/heads/7.x-3.x:/modules...

http://drupalcode.org/project/views.git/blob/refs/heads/7.x-3.x:/modules...

steven jones’s picture

steven jones commented
Status: Needs review » Fixed

Thanks, committed to all branches.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.