The image Aspose.Cell captures does not look like the original excel chart

JThomas98 · February 18, 2025, 2:26pm

Hi Aspose team,
Issues CELLSNET-57741 and CELLSNET-57768 can be closed as this was fixed by setting the right resolution as suggested by you.

Regarding issue CELLSNET-57742, are there any updates?
Thanks.

amjad.sahi · February 18, 2025, 2:42pm

@JThomas98,

The details have been recorded in the corresponding tickets, which we may proceed to close (if feasible).

I am afraid, the issue has not been addressed yet. We will check if we could schedule it in the next few days. Once there is any update or new information on it, we will let you know here.

JThomas98 · February 18, 2025, 3:00pm

Thank you! Looking forward to it.

amjad.sahi · February 18, 2025, 3:05pm

@JThomas98,

You are welcome. We will keep you posted with new updates on it.

JThomas98 · February 18, 2025, 5:13pm

I have a few other issues that I’ve run into.

Test_02182025.zip (3.3 MB)

I’ve explained in detail every issue that I ran into in one of my tests along with some screenshots comparing it against excel.

The code I used is:

        Workbook workbook = new Workbook(path + "Chart_Template.xlsm");
        // Access the worksheet
        Worksheet worksheet = workbook.Worksheets["MeasureChartsNew"];

        // Set the print area with your desired range in the worksheet
        worksheet.PageSetup.PrintArea = "B98:M139";
        worksheet.PageSetup.LeftMargin = 0;
        worksheet.PageSetup.RightMargin = 0;
        worksheet.PageSetup.TopMargin = 0;
        worksheet.PageSetup.BottomMargin = 0;
        // Clear any header/footer as they'll be captured when converting the worksheet to image
        worksheet.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
        };
        // Take the image of your worksheet
        SheetRender sr = new SheetRender(worksheet, options);
        sr.ToImage(0, path + "MyOut.jpg");

amjad.sahi · February 18, 2025, 6:34pm

@JThomas98,

Thanks for the template Excel file and screenshots.

I am able to reproduce all your three issues you mentioned (via screenshots in the document) using your template Excel file and sample code snippet. 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-57839 - Missing labels on bottom and the blue header has vertical lines across it
CELLSNET-57840 - Labels moved for small proportions in Pie chart; font type is different in both sets of chart; missing labels on bottom-left bar chart; font kerning is reduced in some chart labels
CELLSNET-57841 - Different fonts in charts in Sheet to image conversion

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.

JThomas98 · February 18, 2025, 7:20pm

In my documentation, I’ve mentioned how the missing legend issue has come up in the past, CELLSNET-55343 might have been the issue ID. I thought this was resolved a long time ago.

amjad.sahi · February 18, 2025, 7:51pm

@JThomas98,

We have noted it down. Let us evaluate the issue(s) and then we can update you on the issues. Once we have an update on any of the issues, we will let you know here.

peyton.xu · February 20, 2025, 3:37am

@JThomas98 ,

In newer Excel, Excel re-designed the star graphic(Icon Set graphics). We will evaluate to following the new design. If we have any progress, we will update you here.
Screenshot_star_graphic_issue.jpg (264.3 KB)

JThomas98 · February 25, 2025, 3:32pm

Thank you. Looking forward to the updates.

amjad.sahi · February 25, 2025, 5:21pm

@JThomas98,

Sure, we will keep you informed as soon as the latest updates on the issue become available.

amjad.sahi · February 26, 2025, 1:44pm

@JThomas98,

We are pleased to inform you that your issue (logged earlier as “CELLSNET-57742”) has been resolved. The enhancement will be included in the next release (Aspose.Cells v25.3) scheduled for release first half of March (next month). You will be notified once the new version is published.

JThomas98 · February 26, 2025, 2:50pm

Can I see an output of the fix?

amjad.sahi · February 26, 2025, 3:03pm

@JThomas98,

Sure, we will check if we could provide you the output image generated by the latest fix. We will get back to you soon.

peyton.xu · February 27, 2025, 3:31am

@JThomas98 ，

Please check the output Emf image generated by the fix with the following code:

Workbook workbook = new Workbook("Template_Stnd_Type1.xlsm");
// Access the worksheet
Worksheet worksheet = workbook.Worksheets["ExecSummary"];

// Set the print area with your desired range in the worksheet
worksheet.PageSetup.PrintArea = "G25:N38";
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.BottomMargin = 0;
// Clear any header/footer as they'll be captured when converting the worksheet to image
worksheet.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
};
// Take the image of your worksheet
SheetRender sr = new SheetRender(worksheet, options);
sr.ToImage(0, "output_IconSet.emf");

Output_IconSet.zip (11.0 KB)

JThomas98 · February 27, 2025, 3:19pm

I can confirm this is looking exactly like excel. This is good. Thank you for sharing this with me.

amjad.sahi · February 27, 2025, 5:17pm

@JThomas98,

You’re welcome! I’m glad to hear the output image meets your needs well.

JThomas98 · February 27, 2025, 7:29pm

Hi Aspose Team, I’m seeing another set of issues:

            // Access the worksheet
            Worksheet worksheet = workbook.Worksheets["Segmentation"];

            // Set the print area with your desired range in the worksheet
            worksheet.PageSetup.PrintArea = "P1:AR39"; // "P47:AR85"
            worksheet.PageSetup.LeftMargin = 0;
            worksheet.PageSetup.RightMargin = 0;
            worksheet.PageSetup.TopMargin = 0;
            worksheet.PageSetup.BottomMargin = 0;
            // Clear any header/footer as they'll be captured when converting the worksheet to image
            worksheet.PageSetup.ClearHeaderFooter();

            // Set OnePagePerSheet option as true
            ImageOrPrintOptions options = new ImageOrPrintOptions()
            {
                OnePagePerSheet = true,
                ImageType = Aspose.Cells.Drawing.ImageType.OfficeCompatibleEmf,
                HorizontalResolution = 100 /*(int)oldShape.ImageData.ImageSize.HorizontalResolution*/,
                VerticalResolution = 100,
                OnlyArea = true
            };
            // Take the image of your worksheet
            SheetRender sr = new SheetRender(worksheet, options);
            string dataDir = @"C:\Aspose Test\Test_02272025\out_image1.emf";
            sr.ToImage(0, dataDir);

You can see that the first bar graph on the right has the value on top either being cropped out or barely visible. And majority of the vertical line to the right of this bar graph is missing.
Test_02272025.zip (856.6 KB)

JThomas98 · February 27, 2025, 8:59pm

And this template I have shared also contains another example that can be used to test CELLSNET-57840 - Labels moved for small proportions in Pie chart;
Worksheet: RespDemographics
Chart10
PieChart_Out1.png (8.9 KB)

JThomas98 · February 27, 2025, 9:29pm

→ When you compare charts in worksheet QuadrantMap, you’ll notice that the horizontal and vertical axis labels in “R1:AG38”, “R40:AG77” is in a different font and the footer text seems to be really bold (look at comparison2.PNG for reference)
→ And lastly, certain plottings in each quadrant is pointing the wrong way when compared to its excel counter part (look at comparison3.PNG for reference)
Test_02272025_2.zip (869.8 KB)

            // Access the worksheet
            Worksheet worksheet = workbook.Worksheets["QuadrantMap"];

            // Set the print area with your desired range in the worksheet
            worksheet.PageSetup.PrintArea = "R1:AG38"; // "R40:AG77"
            worksheet.PageSetup.LeftMargin = 0;
            worksheet.PageSetup.RightMargin = 0;
            worksheet.PageSetup.TopMargin = 0;
            worksheet.PageSetup.BottomMargin = 0;
            // Clear any header/footer as they'll be captured when converting the worksheet to image
            worksheet.PageSetup.ClearHeaderFooter();

            // Set OnePagePerSheet option as true
            ImageOrPrintOptions options = new ImageOrPrintOptions()
            {
                OnePagePerSheet = true,
                ImageType = Aspose.Cells.Drawing.ImageType.OfficeCompatibleEmf,
                HorizontalResolution = 100 /*(int)oldShape.ImageData.ImageSize.HorizontalResolution*/,
                VerticalResolution = 100,
                OnlyArea = true,
                SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality
            };
            // Take the image of your worksheet
            SheetRender sr = new SheetRender(worksheet, options);
            string dataDir = @"C:\Aspose Test\Test_02272025_2\out_image1.emf";
            sr.ToImage(0, dataDir);