Difference between excel and Aspose.Cells

Aspose.Cells Product Family
1

the following function argument is not supported by aspose but is valid in excel
=RANDBETWEEN(0;4294967295)

will throw exception:

Aspose.Cells.CellsException: ‘ArgumentOutOfRangeException: ‘minValue’ cannot be greater than maxValue.
Parameter name: minValue(Based on cell Sheet1!A1)’

reproduce issue:

        var workbook = new Workbook();
        workbook.Worksheets[0].Cells["A1"].Formula = "=RANDBETWEEN(1,4294967295)";
        workbook.CalculateFormula();
        double result = (double)workbook.Worksheets[0].Cells["A1"].Value;
        Assert.IsTrue(result <= 4294967295 && result >= 1);
2

@Pietswieb,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-47305 – RANDBETWEEN() raises exception ArgumentOutOfRangeException

3

@Pietswieb,

Please try our latest version/fix: Aspose.Cells for .NET v20.4.3 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.4.3 For .Net2_AuthenticodeSigned.Zip (5.3 MB)
Aspose.Cells20.4.3 For .Net4.0.Zip (5.3 MB)

4

The issues you have found earlier (filed as CELLSNET-47305) have been fixed in Aspose.Cells for .NET v20.5. This message was posted using Bugs notification tool by Amjad_Sahi