Text Rendering issue

[mshyan_spire]

Hi Spire,

I have encounter an issue which is the text will overflow to outside designed box (excel column border) and AutoShape when trying to convert XLS to Image.
Pls advice any solution for this.

Thank you.

*Btw, I tried to upload attachment but it keep failing, please let me know how to give you sample if you need it for the testing.

** The text outside box is I draw border for 7 columns, and I write text with length that fit within the box on first column. (Font: Arial, Size: 14)
** For Auto Shape issue, my user added one blank space and next line before and after the content and make it fit to the shape.

[Doris.Liu]

Hi,

Thank you for your message!
Please provide the following information and send them to 'support@e-iceblue.com', we'll appreciate your assistance.

1. Your sample file.
2. Your system information(e.g. Windows10)
3. Your code language and project framework(e.g. C#, net8)

Sincerely,
Doris
E-iceblue support team

[mshyan_spire]

Hi Doris,

I just send in the email for your reference, thank you for helping ya.

[Doris.Liu]

Hi,

Thank you for your sharing.
I have reproduced your issue and logged it into our bug tracking system with SPIREXLS-5262. Our dev team will investigate this issue further. Once it's fixed, we will update you in time. Sorry for inconvenience caused.

Sincerely,
Doris
E-iceblue support team

[Doris.Liu]

Hi,

Thank you for your patience.
Glad to inform you we released Spire.XLS 14.6.6, which contains the fix of SPIREXLS-5262. Please download from the following link to test!

website: https://www.e-iceblue.com/Download/down ... t-now.html
nuget: https://www.nuget.org/packages/Spire.XLS/14.6.6

Sincerely,
Doris
E-iceblue support team

[mshyan_spire]

Hi Doris,

thank you for your updates and sorry to revert by this time. The left part still haven't solve in the latest patch Spire.Xls14.7.2, however the right part have been solved, thanks for your effort.

Kindly let me know if there is any update for the left side (highlighted part) ya. Thank you very much.

[Doris.Liu]

Hi,

Thank you for your reply.
I'm sorry, but after investigating the Excel document you provided, we found that there was already an issue with text overflow in the Excel document itself (as shown in the excel.jpg image below). Additionally, we tried converting the document to PDF using Microsoft Excel (as shown in the image below), and we can see that the overflow issue persists. Therefore, this is not a bug caused by our product. Thank you for your understanding.

Sincerely,
Doris
E-iceblue support team

[mshyan_spire]

Hi Doris,

I think I know the difference between my view with yours dy, previously I was always work with scale of 56% and the characters fits in table, however when I increase to 100% will display as what you shown. Therefore I can conclude that the file conversion will convert display with 100%.

Thanks for your clarification and helps for all the time.

[Doris.Liu]

Hi,

Thank you for your reply and understanding.
I'd like to clarify that our product's display of conversion results is not influenced by the zoom ratio. Despite adjusting the Excel zoom to 55%, the issue of content spilling over the borders persists (I've attached a screenshot for your convenience).
Should you have any further inquiries or concerns, please do not hesitate to reach out to us. We're here to assist you.

Sincerely,
Doris
E-iceblue support team

[mshyan_spire2]

Hi,


May I know which excel version you using?
Cause me and my friend using 2007 and 365 respectively able to simulate the situation I described. (I try to upload the image but seems like there is something wrong again)

[Doris.Liu]

Hi,

Thank you for your feedback.
I am using Office 2019 version.

Sincerely,
Doris
E-iceblue support team