Contents of chart moved to the right when rendering chart to image

Aspose.Cells Product Family
1

Hi, Aspose Team
I’m noticing an issue where the contents of my chart are pushed to the right when rendering the chart into an image.

The code I’ve used is:

Document RepDoc = new Document();
DocumentBuilder Builder = new DocumentBuilder(RepDoc);
using (Workbook TemplateWB = new Workbook(dir + @"\Test_04222025_02\Chart_Template.xlsm"))
{
    Worksheet sourceWS = TemplateWB.Worksheets["DetailCharts"];

    //Set print area
    sourceWS.PageSetup.PrintArea = $"B73:M110";
    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.OfficeCompatibleEmf,
        HorizontalResolution = 100,
        VerticalResolution = 100,
        OnlyArea = true,
       TextRenderingHint = System.Drawing.Text.TextRenderingHint.AntiAlias
    };

    // Take the image of your worksheet
    SheetRender Render = new SheetRender(sourceWS, options);
    // Create a stream to save the image in
    MemoryStream ImgStream = new MemoryStream();
    Render.ToImage(0, ImgStream); //Returns an image of the cell range if an accuarate cell range is suppiled
    if (ImgStream != MemoryStream.Null)
    {                    
        // Insert this image into the place of the old shape.
        Shape newOleShape = Builder.InsertImage(ImgStream);
        Aspose.Words.PageSetup PS = Builder.CurrentSection.PageSetup;
                            double PageWidth = PS.PageWidth - PS.LeftMargin - PS.RightMargin;
                            if (PageWidth < newOleShape.Width)
                            {
                                newOleShape.Width = PageWidth;
                            }
    }
}
RepDoc.Save(dir + @"\Test_04072025_2\Output2.docx");

I have described the issue in detail in the word document named “Output2” in my attachment.
I have noticed this happening in all the charts in the worksheet “DetailCharts”.
Test_04222025_2.zip (8.5 MB)

2

Along with the issue described above, please take a look at the following picture. You’ll notice that the arrows pointing at the intersection of the shaded region of bar graph is different in size and location when compared to excel. The arrow in aspose is smaller and it doesn’t point exactly at the intersection. It’s slightly pushed above.
Pointers.png (26.6 KB)

3

@JThomas98
We can reproduce the issue by testing on the latest version v25.4 using sample files and the following sample code. It was found that when rendering the chart to the image, the text was moved to the right and the size and position of the arrow graphics were incorrect.

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-58272: Contents of chart moved to the right when rendering chart to image
CELLSNET-58273: Arrow graphic size and position error when rendering chart to image

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.

4

Looking forward. Thanks.

5

@JThomas98,

We will update you promptly on any logged issues as new information becomes available.