Datalabel positions get reset in the image rendered from Excel chart


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

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].ToImage(@".\out.emf", options);

I’ve attached the test files and a screenshot for your reference. Could you please take a look? (14.6 KB) (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.


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)