Aspose.Cells : threw an error while uploading empty charts in an .xlsx file."

Aspose.Cells Product Family
1

I received an error message after uploading an .xlsx file that contains empty charts.

Please find the attached gif file.
charts_error.gif (1.3 MB)

I attached the xlsx file also .
charts.zip (16.6 KB)

2

@sarathepiq

Thank you for providing the details and attachments.

I understand that you encountered an issue while uploading an .xlsx file containing charts. Our team will take a close look at the provided files and work on resolving the issue. Here are the next steps for troubleshooting:

Steps to Troubleshoot the Issue:

  1. Update Aspose.Cells to the Latest Version:
    Ensure you are using the latest version of Aspose.Cells. You can download the latest version from our website.

  2. Simplify the Document:
    Try uploading a simplified version of the .xlsx file with minimal charts to identify if specific charts are causing the issue.

  3. Review the Error Message:
    Check the exact error message you received and share it with us. This will help us diagnose the issue more accurately.

  4. Code Example:
    If you have any code that you used to create or manipulate the charts in the .xlsx file, please share it so we can analyze it.

Example of Chart Creation Using Aspose.Cells:

Here is a simple code example to create a chart in an Excel file using Aspose.Cells:

// Create a new workbook
Workbook workbook = new Workbook();

// Access the first worksheet
Worksheet worksheet = workbook.Worksheets[0];

// Add sample data
worksheet.Cells["A1"].PutValue("Category");
worksheet.Cells["B1"].PutValue("Value");

// Add some data points
worksheet.Cells["A2"].PutValue("A");
worksheet.Cells["B2"].PutValue(10);

// Create a chart
int chartIndex = worksheet.Charts.Add(ChartType.Column, 5, 0, 15, 10);

// Bind data to the chart
Chart chart = worksheet.Charts[chartIndex];
chart.NSeries.Add("A2:B2", true);

// Save the workbook
workbook.Save("chart_example.xlsx");
  1. Share the Error Details or GIF:
    Please share the specific error message or include the link to the attached GIF file that shows the error for further investigation.

Aspose.Cells Documentation:

For more information on working with charts in Aspose.Cells, you can refer to our documentation:

If you provide more details or share specific error messages, we can offer more targeted assistance.

3

@sarathepiq,

Thanks for the sample file and GIF image.

I found the issue as you mentioned by using your template XLSX file to be loaded into GridJs. I found Aspose.Cells.GridJs throws error while uploading the XLSX file with empty charts in 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-1779

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.