Aspose PDF - Funnel Chart coming as empty

Aspose.Cells Product Family
1

Tried exporting the aspose cell, its coming up as empty in pdf in excel its fine and its visible. For pdf, we are just saving the file as PDF.

2

@lyash

If your funnel chart is appearing empty when exporting from Aspose.Cells to PDF, there are a few steps you can take to troubleshoot the issue:

  1. Check Chart Data: Ensure that the data used for the funnel chart in your Excel file is correctly populated. If the data is missing or incorrectly referenced, the chart will not render in the PDF.

  2. Export Process: Make sure you are following the correct procedure to export the Excel file to PDF. Here’s a basic example of how to do this in Java:

    // Load the Excel file
Workbook workbook = new Workbook("path/to/your/excel/file.xlsx");

// Save the workbook as a PDF
workbook.save("path/to/output/pdf/file.pdf", SaveFormat.PDF);

  3. Library Version: Ensure that you are using the latest version of the Aspose.Cells library. Sometimes, issues are resolved in newer releases, so updating the library might help.

  4. PDF Customization: If you need to customize the PDF output, Aspose.Cells provides options to adjust settings like page size, orientation, and margins. Make sure these settings are appropriate for your chart.

  5. Documentation and Examples: For more detailed guidance, refer to the official Aspose.Cells documentation, which includes comprehensive examples and FAQs that might address your specific issue.

If the problem persists after checking these aspects, consider reaching out to the Aspose support community for further assistance.

Sources:
[1]: Exporting Excel to PDF | Aspose.Cells Java Excel Processing API

4

As of now we are using the version as 17.11 for aspose-cells, aspose.pdf and aspose-words

5

@lyash
The funnel was supported since office 2016, so I am afaid that it was not supported in 17.11.
Please use latest version 24.9.

6

You mean only for PDF? As for excel its visible correctly.

7

@lyash,

Yes, rendering Funnel chart (to image/PDF) in Excel spreadsheet was supported in later versions than v17.11. We recommend upgrading to or trying newer versions of the API if you need to render a Funnel chart to PDF/image.

8

Do we have any way to determine what all has changed between the two versions?

9

@lyash,

Over the years, we have added numerous useful features and improvements specifically designed to enhance the richness, rendering functionality, and robustness of our APIs. Please refer to the Release Notes documents from different years to learn about the new features, enhancements, bug fixes, and API changes that have been incorporated in various versions.

10

Just a QQ, do I need to upgrade aspose-cells as well or aspose-pdf would be good enough?

11

@lyash
If you only need to convert the Excel file to PDF format, upgrading the Aspose.Cells is enough. If you still need to edit PDF document, then you also need to upgrade Aspose.PDF.