Grouping of multiple values creates a nested table. Please add "div" to the replacement pattern:

$table = preg_replace('/<\/?(a|span|div) ?.*?>/', ' ', $table); // strip 'a' and 'span' tags

Comments

dawehner’s picture

Status: Active » Needs review
StatusFileSize
new521 bytes

Here is a patch

temp’s picture

What this mean "Grouping of multiple values"?
please add screenshot, you can export to excel table with fields grouped by some field? How?!
Please teach me.

harking’s picture

StatusFileSize
new583 bytes

Subscribing.

I've updated the patch's comment too.

harking’s picture

Version: 6.x-1.0-beta4 » 6.x-1.x-dev
Status: Needs review » Reviewed & tested by the community
harking’s picture

Title: Bug in excel-export » Excel Export Field Grouping Causes Multiple Rows in Output
harking’s picture

StatusFileSize
new493 bytes

Updated patch to add commas between grouped items.

seanberto’s picture

This last patch works well for me. It does add a trailing comma to the end of the list of values in the field though.

dawehner’s picture

Status: Reviewed & tested by the community » Needs review

It's a new patch

ademarco’s picture

Subscribing.

jvieille’s picture

The patch does not seem to work for me.
Multiple values in fields generate as many lines.

Jb33’s picture

+1 for this issue. I have a field where multiple tel. numbers can be saved. I cannot get this module do something reasonable with it. If I check grouping then the 2nd, 3rd values generate empty lines containing only the 2nd, 3rd tel. number. If I uncheck grouping then the whole lines are multiplicated. I'd like to concatenate the multiple values for example, or generate additional columns for them in the xls.

jvieille’s picture

Any update on this?

Rob T’s picture

Thanks for this patch (#6). In my situation it was really only needed for one particular report, but I realize that all views bonus pack XLS reports with multiple values generated will be affected. We'll see. Thanks again.

neclimdul’s picture

Issue summary: View changes
Status: Needs review » Closed (outdated)