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.

Mon Aug 24, 2020 12:23 pm

Hello,

I have defined number format of cells in Excel.

When I convert that Excel file into PDF, I get other format.

Excel format: 1 920,08
PDF format: 1,920.08

Excel screenshot:
Image

PDF screenshot:
Image

How can I retain excel data format ?

My Spire.XLS version is: spire.xls.free-2.2.0

I simply load xlsx document and save it as code snippet bellow:
com.spire.xls.Workbook wbToExcel = new com.spire.xls.Workbook();
wbToExcel.loadFromFile("ExcelOutput\\" + Utils.getCustomerInformation(customer, 1) + "_credit_note.xlsx");
wbToExcel.saveToFile("PDFOutput\\" + Utils.getCustomerInformation(customer, 1) + "_credit_note.pdf", FileFormat.PDF);

nalimleinad
 
Posts: 3
Joined: Mon Aug 24, 2020 12:00 pm

Tue Aug 25, 2020 7:29 am

Hello,

Thanks for your inquiry.
To help us investigate your issue more accurately and quickly, please provide your input file, your OS information (E.g. Win7, 64 bit) and region setting (E.g. China, Chinese). You can upload your file here or send it to us(support@e-iceblue.com) via email. Thanks in advance.
Besides, I suggest you can test your case with our commercial version (the latest version is Spire.XLS for Java Version:3.7.5), since it is more stable and contains more bug fixes.

Sincerely,
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Wed Aug 26, 2020 2:53 pm

Hello,

I´m using Windows 10 Pro, detailed system information in attachement.

Locale: Czech
Region: Czech
Country: Czech Republic

I´ve updated Spire.XLS jar library to latest as you mentioned, but output is same.

You can find input file in the attachement too.
Attachments
HW_Info+input_file.zip
(18.99 KiB) Downloaded 143 times

nalimleinad
 
Posts: 3
Joined: Mon Aug 24, 2020 12:00 pm

Thu Aug 27, 2020 3:01 am

Hello,

Thanks for providing your file.
I tested your scenario with Free Spire.XLS for Java v2.2.0 and Spire.XLS for Java v3.7.5 ,and did reproduce your issue. This issue has been logged in our bug tracking system with the ticket SPIREXLS-2695 for further investigation. We will keep you informed if there is any progress. Sorry for inconvenience caused.

Sincerely,
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Fri Sep 25, 2020 9:24 am

Hello,

Hope you are doing well.
Glad to inform you that we just released Spire.XLS for Java Version:3.9.3 which fixes your issue. Welcome to download it from the following links.
Our website: https://www.e-iceblue.com/Download/xls-for-java.html

Sincerely,
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Fri Oct 02, 2020 10:17 am

Hello,

Thank you!

It works fine now.

nalimleinad
 
Posts: 3
Joined: Mon Aug 24, 2020 12:00 pm

Mon Oct 05, 2020 1:12 am

Hi,

Thanks for your feedback.
If you need assistance in the future, please do not hesitate to contact us.
Wish you a nice day!

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.XLS