SheetRender doesn't render an Excel 2010 chart

Aspose.Cells Product Family
1

Hi,

We have an Excel 2010 chart that doesn’t render anything for a selected print area.
The code that reproduces the issue is below:

var workbook = new Workbook(@“test.xlsx”);
var worksheet = workbook.Worksheets[0];
worksheet.PageSetup.PrintArea = “C3:O32”;
worksheet.PageSetup.TopMargin = 0.1;
worksheet.PageSetup.LeftMargin = 0.1;
worksheet.PageSetup.RightMargin = 0.1;
worksheet.PageSetup.BottomMargin = 0.1;
var sheetRender = new SheetRender(worksheet, new ImageOrPrintOptions
{
Quality = 100,
VerticalResolution = 200,
HorizontalResolution = 200,
PrintingPage = PrintingPageType.IgnoreBlank,
ImageFormat = ImageFormat.Png,
OnePagePerSheet = true,
OnlyArea = true
});
var image = sheetRender.ToImage(0);
image.Save(@“result.bmp”);

We are facing this problem in Aspose.Cells 7.5.2.0.
Testing with Aspose.Cells 7.4.2.4 produces the desired output.

Thank you,
Bogdan Ungureanu,
IBM Romania

2

Hi,

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

Please download and use the latest version: Aspose.Cells
for .NET v7.5.3.1 it works fine. We tested this issue using your source code and sample fine and it renders the chart fine.

We have also attached the output chart image for your reference.