Aspose.Cells - Regression bug causing pivot table corruption

Aspose.Cells Product Family
1

Hi,

We are are using Aspose.Cells (NET), version 25.8.0. We’re trying to save a .xlsx file with pivot tables, and it gets saved as a corrupted file requiring recovery. This did not occur on previous versions (tested at 25.3.0).

All we do is open the workbook and save the workbook.

ExcelCorrupter.7z (656.0 KB)

Attached is a small program with an example of the file getting corrupted after save.

Thanks,
Oded Belahousky

2

@oded.b

Hi Oded,

It appears you are facing a regression issue with pivot tables in Aspose.Cells version 25.8.0, which is resulting in the saved .xlsx file becoming corrupted. This issue likely stems from changes made in the newer version, as it did not occur in version 25.3.0.

To address this issue, please follow these steps:

  1. Check for Updates: Ensure you are using the latest version of Aspose.Cells. Upgrading to the most recent version may resolve the issue, as bugs are often fixed in subsequent releases.

  2. Test with Different Files: Save different Excel files with pivot tables to determine if the issue is specific to your current file or if it occurs across all files.

  3. Review Your Code: Verify that your code for opening and saving the workbook is correct. Here’s a minimal example to ensure you are using the proper approach:

    Workbook workbook = new Workbook("path_to_your_file.xlsx");
workbook.Save("path_to_save_file.xlsx");

  4. Check Pivot Table Data: Confirm that the data source for your pivot tables is intact and correctly formatted. Corruption can occur if the data is not structured properly.

  5. Contact Support: If the issue persists after trying the above steps, reach out to Aspose support with your findings, including the sample program you provided. They may offer additional insights or a workaround.

Please let me know if these steps help resolve the issue or if you require further assistance. I’m here to help!

Best regards!

3

@oded.b,

Thanks for the template XLSX file and sample app.

After initial testing, I am able to reproduce the issue as you mentioned by just opening your template XLSX file and saving it back via Aspose.Cells. I found the output file is corrupted and MS Excel prompts error message(s) when opening the output file into it.

Workbook workbook = new Workbook("e:\\test2\\test.xlsx");
workbook.Save("e:\\test2\\out1.xlsx");

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): CELLSNET-58900

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

@oded.b,

We would like to notify you that your issue (Ticket ID: “CELLSNET-58900”) has been resolved. The fix or enhancement will be incorporated in our next release (Aspose.Cells v25.9), which is scheduled for the first half of September 2025. You will receive a notification once the new version is released.

5

@amjad.sahi Is there a more specific date for the Sep release?

6

@TsahiB.Datarails,

The exact release date might not be confirmed as releases are published once finalized or ready. However, you can expect the release (Aspose.Cells v25.9) during the second week of September 2025, likely between the 10th and 15th.

Hope, this helps a bit.

7

The issues you have found earlier (filed as CELLSNET-58900) have been fixed in this update. This message was posted using Bugs notification tool by leoluo