I think it is a bug in Excel rendering extension. I have the same problem. In
my case, after excel export the table cell actually belongs to several excel
columns (thas because of some text boxes in my report header). So, when I'm
placing the table on a separate excel sheet (inserting a page break before
and after the table), everything works fine.
I don't know the workaround yet...
[quoted text, click to view] "Andreas Staubi" wrote:
> Hi,
>
> when exporting a report containing a simple table to Excel (97, 2000, 2003 -
> all the same) I always experience the following problem:
>
> Row height is not adjusted to the actual height of the row (even if text
> wrapping is allowed) and the rows don't react on the Excel AutoFit command
> anymore.
> As a result, the export isn't usable since the rows have to be adjusted
> manually.
>
> Any ideas?
>
> Thanks,
>
> Andreas
>
>
This is damd anoying... we cant exactly expect our customers to manually
change the height of 1000+ lines in excel... have anyone found a good
workaround for this? Having all the text in one cell (without merged cells)
is not an option in our case.
Any answer from MSTF maybe?
[quoted text, click to view] "Alexey Akulinin" wrote:
> I think it is a bug in Excel rendering extension. I have the same problem. In
> my case, after excel export the table cell actually belongs to several excel
> columns (thas because of some text boxes in my report header). So, when I'm
> placing the table on a separate excel sheet (inserting a page break before
> and after the table), everything works fine.
>
> I don't know the workaround yet...
>
> "Andreas Staubi" wrote:
>
> > Hi,
> >
> > when exporting a report containing a simple table to Excel (97, 2000, 2003 -
> > all the same) I always experience the following problem:
> >
> > Row height is not adjusted to the actual height of the row (even if text
> > wrapping is allowed) and the rows don't react on the Excel AutoFit command
> > anymore.
> > As a result, the export isn't usable since the rows have to be adjusted
> > manually.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Andreas
> >
> >
Don't see what you're looking for? Try a search.