Hello,
It seems that calculation of height with AutoFitRows function is bugged when cells value is only composed by numeric values --> part of values are not displayed.
Please find the template and the produced files in attached zip.
Our implementation:
Dim szFile As String = “C:\Temp\file.xlsx”
Dim szFilePdf As String = szFile + “.pdf”
Dim wb As Aspose.Cells.Workbook = Nothing
Dim sb As Aspose.Cells.Worksheet = Nothing
Dim options As Aspose.Cells.AutoFitterOptions = New Aspose.Cells.AutoFitterOptions
options.AutoFitMergedCells = True
wb = New Aspose.Cells.Workbook(szFile)
sb = wb.Worksheets(0)
sb.Cells(6, 3).Value = "415 416 417 418" ' TEST file1.xlsx.pdf
'sb.Cells(6, 3).Value = "!415 !416 !417 !418" ' TEST file2.xlsx.pdf
sb.AutoFitRows(6, 6, options)
wb.Save(szFilePdf, Aspose.Cells.SaveFormat.Pdf)
Thanks for your help.
Test.zip (72.7 KB)