Shape overflows from its cell when export to excel

Stimulsoft Reports.NET discussion
Post Reply
i.charlies
Posts: 1
Joined: Tue Aug 03, 2021 5:23 am

Shape overflows from its cell when export to excel

Post 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
Attachments
Report.mrt
(5.57 KiB) Downloaded 101 times
In excel.png
In excel.png (4.17 KiB) Viewed 854 times
In viewer.png
In viewer.png (1.74 KiB) Viewed 854 times
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Shape overflows from its cell when export to excel

Post 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.
Post Reply