Some pictures are cut off in PDF

Aspose.Cells Product Family
1

I attach source xlsx and a screenshot. Some pictures are cut off. The other part of the picture appears on the next page.

2

Hi Chrustain,


Thank you for contacting Aspose support.

Please use PdfSaveOptions.OnePagePerSheet property to fit the contents of one worksheet on one page of the PDF. Please check the following code snippet and attached snapshot for your reference.

C#

var book = new Workbook(“D:/temp/MontageanweisungMultifunctionbraketRLC307.xls”);
book.Save(“D:/output.pdf”, new PdfSaveOptions() { OnePagePerSheet = true });

3
Hi,

Thanks for the template file.

Well, Aspose.Cells renders PDF file based on what is shown in print preview of sheets in MS Excel (MS Excel built-in renderer for PDF also renders the PDF file in the same way - you may confirm it in MS Excel). I also check the print previews for some other sheets and these sheets shows two pages in the print preview mode in MS Excel too, some pictures (e.g in the sheet "Tabelle3") are shown in two pages, so these would be rendered in two pages in the output PDF file as well.


If you need each worksheet should be rendered in one page into the output PDF file format, you may try to set OnePagePerSheet attribute to set it to true for your needs, see the sample code for your reference:
e.g
Sample code:

Workbook workbook = new Workbook(stringFilePath);
PdfSaveOptions pso = new PdfSaveOptions(SaveFormat.Pdf);
pso.OnePagePerSheet = true;
workbook.Save("e:\\test2\\out1.pdf", pso);

And, please try our latest version/ fix: Aspose.Cells for .NET v8.3.0.3

Thank you.