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!

CommentFileSizeAuthor
#1 webform-export_wordwrap-d8-2420249-1.patch6.37 KBdanchadwick
#1 webform-export_wordwrap-2420249-1.patch4.66 KBdanchadwick

Comments

danchadwick’s picture

danchadwick commented
Version: 7.x-4.2 » 7.x-4.3
Category: Support request » Feature request
Status: Active » Fixed
StatusFileSize
new webform-export_wordwrap-2420249-1.patch4.66 KB
new webform-export_wordwrap-d8-2420249-1.patch6.37 KB

The 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).

  • DanChadwick committed fb70bc1 on 7.x-4.x 
    Issue #2420249 by DanChadwick: Added option to force Excel wordwrap.
  • DanChadwick committed babe6c8 on 8.x-4.x
    Issue #2420249 by DanChadwick: Added option to force Excel wordwrap.
danchadwick’s picture

danchadwick commented
Component: User interface » Code

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.