Opening and resaving large Excel file corrupts the document

Aspose.Cells Product Family
1

When the attached file is opened using Aspose.Cells and then immediately resaved, the resulting file cannot be opened by Excel without errors.



When you open the resulting file with Excel, it presents the error message:

We found a problem with some content in ‘Sample.xlsm’. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.



After clicking “Yes”, the document can be mostly recovered, but there are errors reported with three drawing objects. I’ve attached the error log that Excel generated after the recovery.



Is there a way to safely save this file so that it can be reopened in Excel without errors messages?



Thanks,

Michael Whalen

2

Hi Michael,

Thanks for your posting and using Aspose.Cells.

We were able to replicate this error as mentioned by you by opening and resaving your xlsm file using the latest version: Aspose.Cells
for .NET v8.6.1.2. The output xlsm file gets corrupt and does not open in Microsoft Excel.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-44043 - Opening and resaving large Excel file corrupts the document

I have also attached the output xlsm file for a reference.

C#
String filePath = “D:\Downloads\Sample.xlsm”;

Workbook workbook = new Workbook(filePath);
workbook.Save(filePath + “.out.xlsm”);

3

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSNET-44043 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

4

The issues you have found earlier (filed as CELLSNET-44043) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.