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

Free Support Forum - aspose.com

Aspose.cells On IRR calculation

Hello,

I’m using it Aspose.cells When IRR is used to calculate internal rate of return, it is found that there is a group of data that can be correctly calculated in excel2016, while it is ‘ #num!’ In Aspose. The data are as follows:
{- 211030557.3, - 266410271.8, - 266410271.8, - 34492567.96, - 1270314.464, - 1270314.464, - 56719475.58, - 11332216.14, - 14568665.599905653.28868511395.7490404807.71, 113434356.8,51264503.08,103961533.6,96827882.3,129465580.8,133449059.7,125152736.7,111266043,99157574.89,68453297.87,9291641.541,-2360636.855,-13401423.3,-23749074.52,-9054058.407,-10142058.66,-36137352.56,-9380853.492,-2449708.353,-2449708.353,-372976.4904,-372976.4904,-372976.4904,29888566.46,8297305.825,48506652.65,33500101.57,18680354.04, 11208212.42,7409873.768,0,0,0,0,0,0,-22540262.57,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};

Later, some tests were conducted, and it was found that more data can be calculated normally in excel2016, but the calculation results cannot be obtained in Aspose. The test data are as follows:

{-1204,-674,-147,40,547,26,1499,550,-858,-754,-975}

{998,-486,-572,-8,765,-794,1033,392,91,-615,804}

{957,-609,-418,413,855,-865,1249,-454,719,-901,946}

The results in Aspose are inconsistent with those in Excel, so we can’t get customers’ approval. We hope we can get help. Thank you!

@ivanhu2013,
Please check our reply here and let us know your feedback.

@ivanhu2013,

Please try our latest version/fix: Aspose.Cells for .NET v20.9.7 (attached)
Aspose.Cells20.9.7 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.9.7 For .Net4.0.Zip (5.4 MB)
Aspose.Cells20.9.7 For .NetStandard20.Zip (5.4 MB)

Your issue should be fixed in it.

Let us know your feedback.

The issues you have found earlier (filed as CELLSNET-47611) have been fixed in Aspose.Cells for .NET v20.10. This message was posted using Bugs notification tool by Amjad_Sahi. You may also get the version @ Nuget repos. (https://www.nuget.org/packages/Aspose.Cells/20.10.0).