We believe that we have found a serious bug in the Aspose.Cells library. This issue occurs when both the Worksheet.PageSetup.PrintTitleColumns and the Worksheet.PageSetup.PrintTitleRows are set and the rows and columns overlap. When the workbook is saved to PDF format from code, the overlapping cells are rendered in the resulting PDF twice. It also seems to render some extra grid lines which don’t appear anywhere else.
For example, if I set the following properties in C#:
sheet.PageSetup.PrintTitleColumns = “$A:$B”;
sheet.PageSetup.PrintTitleRows = “$1:$5”;
and save the workbook as a PDF, then cells $A$1:$B$5 will be duplicated in the PDF. This causes other alignment issues in the output document, such as “ghost” gridlines which have no apparent source.
Hi Zane,
Please use the attached updated version Aspose.Cells5.1.4.5. If the issue persists then post the details along with sample application and Excel file. We will look into the issue soon.
Thanks,