Page 1 of 1

Shape overflows from its cell when export to excel

Posted: Tue Aug 03, 2021 6:01 am
by i.charlies
Hello,

I'm building a report which contains Shape and Icon set condition. Everything is perfect when I see it via report viewer.
But when I export to excel. All the shapes and arrow icons are not rendered exactly like what I see in the viewer.

What I'm trying to solve the most is it doesn't fit to the cell. And when it overflows, I can't see the cell borders behind the images.

I would appreciate if you could give me a solution. :D
The attachment In viewer.png is no longer available
The attachment In excel.png is no longer available

Re: Shape overflows from its cell when export to excel

Posted: Mon Aug 16, 2021 8:06 am
by Lech Kulikowski
Hello,

Sorry for the delay with the response.

In Excel, it is impossible to insert a picture inside a cell, it is always on top, so the edges of the picture overlap the borders.

The is option is to switch the picture format to png:
StiOptions.Export.Excel.ImageFormat = ImageFormat.Png;
then images with transparency will be exported, in this case, indicators and circles will have a transparent background and borders will not overlap.

Thank you.