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)
@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!
Once Aspose.Cells for .Net 24.10(in Mid-October) is released, you will be updated here.
1 Like
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
Hey Aspose Team, I’m noticing a few more issues:
- 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.
- 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.
- 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.
- 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)
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.
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.
@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
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
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.
@amjad.sahi, thank you for updating me. Is it possible to share a screenshot of the fix? There should be one where there is supposed to be [-] symbol to the right of the graph for one line. If you could show me what this graph looks like now, I’d really appreciate it.
Here’s a screenshot of a graph that contains the symbol. This is in Template2 that I previously shared:
Chart1.jpg (66.6 KB)
Sure, the issue is fixed precisely/fully which convers all your mentioned problems. For the time being, see a sample image (attached) which is generated by the fix.
241025.png (912 Bytes)
We might not provide all the images by different charts in the template Excel file. But we will check if we could provide you more images by the latest fix for your reference.
Sounds good. Thank you!
You are welcome. We will also keep you posted with updates on your other issues once available.
We are pleased to inform that your issue (Ticket: “CELLSNET-57052 - The font color changed (should be white for the percentage values) in the graph image") has been resolved. 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.
1 Like
Hi @JThomas98
For CELLSNET-57053, the shape edge is pixelated, please try the following code:
book = new Workbook(path + "Chart_Template1.xlsm");
Chart chart = book.Worksheets[9].Charts[0];
ImageOrPrintOptions imageOptions = new ImageOrPrintOptions();
imageOptions.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
imageOptions.ImageType = ImageType.Png;
chart.ToImage(path + "CELLSNET57053.png", imageOptions);
Attached is a comparison of my output images for your reference:
CELLSNET-57053.zip (30.2 KB)
Hi @JThomas98
For CELLSNET57054, our optimized results are as follows, which will take effect in version 24.11.
CELLSNET57054.png (967 Bytes)