Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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 |
Comments
Comment #1
sweimer CreditAttribution: sweimer commentedbump
Comment #2
creaoy CreditAttribution: creaoy commentedSorry, too much work right now.
I will look when will have a chance.
Comment #3
sweimer CreditAttribution: sweimer commentedunderstood...thanks. i'll keep checking back
Comment #4
hiyikiyikas CreditAttribution: hiyikiyikas commentedWould like to know if there is any progress... I need the function in this moment!
Comment #5
Elementica CreditAttribution: Elementica commentedI 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 commentedIn 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
Comment #7
sirko_el CreditAttribution: sirko_el commentedLooks like works now. Had some problems with Office 2003 xml format, but now it works fine for me.
Comment #8
creaoy CreditAttribution: creaoy commentedLooks good, will test for some time.
Comment #9
creaoy CreditAttribution: creaoy commentedCommitted to latest dev