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.
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!
Thanks for your confirmation on the issue (“CELLSNET-56511”).
Thanks for providing details. We will look into it and get back to you.
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?
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.
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.
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
