- Ignores the margins.
- Ignores the page breaks.
Thanks for your using Aspose.Cells.
Please download and try the latest fix: Aspose.Cells for .NET v184.108.40.206 and let us know your feedback.
The issues you have found earlier (filed as CELLSNET-44407) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
Thanks for your posting and using Aspose.Cells.
I have tested this issue with the following sample code with older and latest version: Aspose.Cells for .NET v220.127.116.11 and both output images look same. I have attached them for your reference.
var xls1 = new Workbook(“tstFile.xlsx”);
for (int i = 0; i < xls1.Worksheets.Count; i++)
var opt = new ImageOrPrintOptions
Quality = 100,
VerticalResolution = 200,
HorizontalResolution = 200,
PrintingPage = PrintingPageType.IgnoreBlank,
ImageFormat = ImageFormat.Png,
OnePagePerSheet = true,
OnlyArea = false
xls1.Worksheets[“Sheet1”].PageSetup.PrintArea = “B2:B4”;
var sh1 = new SheetRender(xls1.Worksheets[“Sheet1”], opt);
var image = sh1.ToImage(0);
image.Save(CellsHelper.GetVersion() + “-out.png”);
Please note, we have also tested this issue with older version mentioned by you, both output images are attached for your reference.