On Exsport to PDF charts not hiding #N/A items

Aspose.Cells Product Family
1

Please have a look. This worked on previous versions. The charts should not show the hidden info

2

Hi,


Thanks for your posting and using Aspose.Cells.

We have tested your issue with the latest version with the following code and found, Aspose.Cells is working fine and generating the chart images correctly.

Latest Version Links
Aspose.Cells for .NET v17.02.9 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.02.9 (.NET 4.0) compiled in .NET Framework 4.0.

Please download the output pdf generated with this code and compare the chart images inside it with your source excel file and it looks good.

Also, your excel file does not match with your images, so probably, you have attached wrong excel file. In this case, please provide us the correct excel file.

C#
//Load the workbook
Workbook wb = new Workbook(“GoldTrendGraphs.xlsx”);

//Perform the calculation if needed
// wb.CalculateFormula();

//Render all worksheet in a single pdf page
PdfSaveOptions opts = new PdfSaveOptions();
opts.OnePagePerSheet = true;

//Save the workbook in pdf format
wb.Save(“output.pdf”, opts);


3

Sorry I attached the incorrect file

4

Hi,


Thanks for your posting and using Aspose.Cells.

We have looked into this issue and it seems, this is not just one issue, there are multiple issues inside it. Could you please download your provided pdf file and add comments inside it to highlight all of the issues one by one. We will then create multiple tickets based on your comments. This will enable us to look into these issues more quickly and more precisely and we will provide you fix asap. Thanks for your cooperation in this regard and have a good day.

5

Hi


I added comment to the file.
6

Hi,


Thanks for your posting and using Aspose.Cells.

I have generated the output pdf using the following code with the latest version. Please download it and add comment inside it for every chart which is showing the issue. You have added comment for one chart only and said, this applies to all. This is not a useful comment. We need to create multiple tickets and each ticket will refer to your comment so please add comments for all of the charts which you want to get fixed.

However, this time, add comments inside this output excel file.

C#
//Load the workbook
Workbook wb = new Workbook(“Tramming+Graph.xlsx”);

//Perform the calculation if needed
wb.CalculateFormula();

//Render all worksheet in a single pdf page
PdfSaveOptions opts = new PdfSaveOptions();
opts.OnePagePerSheet = true;

//Save the workbook in pdf format
wb.Save(“output-” + CellsHelper.GetVersion() + “.pdf”, opts);

7
Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix

Aspose.Cells for .NET v17.3.5 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.3.5 (.NET 4.0) compiled in .NET Framework 4.0.

and let us know your feedback.