Free Support Forum - aspose.com

Pie chart label is offset when rendering excel chart to image

Hello,

In the excel file “PieChart.xlsx” there is a chart. Rendering the chart to image => “PieChart.png” offsets the label from the right of the chart, the one with the value “43,.6%”.

The code to reproduce the issue is:

var workbook = new Workbook(@“C:\PieChart.xlsx”);

foreach (Worksheet worksheet in workbook.Worksheets)
worksheet.Pictures.Clear();

var opts = new ImageOrPrintOptions
{
Quality = 100,
VerticalResolution = 200,
HorizontalResolution = 200,
PrintingPage = PrintingPageType.IgnoreBlank,
ImageFormat = ImageFormat.Png,
OnePagePerSheet = true,
OnlyArea = true
};
var chart = workbook.Worksheets[0].Charts[0];

using (var chartImage = chart.ToImage(opts))
{
chartImage.Save(@“C:\PieChart.png”);
}

Regards,
Lucian Nistor

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-41603

Hi,


Please try our latest fix/version: Aspose.Cells for .NET v7.4.3.1

We have fixed your issue regarding labels now.

Let us know your feedback.

Thank you