Free Support Forum -

Charts Do Not Honor Page Setup Black and White



When creating a PDF file from a workbook with multiple sheets with data, images and charts, and setting PageSetup.BlackAndWhite to true, the charts are not being converted to black and white; they are still color.

Thinking they may need to have their own PageSetup settings, I also tried looping through all the charts on each sheet and set the charts’s PageSetup.BlackAndWhite to true.

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

    // check for charts in each sheet, and chart sheets
    if ( wSheet.Charts.Count > 0)
        foreach (Aspose.Cells.Charts.Chart sheetChart in wSheet.Charts)
            sheetChart.PageSetup.BlackAndWhite = PrintBW;

wBook.Save(OUTPUT_DIR + OUTPUT_NAME, pdfSaveOptions);

I am using Aspose.Cells .NET 18.4.3 (updated DLL from another issue).

This is my sample XLS file: Images and Charts (1.5 MB)





Thanks for using Aspose APIs.

We were able to observe this issue as per your description by executing your sample code. Please check the output Excel and Aspose.Cells generated Pdfs for a reference.

Download Link:
Excel and Cells (2.7 MB)

We have logged this issue 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-46093 - Charts do not honor Page Setup Black and White



Thanks for using Aspose APIs.

This feature is not supported now. We will implement it before September 2018.


I’ve just retested this today against the 19.1 ibraries from NuGet and the issue still exists. The embedded charts are still in color in the resulting PDF. Is there a new setting that I need to apply or is this still an open issue?



I have checked the status of this ticket, which is still open. This issue is not resolved yet and we will write back here once any feedback is ready to share.



The feature is still not supported. Supporting chart’s black and white is too complex. We will look into the issue soon and support simple charts first.



Please try our latest version/fix: Aspose.Cells for .NET v19.3.2 (attached)

Your issue should be fixed in it.

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


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