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.First of all. I love this module...
Is there a way to determine how the data fits in columns and rows when exporting to excel from the webform module. I have a few comment fields in my form so each time I export my results as an excel document and open them, the comment fields are all displayed in one long line that then blocks the other data in columns.
Thanks!
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | webform-export_wordwrap-d8-2420249-1.patch | 6.37 KB | DanChadwick |
| #1 | webform-export_wordwrap-2420249-1.patch | 4.66 KB | DanChadwick |
Comments
Comment #1
DanChadwick CreditAttribution: DanChadwick commentedThe cell is word-wrapped if it contains a return character. Otherwise it's not.
This patch adds a global webform option to word-wrap all text cells. The first two rows, first column only, of the header is excepted, since the header is designed for these cells to overlaps the cells to the right. Only affects Excel xslx output.
Committed to 7.x-4.x, ported and committed to 8.x (as best as I could -- I couldn't test it).
Comment #3
DanChadwick CreditAttribution: DanChadwick commented