When I save my sample Excel spreadsheet with a selection of charts in various styles to PDF, the resulting charts in the PDF are not rendered very smoothly compared to the results of using Excel’s Export PDF.
Here is my code for saving:
Aspose.Cells.PdfSaveOptions pdfSaveOptions = new Aspose.Cells.PdfSaveOptions(Aspose.Cells.SaveFormat.Pdf);
// set warning callback
pdfSaveOptions.WarningCallback = wbWarningCallback;
pdfSaveOptions.Compliance = Aspose.Cells.Rendering.PdfCompliance.None; // creates 1.4 PDF
wBook.Save(OUTPUT_DIR + OUTPUT_NAME, pdfSaveOptions);
And here is a zip with my test xlsx, a PDF from Word and my Aspose generated PDF: ChartStyles.zip (894.4 KB)
The edges of the cones are very jagged and any gradient/shading is no longer present.
The others are various styles. The flat ones seem to come through fine; it’s the 3D ones that aren’t quite right. In particular, the last two on the 4th page. The second from the bottom looses its 3D look and the last one has much wider spaces between the pie pieces and the edges, almost like the border wasn’t drawn.
Can you tell me if those types of charts are supported, and if not, is there any ETA for support for them?
Also, is there any changes to my save code that I can make ti improve the results?
We have generated the output Pdf using the most recent version. Please download it and add comments inside it for every problematic area. We will then log tickets based on your comments. Thanks for your cooperation in this regard.
Thanks for adding comments inside the output Pdf. We were able to observe these issues and logged them in our database for investigation and for a fix. Once, these issues are resolved or we have some other news for you, we will let you know asap.
These issues have been logged as
CELLSNET-45882 - Pie Chart Styled - is not rendered good in output PDF
CELLSNET-45883 - 3D Pie Chart - is not rendered good in output PDF
CELLSNET-45884 - Smart Art Chart on Tab - Cones edges are jagged in output PDF
CELLSNET-45882 - Pie Chart Styled - is not rendered good in output PDF
Soft Edges, Shadow, Glow and 3-D format are not supported.
We are afraid “the gradient background has a striping effect at certain zoom levels (50%, 66.7%, 79.3% etc.)”, we do not know why it is like that and it cannot be fixed now.
For your issue,
CELLSNET-45883 – 3D Pie Chart - is not rendered good in output PDF
We will provide a fix soon for border wide issues.
For your issue,
CELLSNET-45884 - Smart Art Chart on Tab - Cones edges are jagged in output PDF
For the chart in “Conical Chart” sheet, Aspose.Cells is different to MS-Excel because Aspose.Cells draws every element (e.g. lines, texts, rectangles and so on) independently. While MS-Excel draws plot with a picture. If you enlarge the scale of the pdf, you can find the chart is blurry.
For making the line smooth, you must check the “Smooth line art” of Adobe Reader as shown in the following screenshot.
For CELLSNET-45882 - is there any timeline on adding support for Soft Edges, Shadow, Glow and 3-D format?
For CELLSNET-45883 - thanks, I’ll watch for the update.
For CELLSNET-45884 - I knew that Excel’s chart output creates a picture; I could tell when I zoomed in. THe PDF created with Aspose’s Cells zooms much nicer as you are rendering each element.I did have the smooth line art option checked (always do). The update to 18.1 from 17.9 did make a huge difference in the output; cones are much better looking now than they were. The only issue now is the tiny tail that appears at the bottom of the cone when you zoom in (starts at about 150%).
It is good to know 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-45884) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi