How can I convert excel to PDF by Libreoffice and keep all format from excel file

Question

I can currently convert Excel to PDF using the command line, however I have a problem with the front after the conversion. I used Times New Roman in the excel file, but when I converted it to a PDF, I saw that the font was different. Please advise me on how to resolve this issue.

P.S. I'm using LibreOffice 5.0 and Centos 7 and my spreadsheet file is in Japanese.

Answer 1

"Times New Roman" typeface does not have any Japanese glyphs, as has already been stated in the comments. Therefore, depending on the Windows System, Excel will use glyphs from the supplemental fonts "Yu Gothic," "Meiryo," or "Arial Unicode MS." Therefore, even though Excel's GUI may list "Times New Roman" as a font, its glyphs cannot be from that font.

First of all the system which shall create a PDF from the Excel file must have a font containing appropriate Japanese glyphs. The system is in your case the CentOS Linux Distribution. So at first do # yum groupinstall "Japanese Support" as described in How to Install Asian Fonts on Red Hat & CentOS Linux Distributions.