Free Support Forum -

Incorrect PPMT execution result

Formula: =PPMT(0,005833333;3,6;12;-1750;0;0)
Aspose result: 143.69915167651834
Expected result: 143.365216572828
c# validation code: Microsoft.VisualBasic.Financial.PPmt(0.005833333,3.6,12,-1750,0,0)


Please notice, I am able to reproduce the issue as you mentioned. I found that there is difference b/w the calculation results for PPMT formula of MS Excel Vs Aspose.Cells.
Sample code:

Workbook wb = new Workbook();
Worksheet worksheet = wb.Worksheets[0];
string formula = "=PPMT(0.005833333,3.6,12,-1750,0,0)";
object value = worksheet.CalculateFormula(formula);

I have logged a ticket with an id “CELLSNET-47731” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.


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

Your issue should be resolved.

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