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.