Xlsx to PDF issue with row height

[jon@alphakinetic.com]

Hi,

We have an issue with Excel to PDF conversion of one of our documents. I'll send the original spreadsheet and the resulted pdf via email as it contains client's sensitive data - the first row of "S&P Changes" column is incorrect (only "Upgrade" word is displayed). We are using Workbook.SaveToFile(pdfPath, FileFormat.PDF) for the conversion.

Thanks.

[rachel.lei]

Hello,

Thanks for your post.
Ok, I will wait for your email and then investigate your issue further.

Sincerely,
Rachel
E-iceblue support

[rachel.lei]

Hello,

Thanks for your sharing via email.
I tested your case and did reproduce your issue. This issue has been logged into our bug tracking system with the ticket SPIREXLS-2361. We will inform you if there is any progress. Sorry for the inconvenience caused.

Sincerely,
Rachel
E-iceblue support team

[amy.zhao]

Hi Jon,

Hope you are doing well. I’m writing to tell you the update about your issue.
By analyzing the internal data of your document, we found that there is no row height data for the 6th row. For this situation, our product internally will use "DefaultRowHeight" as its row height, which can only display one line of text, so the content of generated PDF is incorrect.
We have verified that if your documen is resaved in Microsoft Excel, the generated PDF is consistent with the source file.
Meanwhile, you can also invoke the method “AutoFitRow” to autofit the row height to display all the text, as shown below.

Workbook wb = new Workbook();
wb.LoadFromFile("original.xlsx");
//Get default row height
//double defaultRowHeight = wb.Worksheets[0].DefaultRowHeight;
//Autofit row height
wb.Worksheets[0].AutoFitRow(6);
wb.SaveToFile("out.pdf", FileFormat.PDF);

Sincerely,
E-iceblue support team