MS Excel shows two error notifications while opening XLS file after XLS-XLSM-XLS conversion

Aspose.Cells Product Family
1

Hi, Aspose team.

Issue (actual behavior): Aspose.Cells 24.7. MS Excel shows two error notifications while opening XLS file after it was XLS-XLSM-XLS converted. See screenshots.

  • There isn’t enough memory to complete this action. Try using less data or closing other applications.
  • File error: data may have been lost.

Other details: XLS is encrypted. Microsoft® Excel® for Microsoft 365 MSO (Version 2406 Build 16.0.17726.20078) 64-bit

issue3.zip (2.2 MB)

var filePath = "issue3.xls";
var resultFilePath = filePath + ".xlsm";

using (var wb = new Workbook(filePath, new LoadOptions(LoadFormat.Excel97To2003)
       { Password = "test", }))
{
    wb.Settings.Password = null;
    wb.Save(resultFilePath, SaveFormat.Xlsm);
}
using (var wb = new Workbook(resultFilePath, new LoadOptions()))
{
    wb.Settings.Password = "1";
    wb.Save(resultFilePath + ".xls", SaveFormat.Excel97To2003);
}

For internal reference: MDP-18515.

Thanks.

2

@oleksii88
By testing with sample files and code on the latest version v24.7, we can observe issues, but there are some differences from the screenshot information you provided. Please refer to the attachment.
result.zip (3.3 MB)

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-56343

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.

3

@oleksii88,

We are pleased to inform you that your issue (Ticket ID: “CELLSNET-56343”) has been resolved. The fix will be included in our upcoming release (Aspose.Cells v24.8) which we plan to release in the first half of August 2024. We will notify you when the next release is published.

4

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