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

0 votes
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.
Oct 3, 2022 in Others by Kithuzzz
• 38,020 points
1,592 views

1 answer to this question.

0 votes

"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.

answered Oct 3, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

How can I scrape a excel file from a website and divide it in different parts?

Use Scrapy or beautifulsoup4 parsing data it's more convenient ...READ MORE

answered Jan 13, 2023 in Others by narikkadan
• 63,720 points
598 views
0 votes
1 answer

Uipath(RPA) : read data from the PDF file and write to Excel file

If you want to use UiPath and ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 63,720 points
2,080 views
0 votes
1 answer

How to find out how many rows and columns to read from an Excel file with PHPExcel?

Solution: $file_name = htmlentities($_POST['file_name']); $sheet_name = htmlentities($_POST['sheet_name']); $number_of_columns = htmlentities($_POST['number_of_columns']); $number_of_rows ...READ MORE

answered Oct 23, 2022 in Others by narikkadan
• 63,720 points
7,822 views
0 votes
1 answer

How can I convert a Word document to PDF?

This is a difficult task, made even ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 63,720 points
1,284 views
0 votes
1 answer

Converting .pdf files to excel (.xls)

It is not always possible and typically ...READ MORE

answered Oct 30, 2022 in Others by narikkadan
• 63,720 points
802 views
0 votes
1 answer

Print chosen worksheets in excel files to pdf in python

In the simplest form: import win32com.client o = win32com.client.Dispatch("Excel.Application") o.Visible ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 63,720 points
3,419 views
0 votes
1 answer

Java Spring - Writing Excel file and converting to PDF

Since you are using Spring I suggest ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 63,720 points
2,473 views
0 votes
1 answer

Convert Excel to PDF issue with documents4j

MS Excel may not always be used ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 63,720 points
1,419 views
0 votes
1 answer

How can I convert excel file to pdf using TCPDF?

PHPExcel can only read charts from Excel2007 ...READ MORE

answered Oct 21, 2022 in Others by narikkadan
• 63,720 points
2,015 views
0 votes
1 answer

How can I preserve the format while exporting data from excel to evernote

The contents for an Evernote note are ...READ MORE

answered Jan 5, 2023 in Others by narikkadan
• 63,720 points
1,051 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP