Download & Extend
Views Excel Export » Issues

Ampersand character output as html character code &

Posted by grand_master_v on August 30, 2010 at 8:45pm
Project:Views Excel Export
Version:6.x-1.1-beta1
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active

Issue Summary

Hello!

I have a problem with the Ampersand character being output in excel as the html character code &

Original Input:

M & P Project Manager

Output in Excel:

M & P Project Manager

Any idea how to fix this?

Thank you,
- Vince

Login or register to post comments

Comments

#1

Posted by Patrizio on September 17, 2010 at 8:10am

+1

#2

Posted by grand_master_v on October 28, 2010 at 10:56pm

Anyone try out the CSV export in the views bonus pack?

http://drupal.org/project/views_bonus

CSV over excel format would be just fine for me.

#3

Posted by grand_master_v on March 29, 2011 at 10:37pm

Half a year and no help yet?

#4

Posted by hwasem on August 12, 2011 at 9:18pm

I am also having this problem. Seems like a great module so far! Any ideas on a fix for this? I have & and ' (apostrophe) showing up in my export.

#5

Posted by redbread on August 30, 2011 at 12:14pm

hi,everybody!
you can create "mymodule_preprocess_views_export_xls_view_xls"
copy and edit this code at line 53:
foreach ($fields as $key => $field) {
if (empty($field->options['exclude'])) {
$items[$key] = htmlspecialchars_decode(strip_tags($field->theme($row)));
//$items[$key] = strip_tags($field->theme($row));
}
}

#6

Posted by grand_master_v on September 28, 2011 at 5:42pm

Thanks for the workaround! This should really just be rolled into a patch for the module and commited though.

#7

Posted by aliciatheduff on May 15, 2012 at 2:49pm

Wrapping line 52 in decode_entities() fixed the numeric entity apostrophes for me –

$items[$key] = decode_entities(strip_tags($field->theme($row)));

Do you see anything wrong with this approach?

nobody click here