Problem Accessing Graphs in Attached Excel File

Aspose.Cells Product Family
1

Hi Team,
I am unable to load all the graphs available in the attached Excel (.xlsx) file. Please refer to the file and assist.
I attached the xlsx file and gif .

graphs_loading_issues.gif (3.2 MB)

graphs_loading_issues.zip (64.4 KB)

2

@sarathepiq

It sounds like you’re having trouble loading all the graphs from your Excel file. Here are a few steps you can take to troubleshoot this issue:

  1. Check File Size and Complexity: If the Excel file is large or contains complex data, it might lead to performance issues. Ensure that your environment has enough memory allocated to handle large files.

  2. Use Memory Preferences: If you’re encountering memory-related issues, consider using memory optimization settings when loading the workbook. You can set memory preferences in your code like this:

    LoadOptions options = new LoadOptions();
options.setMemorySetting(MemorySetting.MEMORY_PREFERENCE);
Workbook workbook = new Workbook("path/to/your/file.xlsx", options);

  3. Verify Graph Types: Ensure that the types of graphs you’re trying to load are supported by the Aspose.Cells library. Some complex chart types may not render correctly.

  4. Update Aspose.Cells: Make sure you are using the latest version of Aspose.Cells, as updates often include bug fixes and improvements.

  5. Check for Corruption: If the file is corrupted, it may not load properly. Try opening the file in Excel to see if it works there. If it does, consider saving it again to a new file.

If you continue to experience issues, please provide more details about the specific errors or behavior you’re encountering. This will help us identify the problem more accurately. Let me know if these steps resolve your issue!

3

@sarathepiq,

Thanks for the template XLSX file and GIF image.

I reproduced the issue when reading the XLSX file into GridJs. I could not load/access the charts into it.

We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSGRIDJS-1818

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

4

hi Sahi,

Any update on this?
Issue ID(s): CELLSGRIDJS-1818

Thank you,
Ganesh Kumar.

5

@Ghani0303,

We apologize for the inconvenience caused. The issue remains unresolved at the moment. Before addressing it, we need to implement enhancements that allow APIs to retrieve data values from the chart. Rest assured, we will keep you updated and share the latest progress on this matter soon.

6

@sarathepiq
let me explain more for this issue.
The root cause is the chart data range is no longger existed in the current spreadsheet file.

78de5cb4-c28e-4abc-a502-5ed2cea79448.png1262×922 38.5 KB
78de5cb4-c28e-4abc-a502-5ed2cea79448.png (38.5 KB)
thus GridJs can not find the required data source normally during rendering.

7

@Ghani0303
For the demand of getting chart cache data( CELLSNET-58957), we plan to support it in the next version (25.10).

8

Thanks for the update, what is the time line for 25.10 version available for users to use it?
Also i observed that in 25.09 version, images and charts are not able to load is this issue also getting resolved in the 25.10 version?
@sarathepiq @leoluo

9

@Ghani0303,

Aspose.Cells 25.10 is scheduled to be released during the first week of October 2025, approximately between the 10th and 15th of the month.

Charts with cached data (linked to external sources) will be addressed in the upcoming release. Regarding the missing images, could you please provide more details along with a sample Excel file? We will review and resolve the issue soon.

1 Like
10

Attached is one of the example where the charts are not getting displayed in 25.09 version as well.
image.png (86.0 KB)

Sample Excel file.zip (50.9 KB)

Please look into the sample file and fix the issue at the earliest.

Looking forward for your support and response.

Thank you,
Ganesh Kumar.

11

@Ghani0303,

Thank you for sharing the template Excel file (containing the charts) and the screenshot.

We have logged the archive to your existing ticket(s). Rest assured, we will try to ensure the fix is included in the upcoming release (v25.10), so that when the template Excel file is loaded into Aspose.Cells.GridJs matrix, the charts are rendered accurately.