SSRS report - Export to Excel truncates text

Question

If I have a large text inside of a cell's table, then when it is exported into Excel the cell is not expanding automatically. I tried disabling Can Increase and enabling it, same c.
Any idea?

Thanks

Answer 1

Hi @mark goldin ,
What is the size of your cell? In SSRS, you can change the "CanGrow" property to "True", and the text box will automatically expand according to the text content.

But in your case, I guess it has nothing to do with the settings in SSRS. It related to the behavior of exporting Excel. We all know that there are some limitations in Excel.

Microsoft Excel places limitations on exported reports due to the capabilities of Excel and its file formats. The most significant are the following:

• The maximum column width is limited to 255 characters or 1726.5 points. The renderer does not verify that the column width is less than the limit.
• The maximum number of characters in a cell is limited to 32,767. If this is exceeded, the renderer displays an error message.
• The maximum row height is 409 points. If the contents of the row cause the row height to increase beyond 409 points, the Excel cell shows a partial amount of text up to 409 points. The rest of the cell contents is still within the cell ( up to Excel's max number of characters of 32,767).
• Because the maximum row height is 409 points, if the defined height of the cell in the report is something larger than 409 points, Excel splits the cell contents into multiple rows.
• The maximum number of worksheets is not defined in Excel, but external factors, such as memory and disk space, might causes limitations to be applied.
• In outlines, Excel permits up to seven nested levels only.
• If the report item that controls whether another item is toggled is not in the previous or next row or column of the item being toggled, the outline is disabled also.

For more details about Excel limitations, see Excel specifications and limits.

In my test, when my text content exceeds the limit of Excel (the maximum row height is over 409 points), it will not display the complete text content.

Hope this helps.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.