Free Support Forum - aspose.com

Excel2PDF merged cell conversion

I see that merged cell conversion is working, kind of.

For my spreadsheets that have merged cells, one row high, merged cells are being translated as long as they’re no more than two columns wide. My three and four column merged cells aren’t being translated properly.

I’ve attached an image to illustrate.

trying again with the attachment

Which version are you using? We cannot find this problem. Could you please upload your xls file here? Thank you very much.

Attached is the Excel source file.

We will check it ASAP.

We don’t find any problems. Please check the attached file.

Do you use the latest version of Aspose.Excel and Aspose.Pdf? They can be downloaded at http://www.aspose.com/Products/Aspose.Excel/Fixes/Aspose.Excel.zip and http://www.aspose.com/Products/Aspose.Pdf/Fixes/Aspose.Pdf.zip.

What code did you use to create your pdf’s?

Below is a snip of the code that transforms my format from excel to pdf:

'============== PDF Save =====================

xExcel.Save(“individual.xml”, FileFormatType.AsposePdf)

Dim pdf1 As Aspose.Pdf.Pdf = New Aspose.Pdf.Pdf

pdf1.BindXML(“individual.xml”, Nothing)

pdf1.Save(“C:\Cnetpub\wwwroot\BSA_EMEA_Contacts_Merit\mybsa_emea_reporting\Output\total.pdf”)

Dim xExcel As Excel = New Excel()
xExcel.Open("d:\a.xls")
xExcel.Save("d:\a.xml", FileFormatType.AsposePdf)

Dim pdf1 As Aspose.Pdf.Pdf = New Aspose.Pdf.Pdf()

pdf1.BindXML("d:\a.xml", Nothing)

pdf1.Save("d:\a.pdf")