Aspose.Cells - Assigning formulas corrupts Excel

Aspose.Cells Product Family
1

I perform the actions: reassign formulas, this action occurs without error.
Then for some reason the file cannot be opened through Excel. The file is corrupted.
If I restore the file, the formulas are broken.

Aspose.Cells: 25.4.0
.NET: 9.0

If I do this on version 25.3.0 then the cells with formulas remain empty.

var input = @"C:\input.xlsx";
var output = @"C:\output.xlsx";
            
var workbook = new Workbook(input);
var ws = workbook.Worksheets.First();
var table = ws.ListObjects.First();
foreach (var col in table.ListColumns)
{
    if (col != null)
    {
        var cellToApply = col.Range[1, 0];
        if (cellToApply is {Formula: not null }) 
            col.Formula = cellToApply.Formula; // <-- I think Problem here
    }
}
            
workbook.CalculateFormula();
workbook.Save(output);

image.png (66.6 KB)
input.zip (12.6 KB)

2

@aleksandr.l
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-58247

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

@aleksandr.l,

This is to inform you that your issue (Ticket ID: “CELLSNET-58247”) has been resolved. The fix/enhancement will be included in the upcoming release (Aspose.Cells v25.5) which we plan to release in the first half of May 2025. We will notify you when the next release is published.

4

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