Still，excel save to pdf，over pages

Aspose.Cells Product Family
1

last question here When Turn Excel to PDF,I find somthing different from using Microsoft.Office.Interop.Excel - #8 by amjad.sahi

here is my test excel test.zip (1.1 MB)

i find if the bottom margin + bottom empty content height is bigger than some fixed number（pdf one page height？），it will over pages.

please solve it，i have asked 3 same questions ，and 2 version said it had solved .

i have many excel template，i cannot redesigned everyone to adjust your tools。

please answer me as soon as possible.

2

@cubujifang,
You can try below code and then let us know your feedback.

Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(dataDir + "20190816104433781.xls");
if (File.Exists(dataDir + "targetPdfFile"))
{
    File.Delete(dataDir + targetPdfFile);
}
Aspose.Cells.PdfSaveOptions options = new Aspose.Cells.PdfSaveOptions();
options.Compliance = Aspose.Cells.Rendering.PdfCompliance.None;
options.OnePagePerSheet = true;
wb.Save(dataDir + "targetPdfFile.pdf", options);
3

i cannot set options.OnePagePerSheet = true;
because i need the pdf show what excel show，if the sheet have 2 pages，it will show one pages，that is not what i need，i dont want to design excel by code，i have designed it before in excel.

4

@cubujifang,

There are a few fonts which are not installed on my pc. Please zip the fonts (.ttf files) used in the workbook and provide us, we will check it soon.

5

@cubujifang,
We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46875 - excel save to pdf，over pages
6

@cubujifang,
Please try our latest version/fix: Aspose.Cells for .NET v19.8.2 (attached)

Your issue (logged earlier as “CELLSNET-46875”) should be fixed in it.

Let us know your feedback.
Aspose.Cells19.8.2 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.8.2 For .Net4.0.Zip (4.9 MB)

7

The issues you have found earlier (filed as CELLSNET-46875) have been fixed in Aspose.Cells for .NET v19.9. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi