Error with NUMBERVALUE Formula

Aspose.Cells Product Family
1

Team,

We’re seeing an inconsistency between Microsoft Excel and Aspose Cells. The NUMBERVALUE formula with string argument “00:25” returns 0.017361111 in Excel, but #VALUE in Aspose. The attached input file and output file show the behavior.

Reproduce with code:

var filename = @"NumberValueError.xlsx";
var workbook = new Workbook(filename);
workbook.CalculateFormula();
workbook.Save(@"NumberValueError_output.xlsx");

Files.zip (13.1 KB)

Thank You,
-Andy

2

@weissa
Through testing, we are able to reproduce the issue. Discovered incorrect data obtained after calculating the NUMBER VALUE formula.
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-53789

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

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