We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Datalabel positions get reset in the image rendered from Excel chart

Hi,

When converting an Excel chart with a few data labels to image, I noticed the positions got reset.

Code:
var workbook2 = new Workbook(@".\save.xlsx");
var options = new ImageOrPrintOptions
{
ImageType = ImageType.Emf,
ChartImageType = ImageFormat.Emf,
OnlyArea = false,
TextRenderingHint = TextRenderingHint.ClearTypeGridFit,
OnePagePerSheet = true,
Transparent = true
};
workbook2.Worksheets[0].Charts[0].Calculate();
workbook2.Worksheets[0].Charts[0].ToImage(@".\out.emf", options);

I’ve attached the test files and a screenshot for your reference. Could you please take a look?

test.zip (14.6 KB)
test2.zip (14.4 KB)
image.png (58.0 KB)
image.png (81.7 KB)

Update: I have added one more example, please find the screenshot and test files attached.

Thanks

@ServerSide527,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46838 – Chart Datalabel positions get reset in the rendered image

Hi @ServerSide527
Please use the latest patch:
Aspose.Cells21.6.5 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.6.5 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.6.5 For .NetStandard20.Zip (5.5 MB)