Free Support Forum - aspose.com

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)

@abulaev,

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.
e.g.
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.

@abulaev,
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.

@abulaev,

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)