Printing - Missing Cells and truncated rows

Aspose.Cells Product Family
1

When calling the SheetToPrinter method the printed output is not as expected. Some cells fail to be populated and also on the bottom of each page only the top portion of the last row is visable. Is this a known issue and is there a resolution.

Regards

Mark

2

Hi,

The SheetToPrinter should function equal to Excel’s Print Preview option. If you find the issue, kindly post your template file(s) here with all the details, we will check it soon.

Thank you.

3

Please find attached zip file with the template and printed output from Excel and from SheetToPrinter Method.

As you can see the bottom row is truncated on weach page and also the print area set in the worksheet is being ignored. I am printing with the following code :-

Workbook workbook = new Workbook();

workbook.Open(@"C:\ole\MB\template.xls");

workbook.Worksheets[0].SheetToPrinter("XPSPrinter");

4

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for sharing the template file.

I tested your template file with the attached latest version of Aspose.Cells and it works fine. Please see the exported PDF file (I used “Adobe PDF” printer option instead of “XPSPrinter”). Please try the attached latest version and let us know if it works fine for you.

Thank You & Best Regards,

5

Thanks, the updated dll resolved the issue.