Excel Charts Are Scaled when Converted to EMF Images in C#

Aspose.Cells Product Family
,
43

Hi @JThomas98
For CELLSNET-57199 ( The text before the graph is clipped), our optimized results are as follows, which will take effect in version 24.12.
CELLSNET57199_241120.png (5.6 KB)

44

This is looking good. Thanks for the update.

45

@JThomas98,

Thanks for your confirmation. The fixed version (Aspose.Cells v24.12) will be published in the first half of December 2024. We will notify you when the next release is released.

46

Hi @JThomas98
For CELLSNET-57200, our optimized results are as follows, which will take effect in version 24.12.
7_13_241121.png (3.7 KB)
7_14_241121.png (2.4 KB)

47

@leoluo,
These charts are looking right.
Thank you for the update!
Looking forward to the new version

48

@JThomas98,

Thanks for your feedback.

And, sure, we’ll keep you updated on the release of the new version (Aspose.Cells v24.12).

49

The issues you have found earlier (filed as CELLSNET-57199,CELLSNET-57200) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

50

Hi Aspose Team,
The issue CELLSNET-57199 is still not fixed in version 24.12.
Here are some screenshots of the text being clipped:
Screenshot 2024-12-10 163116.png (11.6 KB)

Screenshot 2024-12-10 163147.png (5.8 KB)

51

Hi @JThomas98
We used the Excel file you provided previously and can not reproduce the problem. However, the chart in the previously file does not seem to match the chart with the new problem in screenshot you provided. Please see my screenshot.
241211.png (46.5 KB)

We are sorry about this. Could you please provide the Excel file with the new issues? This would be helpful for us to further optimize this issue. Thank you very much.

52

Here’s the one I used.
Chart_Template3.zip (766.7 KB)

53

@JThomas98,

Thanks for the template XLSM file.

I tested your scenario/case with Aspose.Cells for .NET v24.12. I used your template XLSM file and render two charts (“DetailChart_USEDTRANS” and “DetailChart_WEBMATS”) from DetailReport worksheet but I could not reproduce the issue you mentioned. I found no part of text before the charts is clipped.

Workbook book = new Workbook("e:\\test2\\Chart_Template3.xlsm");
Chart chart = book.Worksheets["DetailReport"].Charts["DetailChart_USEDTRANS"];
Chart chart1 = book.Worksheets["DetailReport"].Charts["DetailChart_WEBMATS"];
ImageOrPrintOptions imageOptions = new ImageOrPrintOptions();
imageOptions.ImageType = ImageType.Png;
chart.ToImage("e:\\test2\\out_net1.png", imageOptions);
chart1.ToImage("e:\\test2\\out_net2.png", imageOptions);

out_net1.png (3.1 KB)
out_net2.png (3.0 KB)

Let us know if you find any issue with some other charts, which chart (from which worksheet(s))? Could you provide more details with sample code snippet to reproduce the issue on our end, we will check it soon.

54

Here are some test files I’ve used along with the code sample and outputs.
Charts 1, 2 & 3 are cases where the text is clipped.
Charts 4, 5 & 6 are cases where the text wrapping is different from what it is in excel.
Each of these files have a different template for you to see how it’s happening in all of these templates.
Template1.zip (1.1 MB)

Template2.zip (1.0 MB)

Template3.zip (1.1 MB)

string filePath = @"C:\Documents\Aspose Test\Template2\Chart_Template2.xlsm";
//Load the Excel file
Workbook workbook = new Workbook(filePath);
Chart chart1 = workbook.Worksheets["DetailReport"].Charts["DetailChart_USEDTRANS"];
Chart chart2 = workbook.Worksheets["DetailReport"].Charts["DetailChart_RATETRANS"];
Chart chart3 = workbook.Worksheets["DetailReport"].Charts["DetailChart_WEBMATS"];
Chart chart4 = workbook.Worksheets["DetailReport"].Charts["DetailChart_CPPR"];
Chart chart5 = workbook.Worksheets["DetailReport"].Charts["DetailChart_POPHLTH"];
Chart chart6 = workbook.Worksheets["DetailReport"].Charts["DetailChart_UM"];
ImageOrPrintOptions opts = new ImageOrPrintOptions
   {
        ImageType = ImageType.Png,
        VerticalResolution = 300,
        HorizontalResolution = 300,
        SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality,
        OnlyArea = true
   };
chart1.ToImage(@"C:\Documents\Aspose Test\Template2\Out_net1.png", opts);
chart2.ToImage(@"C:\Documents\Aspose Test\Template2\Out_net2.png", opts);
chart3.ToImage(@"C:\Documents\Aspose Test\Template2\Out_net3.png", opts);
chart4.ToImage(@"C:\Documents\Aspose Test\Template2\Out_net4.png", opts);
chart5.ToImage(@"C:\Documents\Aspose Test\Template2\Out_net5.png", opts);
chart6.ToImage(@"C:\Documents\Aspose Test\Template2\Out_net6.png", opts);

If VerticalResolution, HorizontalResolution, SmoothingMode and OnlyArea properties are not set, the text clipping is even more evident.

string filePath = @"C:\Documents\Aspose Test\Template2\Chart_Template2.xlsm";
//Load the Excel file
Workbook workbook = new Workbook(filePath);
Chart chart1 = workbook.Worksheets["DetailReport"].Charts["DetailChart_USEDTRANS"];
Chart chart2 = workbook.Worksheets["DetailReport"].Charts["DetailChart_RATETRANS"];
Chart chart3 = workbook.Worksheets["DetailReport"].Charts["DetailChart_WEBMATS"];
ImageOrPrintOptions opts = new ImageOrPrintOptions
   {
        ImageType = ImageType.Png
   };
chart1.ToImage(@"C:\Documents\Aspose Test\Template2\Out_net1.png", opts);
chart2.ToImage(@"C:\Documents\Aspose Test\Template2\Out_net2.png", opts);
chart3.ToImage(@"C:\Documents\Aspose Test\Template2\Out_net3.png", opts);

Out_net1.png (1.9 KB)

Out_net2.png (1.7 KB)

Out_net3.png (2.1 KB)

55

Hi @JThomas98
Thank you for providing the new template files. With these files, we are able to reproduce the issue.
We will prioritize solving the text clipped issue.

For the text wrapping issue, since there is no fixed standard line break position in Excel, it may occur when the percentage width on the right side is changed arbitrarily. We are sorry about this and we will continue to optimize to make it as good as possible.

56

@JThomas98
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-57418

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.

57

Thank you. I was really looking forward to this getting fixed in the new version.

58

@JThomas98,

You are welcome. We will keep you informed about any updates regarding the issue (Ticket ID: “CELLSNET-57418”). We hope to resolve it soon.

59

Hi @JThomas98
For this issue, based on the 3 new files you provided, the images of all generated charts are as follows:
CELLSNET-57418_241214.zip (704.5 KB)

  1. Text clipped problem is fixed.
  2. About line breaks issue, we have conducted research and testing. Since there is no fixed standard for line break positions, currently it is difficult to match every Excel’s line break positions. We have made adjustments as much as possible, and currently, the error in line break positions is within one word.
60

Let me go through each of these inputs and find out if everything’s looking alright. In terms of the text wrapping, I understand the situation. As long as it’s not a huge difference, I can work with it. Thanks.

61

@JThomas98,

Sure, feel free to take your time assessing the results (images) to see if they meet your expectations. Your feedback is valued.

1 Like
62

I’ve gone through all of the charts you’ve shared and I can confirm that it’s what I’m expecting. Thank you for sharing these. The next release is in January only, right?