Free Support Forum - aspose.com

PageSetup Draft mode and Save to PDF

Hello,

I am saving an Excel spreadsheet to a PDF and have the PageSetup.PrintDraft set to true. The definition for this property is “Represents if the sheet will be printed without graphics.”.

My resulting PDF file still contains the images in my Excel spreadsheet - does this property apply when save to a PDF? The other PageSetup properties such as PrintGridlines and BlackAndWhite do; is this a bug?

foreach (Aspose.Cells.Worksheet wSheet in wBook.Worksheets)
{
    if (!wSheet.IsVisible) continue;
    wSheet.PageSetup.BlackAndWhite  = PrintBW;
}

wBook.Save(OUTPUT_DIR + OUTPUT_NAME, pdfSaveOptions);

I am using Aspose.Cells for .NET 18.4.1.

Thanks,
Sheri

@sheri_steeves

Thanks for using Aspose APIs.

We were able to observe this issue and logged it in our database for investigation and for a fix. Once, the issue is resolved or we have some other news for you, we will update you asap.

This issue has been logged as

  • CELLSNET-46084 - PageSetup.PrintDraft does not take effect while Saving to Pdf

Download Links:
Input and Output Files.zip (551.5 KB)
screenshots.zip (300.2 KB)

C#

Workbook wb = new Workbook("s1.xlsx");
Console.WriteLine(wb.Worksheets[0].PageSetup.PrintDraft);
wb.Save("ByCells.pdf");

@sheri_steeves

Thanks for using Aspose APIs.

This is to inform you that we have fixed your issue CELLSNET-46084 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

@sheri_steeves

Thanks for using Aspose APIs.

Please download and try the following fix and let us know your feedback.

Hello,

Retested this against Aspose.Cells for .NET 4.0 - 18.4.5 -> issue is resolved.

Thanks for the quick fix.

Sheri

@sheri_steeves

Thanks for sharing good news with us that your issue is resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.

The issues you have found earlier (filed as CELLSNET-46084) have been fixed in this update. Please also check the document/article for your reference: https://docs.aspose.com/display/cellsnet/Installation