Incorrect value for a formula using LET MAP and LAMBDA

Aspose.Cells Product Family
1

Hi,
Using the Aspose.Cells version 24.10.0 on this test Excel workbook:

TestCase13.zip (11.7 KB)

I have a formula in Output!E11 that looks like this:

=LET(W,Input!$W$4:$W$14,X,Input!$X$4:$X$14,F,Input!$F$4:$F$14,AA,Input!$AA$4:$AA$14,SUM(MAP(W,X,F,AA,LAMBDA(iW,iX,iF,iAA,iW+iX+iF+iAA))))

Excel calculates the cell value as 649954.1 but the following code calculates the value incorrectly as 56449.

 var workbook = new Workbook( "TestCase13.xlsx");
 Worksheet worksheet = workbook.Worksheets["Output"];

 workbook.CalculateFormula();

 Cell cell = worksheet.Cells["E11"];
 var value = cell.DoubleValue;

 if (value != 649954.1)
 {
     throw new ArgumentException("Output!E11 value should be 649954.1.");
 }

Can you please have a look? Thanks very much.

2

@llawryy
By using sample file and code for testing on the latest version v24.10, we can reproduce the issue. After calling the formula calculation, the incorrect value was obtained using the formulas of LET MAP and LAMBDA.

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

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

@llawryy,

We are pleased to inform you that your issue (Ticket ID: “CELLSNET-57009”) has been resolved. The enhancement/fix will be included in an upcoming release (Aspose.Cells v24.11) that we plan to release in the first half of November 2024. You will be notified when the next version is released.

4

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