locked
Text wrapping when Exported to Excel RRS feed

  • Question

  • Column headings in a report table are being forced to wrap by the width of the columns.  When viewed as PDF, print preview or exported to Excel this is OK initially - the row height of the column heading expands for the necessary heading lines.  However when I add another table to the report, the column headings in the first table no longer wrap when exported to Excel; only the first line of heading text is visible and I have to manually increase the row height to make the full column headings legible.  As well as that, it also forces the final column of the table onto a new page, even though the tables are sized within the margins.

    I've played around with row heights and grow/shrink properties etc but nothing works. Any suggestions as to what's causing this and how to get round it?

    Thanks

    Tuesday, March 7, 2006 5:14 PM