The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.When I export a taxonomy term that has the & (ampersand) ' (single quote) and " (double quote) characters in it these chars get converted to their HTML representation in the XLSX file.
Example:
Looking & Back at Tennessee's (P)hotograph "C"ollection, 18.90-19;81
...gets exported to XLSX as:
Looking & Back at Tennessee's (P)hotograph "C"ollection, 18.90-19;81
I am able to use Excel wizardry to find&replace these HTML representations with the desired characters, but it would be much more helpful if these fields were exported "as is".
| Comment | File | Size | Author |
|---|---|---|---|
| #4 | patch-fix-html-special-characters-decode-vbo_export_7x-issue-3128709-2.patch | 1.47 KB | 10ego |
Comments
Comment #2
brownrl commentedI have it too.
I believe that this line in the plugin should be modified:
web/modules/contrib/vbo_export/includes/vbo_export.theme.inc:96
In fact when I add this to the line above it's fixed:
$cell = htmlspecialchars_decode($cell);Maybe someone should make a patch or fix their plugin. Maybe I will make a patch if my client pays me to do so.
Comment #3
sumankarmakar commentedI also have faced the same issue with version 7.x-1.6.
I have applied the following for both CSV and XLSX export functionality and a patch is created for 7.x version.
$cell = htmlspecialchars_decode($cell);Patch works for me.
Comment #4
10ego commentedSame approach taken to fix the escaped quotes but also covers column labels.
Comment #5
astonvictor commentedD7 reached its EOL back in January 2025, and there is no active release for D7 for this module anymore.
Development or support is not planned for D7. All D7-related issues are marked as outdated in a bunch.