"Sarah" wrote:

> Sorry I have posted in wrong group yesterday. Have to repost it again. Anyone
> can answer the question? Appreciate it!!
> ------
> I want to have report exported to excel to have the same format as it was
> before export. I have set textbox properties to "canGrow" true. Every cell is
> expanded no hiding text, not truncated. Everything is fine. However when
> exported to excel, the cell did not grow as content of text grows. Another
> problem is if I set each textbox on one row of the table in report as cangrow
> to be true. the exported excel collapsed every row takes the default height
> of excel setting which is 12.75. I tried to set several textbox in report to
> cangrow as true. The exporoted excel file takes the height of row height of
> the table. It did not grow as text content exceed the space of one textbox.
> You have to manually to adjust the height of cell to see the content.
> Is there any way to resolve this problem? Could we let the excel cell to
> autofit the content?
> Another problem is the heading of table of a report does not repeat on each
> print page of excel if you have multiple tables in one report. There are some
> posts suggesting put heading in report heading instead of table heading.
> However for multiple table with different headings this is obvious not the
> solution. Any suggesting?
>
> Thanks a lot in advance for any help!
>