SUM with XLOOKUP function disappears in sheet

Aspose.Cells Product Family
,
1

We have an xlsm/xlsx file with the function =SUM(XLOOKUP(1,B8,C8):XLOOKUP(3,B9,C9)) which outputs the value. After CalculateFormula, the function turns into a value and the formula disappears.

Code:

var opts = new CalculationOptions
{
    CustomEngine = this
};

workbook.CalculateFormula(opts);

File:
example.xlsx.zip (10.6 KB)

Before CalculateFormula:
image.png (20.4 KB)

After CalculateFormula:
image.png (16.1 KB)

2

@aleksandr.l,

Thanks for the sample file and screenshots.

After initial testing, I am able to reproduce the issue as you mentioned by using your template Excel file. I found SUM with XLOOKUP function disappeared in sheet in the output Excel file after calling Workbook.CalculateFormula() method.

Workbook workbook = new Workbook("e:\\test2\\example.xlsx");
workbook.CalculateFormula();
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-56879

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-56879”) has been resolved. The fix/enhancement will be included in our upcoming release (Aspose.Cells v24.10) that we plan to release in the next few days. You will be notified when new version is published.

4

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