Multi-value fields export as separate or multiple fields in xls [#799146]

It appears that creating a xls feed view that contains a multi-value field results in an export that separates each value in the multi-value field into it's own field in the xls export (see attached example). Is there a way to export the xls so that all the values of a multi-value field appear in 1 field in the xls?

Comment	File	Size	Author
#7	views_export_xls-multivalues_fields_export-799146-6.patch	8.31 KB	sirko_el
	views_multivalue_issue.jpg	134.41 KB	sweimer

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

sweimer CreditAttribution: sweimer commented 25 May 2010 at 13:20

bump

Comment #2

creaoy CreditAttribution: creaoy commented 27 May 2010 at 17:10

Sorry, too much work right now.
I will look when will have a chance.

Comment #3

sweimer CreditAttribution: sweimer commented 27 May 2010 at 20:34

understood...thanks. i'll keep checking back

Comment #4

hiyikiyikas CreditAttribution: hiyikiyikas commented 1 February 2012 at 02:26

Would like to know if there is any progress... I need the function in this moment!

Comment #5

Elementica CreditAttribution: Elementica commented 23 November 2012 at 18:16

Title:	Multi-value fields export as seperate fields in xls	» Multi-value fields export as separate or multiple fields in xls
Version:	6.x-1.x-dev	» 6.x-1.1-beta1

I have the opposite problem: I don't experience what stated in first post, my rows are like <Cell><Data ss:Type="String">3030</Data></Cell> where "3030" should actually be "30" and "30" (two values).
Option "Group multiple values" is checked and table-style view online is good (I'm using version 6.x-1.1-beta1).

Comment #6

Bartezz CreditAttribution: Bartezz commented 2 December 2012 at 13:17

Version:

6.x-1.1-beta1

» 7.x-1.0

In 7.x-1.0, when exporting users, roles are comma separated into a single cell. Would like to know how to split these over multiple cells as mentioned in #1.

Cheers