1. IRR as in Office 2010
I noticed that Aspose fails to calculate an IRR value, where Excel 2010 succeeds. Excel 2007 and previous fail, also. Please open the attached XLSX-file in Excel 2010 and Excel 2007 to see this.
Perhaps is this due to the fact that Microsoft has changed the way IRR is calculated, as described here: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_6535-An-overview-of-using-NPV-and-IRR-in-Excel-for-evaluating-investment-decisions.html
Anyway, this is a problem for us, since our customer is using Office 2010, and they would like to see the exact result when we calculate using Aspose as they do when running Excel.
Now, to complicate things, we have other customers that use earlier versions of Office, and it would be great if it was possible to somehow tell Aspose which version of the IRR calculation to work with. This is not necessary, though.
2. Recent bug-fixes
I saw that an IRR bugfix was released here: http://www.aspose.com/community/forums/thread/426437/workbook.calculateformula-doesn-t-compute-irr-correctly-for-second-irr-calculation.aspxhttp://www.aspose.com/community/forums/thread/426437/workbook.calculateformula-doesn-t-compute-irr-correctly-for-second-irr-calculation.aspx
We are currently using 18.104.22.168 of Aspose, and it is working great for us, and thus we are reluctant to upgrade to new versions of Aspose, since in the past some changes have broken things for us.
However, we need to make sure we get relevant bugfixes for us, and since we are now working with IRR, we need to check this specifically.
So, can I get more detailed information on what IRR fixes have been released since 22.214.171.124? I need this information to decide whether or not we need to upgrade or not.