Labels in charts are positioned incorrectly when aspose renders the chart as image

Aspose.Cells Product Family
1

Hi Aspose team,

I’m having an issue where the data labels in a chart are way off in position when compared to it excel equivalent.

Code used to generate the output:

using (Workbook TemplateWB = new Workbook(dir + @"\Test_05142025\Chart_Template.xlsm"))
{
    Worksheet sourceWS = TemplateWB.Worksheets["DetailCharts"];

    //Set print area
    sourceWS.PageSetup.PrintArea = $"B1234:M1270";
    sourceWS.PageSetup.LeftMargin = 0;
    sourceWS.PageSetup.RightMargin = 0;
    sourceWS.PageSetup.TopMargin = 0;
    sourceWS.PageSetup.BottomMargin = 0;
    // Clear any header/footer as they'll be captured when converting the worksheet to image
    sourceWS.PageSetup.ClearHeaderFooter();

    // Set OnePagePerSheet option as true
    ImageOrPrintOptions options = new ImageOrPrintOptions
    {
        OnePagePerSheet = true,
        ImageType = Aspose.Cells.Drawing.ImageType.Emf,
        HorizontalResolution = 100,
        VerticalResolution = 100,
        OnlyArea = true,
        TextRenderingHint = System.Drawing.Text.TextRenderingHint.AntiAlias
    };

    // Take the image of your worksheet
    SheetRender Render = new SheetRender(sourceWS, options);
    Render.ToImage(0, dir + @$"\Test_05142025\DetailCharts_B1234_M1270.png");
}

If you look at the png file, comparison1, you’ll notice the two data labels are pushed further out and seems to be overlapping.
In comparison2 , you can see that the data labels are pushed into the chart.
Test_05142025.zip (1.1 MB)

2

@JThomas98,

Thanks for the template Excel file, screenshots and code snippet.

After initial testing, I am able to reproduce the issue as you mentioned by using your template Excel file and sample code snippet. I found labels in charts are positioned incorrectly when Aspose.Cells renders the chart as image.

We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-58403

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

Hi Aspose Team, any updates on this ticket?

4

@JThomas98,

We’re still working on your issue. We’ll update you with the latest information or an ETA (if possible) soon.

We appreciate your patience in this regard.

5

Hi @JThomas98
For this issue, the results of our optimization are as follows, and it will take effect in version 25.6.
250607.png (11.0 KB)

6

The issues you have found earlier (filed as CELLSNET-58403) have been fixed in this update. This message was posted using Bugs notification tool by leoluo