Hi NG, I have a report with a table on it. In the details I have a cell with a textbox containing text of individual length. I want to export this report to excel - but then there is only one visible line - the cell is not growing and the rest is not directly visible. fixed height is not possible in this scenario. Has anyone an idea on how to solve this? cangrow and canshrink is true... problem is only when exporting to excel. (SQL-Server 2008 R1) thx! Regards Benjamin

Hi Benjamin, Generally, if the CanGrow property is specified to True, the cell height will increase automatically to accommodate a long text. However, from your description, the cell doesn’t grow in export Excel. One possible cause is merged cells exist on a row where a text box is rendered with the AutoSize property. If cells are merged, word-wrap and auto-height will not work correctly in exporting Excel. Since this is a limitation in Excel rendering, currently, I’m afraid we can only use non-merged cell in the row. If it still doesn’t work, please let me know. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Toni, thx a lot for the information. after recreating and eleminating all merged cells the problem was solved! Regards Benjamin