Aspose Cells - "From Corner" Shading Style Fill Efect for cells is not working

Aspose.Cells Product Family
1

Hello,

There is a shading style fill effect that doesn’t work for the cells in Aspose Cells. Using two color shading style with the “From Corner” option checked is not rendered to image. More precisely the cell B6 from “FillEffects.xlsx” attached file is rendered as not filled in the attached file “FillEffects.png”.

The code to obtain this result is:
var workbook = new Workbook(“C:\FillEffects.xlsx”);

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

};

var worksheet = workbook.Worksheets[0];

string printArea = string.Format(“A1:C8”);
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,“C:\FillEffects.png”);

Thank you,
Lucian Nistor

2

Hi,

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

We were able to replicate this issue using your code with the latest version. We have logged this issue in our database. We will look into it and resolve it. 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-41601

3

The issues you have found earlier (filed as CELLSNET-41601) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
4

Hi Shakeel,

Thank you for the helping me with this issue. The problem is fixed.

Regards,
Lucian Nistor
Senior .Net Developer
IBM Romania

5

Hi,


Thanks for your feedback.

Good to know that your issue is resolved. Feel free to contact us any time if you have any other issue or need further help regarding your queries, we will be happy to assist you soon.

Thank you.