We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Sumifs formula issue

Hi,

The SUMIFS formula from Excel is not resolved correctly in certain situations. In the attached file, ShotTest.xlsx, the cell F24 contains a SUMIFS formula that is resolved correctly in Excel but when it is evaluated with Aspose, it evaluates to 0.

The code to reproduce the problem is:

var wb = new Workbook(@“C:\ShortTest.xlsx”);
wb.CalculateFormula(true);

var cell = wb.Worksheets[“Sheet1”].Cells[“F24”];
var value = cell.Value;
var stringValue = cell.StringValue;

Console.WriteLine(“F 24 " +” value : " + value + " | stringValue :" + stringValue);

The variable StringValue is 0.

Regards,
Lucian Nistor
Senior Software Developer
IBM Romania

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue with the latest version. The sumifs is not giving correct value when the calculateformula method is used. We have logged this issue in our database. We will look into it and resolve this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41856.

Hi,

I want to make a few remarks on this issue. It seems to occur every time we have a text with the form x/y, where x and y are integers and y <= 12.

Regards,
Lucian Nistor
Senior Software Developer
IBM Romania

ibmromania:
Hi,

I want to make a few remarks on this issue. It seems to occur every time we have a text with the form x/y, where x and y are integers and y <= 12.

Regards,
Lucian Nistor
Senior Software Developer
IBM Romania
Hi,

Thanks for your additional information and using Aspose.Cells for .NET.

We have logged your provided information in our database for consideration. We will look into it and once, there is some update for you, we will let you know asap.

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have fixed the issue.

Please download and try this fix: Aspose.Cells for .NET v7.5.1.3 and let us know your feedback.