Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Fri Dec 07, 2018 6:22 am

hello

When i convert a excel file to pdf, some text garbling.

I have uploaded the sample file.
So you can find,
the text with font MS Gothic is good
but text with meiryo ui is not good, and in a textbox with meiryo ui is good.

Can you tell me the reason, and how to solve it ?

Thanks
Attachments
ConverPDF_text_garbling.zip
(7.36 KiB) Downloaded 211 times

wenl.sun
 
Posts: 9
Joined: Wed Oct 14, 2015 4:10 am

Fri Dec 07, 2018 8:24 am

Hi,

Thank you for your inquiry.
After an initial test with the latest Spire.Office (DLL Only) Version:3.11.5, I got a different result. Both the Meiryo UI font in the cell and in the textbox become incorrect after converting to PDF. To help us compare the result and better look into the case, could you please send your result PDF file to us?
Here in the attachment is the generated PDF on my side.

Sincerely,
Jane
E-iceblue support team
Attachments
result.zip
(28.78 KiB) Downloaded 214 times
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Fri Dec 07, 2018 9:09 am

Thanks for your answer.

But i used Spire.xls version 8.116.6043 not spire for office
Attachments
ConverPDF_text_garbling.zip
this is the result file
(50.13 KiB) Downloaded 223 times

wenl.sun
 
Posts: 9
Joined: Wed Oct 14, 2015 4:10 am

Fri Dec 07, 2018 9:32 am

Hi,

Thank you for your quick reply.
The latest Spire.xls version 8.116.6043 also gives the same result on my side.
Please share the following information to help us reproduce the issue.
1. Your testing environment(OS as well as the Language and Region information), e.g. Win7, 64 bit, Japanese, Japan.
2. Make sure that the Meiryo UI font is installed on your system.
3. Please directly save the Excel file as PDF format in MS Excel and see if the result is correct.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Fri Dec 07, 2018 10:38 am

Here is the development information

1. Your testing environment(OS as well as the Language and Region information), e.g. Win7, 64 bit, Japanese, Japan.
The OS is Windows10, 64bit, Japanese, Japan

2. Make sure that the Meiryo UI font is installed on your system.
The font Meitro UI has installed on the OS, because i can select it in Excel.

3. Please directly save the Excel file as PDF format in MS Excel and see if the result is correct.
Please check the attached file

By the way, this time i use .NET Framework 4.6.1

Thanks.
Attachments
ConverPDF_text_garbling_2.zip
(251.62 KiB) Downloaded 194 times

wenl.sun
 
Posts: 9
Joined: Wed Oct 14, 2015 4:10 am

Mon Dec 10, 2018 7:41 am

Hi,

Thank you for your reply.
Sorry I did not reproduce your issue with even the same environment. The different phenomena should be caused by the different fonts installed on our system, for instance, the font version may influence the result. Could you please send the related font installed on our system to help us look into the case? We need all the fonts used in your Excel document including "MS ゴシック", "メイリオ", "Meiryo UI" and "Meiryo".

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Thu Dec 13, 2018 10:20 am

The file size of font is too large (over 50 MB). How can i send it to you?

wenl.sun
 
Posts: 9
Joined: Wed Oct 14, 2015 4:10 am

Fri Dec 14, 2018 1:43 am

Hi,

Thank you for your response.
Please upload the fonts to DropBox or OneDrive and then share the download link.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Wed Dec 19, 2018 5:58 am

Hi,

Greetings from e-iceblue!
How is the issue now? Could you please share the font we need to help us look into the issue?

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Return to Spire.XLS