Converted values are blank

Tue Jun 06, 2023 1:48 pm

Hi Team,
I'm converting excel file into PDF format using spire.office-8.5.6 Java API jar.
When I try to convert "Portfolio Valuation Model - Apera Dec2.xlsm" file, I'm getting blank pages for all many sheets from "LoanData, Mkt. etc".
But when I do double click on the blank pdf page, some texts are highlighted.
I have attached screenshots and sample source code for your reference.
I could not attach source file in this thread, so I will share the same thru email.

I really appreciate your support in advance.

Apera-LoanData.zip: (183.46 KiB) Downloaded 404 times

Wed Jun 07, 2023 4:07 am

Hi,

Thanks for your feedback.
I have tested your document with the latest version of Spire.Office_8.5.6 using your code and found that the resulting page count is different from yours, but I was unable to reproduce the issue of blank pages appearing after converting the Excel document to PDF. I will send you my result document and some screenshots via email for your reference. Please confirm if there is any problem with my test result document.

I have checked some parts of the result document, but as it is quite large, there may be areas that I have not examined thoroughly.

Btw, could you please share us with your test environment? Such as the version of JDK and region setting. Thank you for your cooperation.

Best regards,
Triste
E-iceblue support team

Wed Jun 07, 2023 7:57 am

Hi Triste,
After reviewing your response, I checked with other converted files.
I have a problem with PDF reader. After updating, I'm able to view actual content for Loan Data and Mkt sheets.
Sorry for the inconvenience.
Thanks for your extended support.

Wed Jun 07, 2023 9:00 am

Hi,

Thanks for your reply.
You are welcome. If you have any other questions, just feel free to contact us. We are always available to assist you.

Have a nice day!

Best regards,
Triste
E-iceblue support team