Groups | Blog | Home
all groups > sql server reporting services > march 2005 >

sql server reporting services : AutoFit Excel Export


Andreas Staubi
3/17/2005 12:35:35 PM
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

Alexey Akulinin
5/22/2005 10:20:01 PM
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]
aCa
6/1/2005 7:32:13 AM
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]
AddThis Social Bookmark Button