Hello All,
I am having a lot of fun when exporting to excel. When there is a control (image etc) above a table and the sides of the image stop half way through a column this creates a merged column in excel. This creates headaches for clients when trying to chart this data. Is there anyway around this? Or any secrets?
I placed the image into a header and set the device info url to "rc:SimplePageHeaders=true" this helped by placing the header into an excel header upon rendering BUT there was no image in there'
Thanks in advance
SheaThat is one of the drawbacks of Excel exporting is the columns need to line up. Try this. If the image is wider than the first column and ends in the middle of the second column. insert a column between the first and second columns and make it so its edge lines up with the edge of the image. reduce the width of the now third column so the new column and it are the same width as the original second column. Then merge the two cells in the table. That may help with your problem.
"Shea Strickland" wrote:
> Hello All,
> I am having a lot of fun when exporting to excel. When there is a control (image etc) above a table and the sides of the image stop half way through a column this creates a merged column in excel. This creates headaches for clients when trying to chart this data. Is there anyway around this? Or any secrets?
> I placed the image into a header and set the device info url to "rc:SimplePageHeaders=true" this helped by placing the header into an excel header upon rendering BUT there was no image in there'
> Thanks in advance
> Sheasql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment