Same font face in converted PDF

Mon Jun 26, 2023 3:18 pm

Hi,
I'm using Spire.Office 8.6.0 version of Java API to convert an Excel file into a PDF formatted file.
When I convert the source file "PPA Benchmarking_V1.1.xlsx" with the setting locale, the font looks good as per the source file but the J26 cell value [Fair Value (Input in Thousands)] is not converted fully. It misses Thousands) from the value.

In the same file without locale setting, the J26 cell value converted completely, but the font face differs from the source file as well as in converted other fields.

Attached are sample source code, source file, converted file and screenshots for your reference.

I could not attach the source file here and will share the same thru email.

PPABenchmarkingFlow.zip: (612.67 KiB) Downloaded 405 times

Tue Jun 27, 2023 2:34 am

Hi,

Thanks for your inquiry.
After checking our mailbox including junk/spam folder, we did not receive your email. In order to facilitate our investigation, we kindly request you to resend the email. Thanks in advance.

Best regards,
Wenly
E-iceblue support team

Tue Jun 27, 2023 6:00 am

Hi,
Shared the file thru email and please proceed at your end.

Tue Jun 27, 2023 9:10 am

Hello,

Thanks for sharing the information via email.
I have tested with the file and code provided by you, however, the result of my testing shows that regardless of whether the locale setting is used, the generated PDF will still have the issue of the disappearance of "Thousands". I have logged the issue into our bug tracking system with the ticket number SPIREXLS-4771. Our development team will investigate and fix it. Once it is resolved, I will inform you in time. Sorry for the inconvenience caused.

Sincerely
Wenly
E-iceblue support team

Mon Jul 17, 2023 8:00 am

Hello,

Thank you for your patience.
Regarding the issue SPIREXLS-4771, our developers have investigated and found that in the source document, the cell J26 has a row height of 2 lines of text in normal view, but it has a row height of 3 lines of text in layout view. Spire.XLS calculates the row height based on the normal view (2 lines of text) and then applies the column width from the layout view during document conversion, causing a mismatch in row height. As a result, the output file is missing one line, and the text ‘Thousands)’ gets lost. This behavior aligns with the rules set by Microsoft Excel, so it is not a bug in our product.
We suggest increasing the column width of column N in the Excel file by two pixels. This will ensure that the resulting converted file is correct. We have send the modified Excel file via email.
If you have any further questions or concerns, please don't hesitate to let us know.

Sincerely,
Wenly
E-iceblue support team