在测试Aspose.cells 的过程中,使用IRR计算内部收益率时,发现了有一组数据在Excel2016中可以正确算出结果,而在Aspose中为#NUM!,这组数据是这样的:{-211030557.3,-266410271.8,-266410271.8,-34492567.96,-1270314.464,-1270314.464,-56719475.58,-11332216.14,-14568665.59,9905653.288,68511395.74,90404807.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};
后来有做了一些测试,发现有更多的数据是在Excel2016中可以正常计算,而在Aspose中无法得到计算结果,测试数据如下:
{-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}
这导致Aspose中的结果和Excel中的表现不一致,无法得到客户的认可,希望可以得到帮助,谢谢!