Caculate Formula causes some cells to return #REF value, where Excel does not

Aspose.Cells Product Family
1

PFA Workbook (2.5 MB)

Sample code:

        var workbook = new Aspose.Cells.Workbook(@"02_Investment Template v01.00 - 04.29.25.xlsx");
        var worksheet = workbook.Worksheets["EDA"];

        var valueBefore = worksheet.Cells["CJ4"].Value;
        var options = new CalculationOptions
        {
            CustomEngine = null,
            IgnoreError = true,
            PrecisionStrategy = CalculationPrecisionStrategy.Decimal
        };

        workbook.CalculateFormula(options);
        var valueAfter = worksheet.Cells["CJ4"].Value; //#REF

The same thing happens if workbook.RefreshDynamicArrayFormulas(true, options); is called instead of workbook.CalculateFormula(options);

Thanks,
Dean

2

@Moonglum
We found there are some cells that are calculated as different values from ms excel. We need to investigate them further. 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-58331

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

@Moonglum,

We are pleased to inform you that your issue (Ticket ID: “CELLSNET-58331”) has been resolved. The fix/enhancement will be included in our upcoming release (Aspose.Cells v25.6) that we plan to release in the first half of June 2025. You will be notified when the next version is published.