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

Aspose.Cells Product Family
,
8

Hi @JThomas98
For this problem, we have optimized, part of the image file is as follows.
240906.zip (2.3 MB)

We solved the problem that the newline position was too different from Excel.
Since there is no fixed standard for the position of line breaks, and Excel may have some newline logic that we are not able to know. this revision is intended to be as Excel as possible. However, there may be individual cases where there may be a one-word difference in the position of line breaks.

9

That’s looking good.

10

@JThomas98,

Thank you for your feedback. The enhancement/fix will hopefully be included in the upcoming release of Aspose.Cells v24.9, which is scheduled for this week.

Please stay tuned!

1 Like
11

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

12

Hi, Aspose Team
Even though the issue with the text wrapping has stopped, the graph to the right of the text seems to overlap the percentage text that follows the graph.
image.png (13.3 KB)

13

@JThomas98
We can reproduce the issue by testing on the latest version v24.9 using the following sample code. When converting chart to emf, it was found that the text and chart overlapped. Please refer to the attachment. chart.zip (3.6 KB)

The sample code as follows:

Workbook wb = new Workbook(filePath + "Chart.xlsm");
Chart chart = wb.Worksheets["MedicareCharts"].Charts["Q019"];
chart.ToImage(filePath + "chart.emf", ImageType.Emf);

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-56761

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.

15

How come in this screenshot, the text is not being overlapped by the graph?

16

@JThomas98,

We have already logged a ticket (CELLSNET-56761) for this issue and are currently investigating it. Please allow us some time to thoroughly evaluate the issue. We will provide you with an update as soon as we have more information.

17

Hi @JThomas98
The new issue is in table line “Q19” which is not contains in “240906.png” I sent before.

The results of our new optimizations are as follows, which will be included in version 24.10.

240918.zip (1.8 MB)

18

@leoluo , I understand. I was asking because I had shared all these templates previously. Anyways, I’m glad its fixed. Looking forward to the new release. Thank you!

19

@JThomas98 ，

Once Aspose.Cells for .Net 24.10(in Mid-October) is released, you will be updated here.

1 Like
20

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

21

Hey Aspose Team, I’m noticing a few more issues:

  1. In almost every chart from ExecSumReport worksheet, you’d notice that there is a [+] symbol in the bar graph in the image Aspose cells captures. But this isn’t there in excel. There are cases where there is either a [+] or [-] symbol in the graph (I’ve attached a second template, template2, to show this occurrence). In these cases, both the [+] and [-] symbols are coming together. There should only be one of these symbols along with each bar. Another thing is that the symbols are supposed to be towards the end of the bar, not at the beginning.
  2. In cases where there is no data for the year, excel shows a thin blue line even though there is no bar graph to be displayed. Where as in aspose, this thin blue line isn’t coming through.
  3. For the charts in DetailReport worksheet, the font color should be white for the percentage values inside the graph. This is being rendered as black in the aspose version.
  4. The shapes in the chart in QuadMap worksheet looks a little pixelated. This isn’t a big concern but I’d really appreciate if there’s something I can do to get a better quality.

Thank you.
Chart_Test.zip (1.8 MB)

22

@JThomas98,

We reproduced the three issues (1, 3 and 4) you mentioned using your template Excel files. We event tried using your both Excel files to convert to PDFs and still found the issues in the output PDFs. We require thorough evaluation of the issues. 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-57051 - “[+]” symbol in the bar graph captured in the output image
  • CELLSNET-57052 - The font color changed (should be white for the percentage values) in the graph image
  • CELLSNET-57053 - Chart is rendered little pixelated

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.

23

@JThomas98,

Could you please provide more details about this issue (#2). You may give screenshots and mention the names of the worksheets where issue occurred. We will evaluate the issue soon.

24

Thanks, @amjad.sahi for the quick response. Were you able to replicate issue mentioned in #2?

25

@JThomas98,

Check above reply and do the needful.

26

@amjad.sahi,
Here’s a screenshot of what the issue is:
Comparison.jpg (37.7 KB)

You can find this chart in worksheet ExecSumReport in template1. The chart is called ExecSumChart_COM

27

@JThomas98,

Thanks for the screenshot and details.

We reproduced the issue (#2) as you mentioned via screenshot using your template Excel files. We have opened the following new ticket in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s):

  • CELLSNET-57054 - Thin blue line for no data in bar graph is not rendered in the output 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.

One we have an update on it, we will let you know.

1 Like
28

@JThomas98,

We are pleased to inform that your issue (Ticket: “CELLSNET-57051 - “[+]” symbol in the bar graph captured in the output image”) has been implemented. The fix/enhancement will be included in our upcoming release (Aspose.Cells v24.11) that we plan to release in the first half of November 2024. You will be notified when the next version is released.