I have an excel workbook, which has an vertical page break after column “Aug14”, and I also set printing setting fit to “0” page wide and “1” page tall. So I expect it will print two pages, and the first page will stop at column “Aug14”. The excel will print correctly based on the page break and scaling setting. Aspose print result will print in two pages as well, but not respect the page break.
Dim options As New Aspose.Cells.Rendering.ImageOrPrintOptions()
Dim pdlg As New PrintDialog
Dim wr As WorkbookRender
If pdlg.ShowDialog() = DialogResult.OK Then
printerName = pdlg.PrinterSettings.PrinterName
'Print the workbook.
options.PrintingPage = PrintingPageType.Default
wr = New WorkbookRender(MyWorkBook, options)
wr.ToPrinter(pdlg.PrinterSettings)
End If
I have attached the excel workbook, and also the results print from both Excel and using Apose, you can see the difference.
We were able to observe this issue after executing your code with the latest version: Aspose.Cells for .NET 8.3.0.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
CELLSNET-43187 - Printing does not respect page break and scaling setting correctly
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.