Calculate formula with SUMIF using Aspose.Cells for .NET in C#

Aspose.Cells Product Family
1

Hello,


We have an excel date formula that when computed by Aspose with CalculateFormula gives a different result then the result from excel 2013.

Sample Code:

var workbook = new Workbook(“SUMIF.xlsx”);

System.Console.WriteLine(“INITIAL INPUT”);
System.Console.WriteLine(work.Worksheets[0].Cells[0, 0].Value);
System.Console.WriteLine(work.Worksheets[0].Cells[1, 0].Value);
work.CalculateFormula();
System.Console.WriteLine(“RESULT AFTER CALCULATEFORMULA”);
System.Console.WriteLine(work.Worksheets[0].Cells[0, 0].Value);
System.Console.WriteLine(work.Worksheets[0].Cells[1, 0].Value);

SUMIF.xlsx is attached.

Best regards,
Stefan Botan,
IBM Romania
2

Hi Stefan,


Thank you for contacting Aspose support.

We have evaluated your presented scenario while using the latest version of Aspose.Cells for .NET 8.3.17, and we are able to replicate the said problem on our end. MS Excel calculates the value for the formula in cell A2 as 3, whereas Aspose.Cells for .NET API returns it to be 2. We have logged the problem in our bug tracking system for further investigation under the ticket CELLSNET-43329. Please spare us little time to properly analyze the problem cause, and to provide the fix at earliest possible. In the meanwhile, we will keep you posted with updates in this regard.
3

Hi,

Do you have an update on this?

4

Hi,

Thanks for your posting and using Aspose.Cells.

We are afraid, there is no update for you regarding this issue at this moment. However, we have logged your comment in our database against this issue and requested the product team to provide some ETA or fix for this issue. Once, there is some news for you, we will let you know asap.

5

The issues you have found earlier (filed as CELLSNET-43329) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.