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.
Shape overflows from its cell when export to excel
-
- Posts: 1
- Joined: Tue Aug 03, 2021 5:23 am
Shape overflows from its cell when export to excel
- Attachments
-
- Report.mrt
- (5.57 KiB) Downloaded 101 times
-
- In excel.png (4.17 KiB) Viewed 855 times
-
- In viewer.png (1.74 KiB) Viewed 855 times
-
- Posts: 6198
- Joined: Tue Mar 20, 2018 5:34 am
Re: Shape overflows from its cell when export to excel
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.
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.