Image Shadow Effect not preserved when rendering image from excel

Aspose.Cells Product Family
1

Hi,

I the excel file (ShadowPicture.xlsx) I have an image with Shadow effect set. Rendering the file content with the image as a
image losses the Shadow effect. (see ShadowPicture.xlsx.out.png file)

The code used to obtain the image file is :

const string filePath = @“C:\ShadowPicture.xlsx”;

var workbook = new Workbook(filePath);

var imageOptions = new ImageOrPrintOptions
{
Quality = 100,
VerticalResolution = 200,
HorizontalResolution = 200,
PrintingPage = PrintingPageType.IgnoreBlank,
ImageFormat = ImageFormat.Png,
OnePagePerSheet = true,

};

var worksheet = workbook.Worksheets[“Figure”];

string printArea = string.Format(“B3:G15”);
worksheet.PageSetup.PrintArea = printArea;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.BottomMargin = 0;

var sheetRender = new SheetRender(worksheet, imageOptions);

sheetRender.ToImage(0, filePath + “.out.png”);

Thank you,
Lucian Nistor

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We were able to observe this issue using your source file and sample code. The shadow effect is not preserved in the output image. We have logged this issue in our database. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42019.

3

Hi,

We are afraid, the Shadow feature is not currently supported for shapes, pictures and charts. It is a complex feature and we cannot support it soon.

Once we have any update on it, we will let you know here.

Thank you.