DSUM formula issue

Aspose.Cells Product Family
1

Hi,

The DSUM formula from Excel is not resolved correctly in
certain situations. In the attached file, ShortTest.xlsx, the cell F7
contains a DSUM 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[“F7”];
var value = cell.Value;
var stringValue = cell.StringValue;

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

The variable StringValue is 0.

This wrong behavior seems to be triggered when the value in the criteria cell (in the example the cell B7) starts with “0” ( in the example “01”).

Regards,
Lucian Nistor
Senior Software Developer
IBM Romania

2

Hi,

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

We were able to notice this issue using the latest version with your given code. The calculated value of f7 is wrong. 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-41868.

3

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.

4

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

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

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan