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.

Sun Sep 26, 2021 7:48 am

4758C33F-1940-4023-942F-4D4F27C8F931.png
the code
4758C33F-1940-4023-942F-4D4F27C8F931.png (9.59 KiB) Viewed 2780 times

8B5CCB91-7066-4d3c-8846-6D8BF4BF016A.png
the convert pdf's header
8B5CCB91-7066-4d3c-8846-6D8BF4BF016A.png (7.54 KiB) Viewed 2780 times

AD2557C0-82AC-416a-8133-6564D47CB67E.png
1.xlsx fule
AD2557C0-82AC-416a-8133-6564D47CB67E.png (32.5 KiB) Viewed 2780 times

raochenglong
 
Posts: 18
Joined: Mon Aug 23, 2021 5:11 pm

Sun Sep 26, 2021 7:55 am

the char unicode https://utf8-icons.com/utf-8-character-143863
Whether it is the processing of the character that caused the garbled

raochenglong
 
Posts: 18
Joined: Mon Aug 23, 2021 5:11 pm

Sun Sep 26, 2021 9:19 am

Hello,

Thanks for your inquiry.
Please check whether the fonts used in your excel file have been installed on your computer or not. Because when our spire api performs excel to pdf conversion, it needs to read the font information from the computer to draw the text to the PDF document.
If you have installed the fonts, but the issue still exists, could you please share your excel file for investigation? Thank you!

Sincerely,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Mon Sep 27, 2021 1:39 am

the fonts "Arial" have been installed in my computer.
F66E8B63-4BF5-46d3-ACAB-4D09EAECFD72.png
none
F66E8B63-4BF5-46d3-ACAB-4D09EAECFD72.png (202.53 KiB) Viewed 2761 times

1.zip
the xlsx file
(8.88 KiB) Downloaded 253 times

raochenglong
 
Posts: 18
Joined: Mon Aug 23, 2021 5:11 pm

Mon Sep 27, 2021 6:38 am

感谢您的反馈。因您的文档转换时丢失内容的那部分是中文字符,需要使用支持中文字符的字体绘制, 我查看了您的文档字体定义(在解析后的styles.xml文件),里面有设置“宋体”字体,请确保您的电脑上也安装了中文字体(比如“宋体”)。我这边测试了您的文档,内容是可以转换成功的。
字体.png
字体.png (53.63 KiB) Viewed 2751 times

另外我们也支持不安装字体,而是将字体文件通过 book.CustomFontFilePaths代码引用过来。
Code: Select all
            Workbook book = new Workbook();
            book.LoadFromFile("1.xlsx");
            book.CustomFontFilePaths = new string[] { @"C:/simsun.ttf" };
            book.SaveToFile("1.pdf",Spire.Xls.FileFormat.PDF);


希望上面的建议能帮助到您,如有任何问题,请及时反馈给我们。

Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Mon Sep 27, 2021 7:02 am

F66E8B63-4BF5-46d3-ACAB-4D09EAECFD72.png
the font 宋体 install
F66E8B63-4BF5-46d3-ACAB-4D09EAECFD72.png (159.42 KiB) Viewed 2748 times

宋体 had install in my computer.
current lib version is
<PackageReference Include="Spire.Office.NETCore" Version="6.8.2" />

raochenglong
 
Posts: 18
Joined: Mon Aug 23, 2021 5:11 pm

Mon Sep 27, 2021 7:29 am

Is it a char
2.png
U+231F7
2.png (5.5 KiB) Viewed 2741 times

the supported font is not in excel lead to?
the suppor font had install in my conpute.
3.png
SimSun-ExtB
3.png (33 KiB) Viewed 2741 times

raochenglong
 
Posts: 18
Joined: Mon Aug 23, 2021 5:11 pm

Mon Sep 27, 2021 8:06 am

Hi,

Thanks for your feedback.
After further investigation, I found the missing characters were using the font with bold style. Does your computer install the font with bold style supports the Chinese characters? If not, please try to install such a font.
My computer installed SimSun-ExtB font, but the character below was missing in converted pdf file. I have logged it into our issue tracking system with the ticket SPIREXLS-3464.
2.png
2.png (5.5 KiB) Viewed 2731 times


Sincerely,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Mon Oct 25, 2021 7:11 am

Hello,

We have fixed SPIREXLS-3464 issue. Welcome to download and test Spire.XLS Pack(Hotfix) Version:11.10.4.
Website link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
NuGet link: https://www.nuget.org/packages/Spire.XLS/11.10.4

Sincerely,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Mon Oct 25, 2021 8:24 am

amy.zhao wrote:Hello,

We have fixed SPIREXLS-3464 issue. Welcome to download and test Spire.XLS Pack(Hotfix) Version:11.10.4.
Website link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
NuGet link: https://www.nuget.org/packages/Spire.XLS/11.10.4

Sincerely,
Amy
E-iceblue support team

when version for the Spire.Office.NETCore?

raochenglong
 
Posts: 18
Joined: Mon Aug 23, 2021 5:11 pm

Mon Oct 25, 2021 8:45 am

Hello,

We can't provide the date for the release of the new version of Spire.Office now. When it is released, we will inform you.
Thanks for your understanding.

Sincerely,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Thu Oct 28, 2021 10:09 am

Hello,

Thanks for your patient waiting.
The new version of Spire.Office has been released. Welcome to donwload and test Spire.Office Platinum(Hotfix) Version:6.10.3.
Our website link: https://www.e-iceblue.com/Download/download-office-for-net-now.html
NuGet link:https://www.nuget.org/packages/Spire.Office/6.10.3
https://www.nuget.org/packages/Spire.Office.NETCore/6.10.3

Sincerely,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.XLS