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

@JThomas98,

Thanks for the sample documents.

We noticed the problem, which involves an additional page being added at the location you specified. We have recorded your sample documents against your issue (Ticket ID: “CELLSNET-56510”) in our database. We will investigate the matter and provide you with new updates.

@JThomas98 ,

It seems that you export Excel file to Emf image, and then insert the Emf image into Word document.

When OnlyArea is enabled, the width and height of generated image is changed, also the aspect ratio of the image is changed. It results the blank line below the image in the Word document moved to the next page.

Could you please share how do you generate the Emf image by office interop? Let’s take “Table1” section for example.

Hi @JThomas98
CELLSNET-56511 ( Some of the text in the chart, font rendering is not the same as Excel ) is fixed, the effect is as follows.
It will take effect in 24.9.
Fix240827.png (84.1 KB)

I tried the office compatible emf while converting the excel range to image just to see if the quality was better or if the formatting were more accurate.
In office interop, these charts are inserted as links using the paste special feature and the program updates the link to template excel workbook with the workbook that contains the actual data. And once the links are updated, the link is broken using microsoft interop.

This is looking good. Thank you!

@JThomas98,

Thanks for your confirmation on the issue (“CELLSNET-56511”).

Thanks for providing details. We will look into it and get back to you.

@JThomas98 ,

I have deeply looked into the Emf images in your shared “Office_Output.docm” file, the Emf images have the same view as the Normal View of source “ChartTest.xlsm” in Excel.

Enable OnlyArea is the closest approach to match the Normal View in Excel, even though there are still some differences. For the extra page added at the end of page 48 in Word document after enabling OnlyArea option, you may need to modify the Word document template.

I see. I’ll run some more tests on my end with OnlyArea enabled. In terms of the font size, I dont think OnlyArea does any difference. The size of the font still seems smaller compared to what is in excel. Is there a work around for it?

@JThomas98,

We have recorded your findings/details related to your issue (Ticket ID: “CELLSNET-56510”) in our database. We will analyze it further and respond to you.

@JThomas98 ,

The smaller font issue highlight in your screenshot “Comparison.jpg” is improved after enabling OnlyArea option. Please hightlight this issue where font size is obviously small after OnlyArea is enabled.

Sorry for the late reply. I’ve done some testing on my end with only area property set to true. The font resizing is not as significant as I’ve seen with the property disabled. So thank you for guiding me to the correct set of properties that matches my requirement. The fact that this property adds an extra page is beyond my understanding. But I’ve managed to find a workaround by removing any blank pages from the output. I’m looking forward to the new version that contains the fix for issue #56511. Thank you again for your help.

@JThomas98,

I am glad to hear that the font resizing issue has been resolved on your end. The upcoming release of Aspose.Cells for .NET v24.9, which includes a fix for “CELLSNET-56511”, is expected to be published in the next week.

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

Hey Aspose Team,
I’m still having some issues with the way some of the charts look when converted to an image using aspose compared to what it looks like in excel.
I’ve attached a document called differences which list out the issues I have. I’ve also attached a template for you to use for testing.
Test.zip (1.7 MB)

@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.

CELLSNET-57742: icon set is not same as MS Excel
CELLSNET-57741: Invalid color of category axis

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.

Thanks. I found another issue as well.
The background pattern in a few charts are missing in the aspose output.
I’ve attached a comparison document
Differences.zip (180.7 KB)

I think you’ve missed one issue I’ve mentioned. Issue #3 - Label wrapping into another line. Please let me know if you’ve noticed this. Thanks.

@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-57768

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,

Given that the thread is getting lengthy, certain part/portion might be overlooked. Could you please provide a more detailed explanation along with a sample Excel file, output image/PDF, and screenshots to demonstrate the issue and emphasize the differences? We will also check it.

Sure, here you go:
Test.zip (1.3 MB)